This content has been marked as final.
Show 1 reply
-
1. Re: Runtime Binding for Teiid Source Models
rareddy Feb 21, 2013 1:00 PM (in response to tanmoypalit)Tanmoy,
Yes. You can create a Dynamic VDB (it is just a XML file) using the DDL for metadata for your source and deploy it using Admin API into Teiid. Once you deploy it, then you can access it using JDBC connection to the VDB.
example (loopy-vdb.xml)
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vdb name="Loopy" version="1"> <property name="UseConnectorMetadata" value="true" /> <model name="MarketData"> <source name="text-connector" translator-name="loopback" /> <metadata type="DDL"><![CDATA[ CREATE FOREIGN TABLE G1 (e1 string, e2 integer); ]]> </metadata> </model> </vdb>
If need to drive all these programmatically you can do that too.
Ramesh..