[teiid-issues] [JBoss JIRA] Commented: (TEIID-1328) API request: Programatically modify the VDB

[Steven Hawkins (JIRA)]

    [ https://jira.jboss.org/browse/TEIID-1328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12560357#action_12560357 ] 

Steven Hawkins commented on TEIID-1328:
---------------------------------------

We've been contemplating this on our long term road map for a while.  SQL/MED with some Teiid specific extensions would provide a mechanism for DDL based definition of translators/foreign schemas or tables.  While updates to a dynamic vdb deployment file can approximate VDB updates, it's less than ideal (triggers a full redeployment, requires a full write out of the file, needs alternative deployment path to update all nodes a cluster, etc.).  We may want to have an operational repository that acts more like traditional database before baking this functionality directly into Teiid.

> API request:  Programatically modify the VDB
> --------------------------------------------
>
>                 Key: TEIID-1328
>                 URL: https://jira.jboss.org/browse/TEIID-1328
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: AdminApi
>    Affects Versions: 7.1
>            Reporter: Mark Addleman
>            Assignee: Steven Hawkins
>            Priority: Minor
>
> I'd like an API to programatically modify the VDB.  It would be ideal to modify the VDB using DDL through Teiid.  Our primary use case is accessing a dynamic set of datasources through Teiid.  When a datasource is added, we would INSERT the appropriate entries into MODEL, PROPERTIES, DATASOURCES tables.  Teiid would reread the appropriate metadata from the associated translators.  

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira