-
1. Re: How to add Extension properties to VDB using Teiid Designer.
rareddy Oct 29, 2012 9:03 AM (in response to jamit)Amit,
Teiid Designer does not help in building a Dynamic VDB currently, it generates a VDB archive which is binary file that can be only understood by Teiid engine. Dynamic VDB is a XML file, so you can edit with any editor. See the vdb.xml's schema file in teiid-xxx-jdbc.jar jar or https://github.com/teiid/teiid/blob/master/client/src/main/resources/vdb-deployer.xsd
Now, if you are adding custom properties to the VDB or models they will not get used by any components in the Teiid automatically, as they have no idea of their existence. Currently if you add any custom properties at VDB level, there is no extension point in the Teiid engine to make use of them unless may be you can write a custom translator.
Now extension properties on your model is completely different, here you are adding custom properties to your model, view, procedure etc. See https://docs.jboss.org/author/display/TEIID/DDL+Metadata and see "OPTIONS" property on every language construct. If you add custom properties in these, then you have to either extend a translator or write a new translator to make use of those custom properties. Check out https://docs.jboss.org/author/display/TEIID/Developer%27s+Guide for how to write a custom translator.
After all the above, may be it is important to know what you are trying to achieve? There may be simpler workarounds?
Thanks. hope above helps.
Ramesh..
-
2. Re: How to add Extension properties to VDB using Teiid Designer.
jamit Oct 29, 2012 9:36 AM (in response to rareddy)Hi Ramesh,
Thanks for your reply,it is very helpful, but may be I need to provide some more information here to clear the problem statement:
We are already using dynamic vdbs and also have a custom translator with custom properties set in the vdb manually.
1) The requirement is to support these properties for static vdbs,so someone who wants to create a vdb using Teiid Designer should have these properties as extension properties.
I think this can be achieved by creating a .mxd file.(correct me if I am wrong)
2) On top of this we have Multi-source VDBs and also few properties added at the VDB level ie at "UseConnectorMetadata" level (outside the model tag) in the vdb.
We need some way by which we can add these properties via teiid designer.
4) Lastly: Does the Teiid Designer support the "supports-multi-source-bindings" property to be added via designer rather than editing the vdb.xml manually?
Thanks
Amit.
-
3. Re: How to add Extension properties to VDB using Teiid Designer.
rareddy Oct 29, 2012 11:42 AM (in response to jamit)1 of 1 people found this helpful1) The requirement is to support these properties for static vdbs,so someone who wants to create a vdb using Teiid Designer should have these properties as extension properties.
I think this can be achieved by creating a .mxd file.(correct me if I am wrong)
Correct
2) On top of this we have Multi-source VDBs and also few properties added at the VDB level ie at "UseConnectorMetadata" level (outside the model tag) in the vdb.
We need some way by which we can add these properties via teiid designer.
There is VDB Properties panel in the VDB builder, but it does not ability to add custom properties. You can add Teiid Designer JIRA for this.
4) Lastly: Does the Teiid Designer support the "supports-multi-source-bindings" property to be added via designer rather than editing the vdb.xml manually?
-
4. Re: How to add Extension properties to VDB using Teiid Designer.
jamit Oct 31, 2012 2:07 AM (in response to rareddy)Thanks Ramesh for the prompt support.