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

[Mark Addleman (JIRA)]

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

Mark Addleman commented on TEIID-1328:
--------------------------------------

Of course, I know very little about the details of Teiid internal representation, but it seems to me the internal model can be described in a variety of external forms including VDB file, VDB XML and SQL/MED DDL.  For my own, selfish, purposes, I'd like SQL/MED to be the primary external form with all other forms mapping to it.  I would expect that executing SQL/MED DDL statements would dynamically update the internal Teiid model.

In terms of implentation priorities, it is more important for our project that Teiid supports adding and removing data sources.  Right now, we approximate view definitions in our own recursive translator.

> 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.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira