4 Replies Latest reply on Oct 31, 2012 2:07 AM by jamit

    How to add Extension properties to VDB using Teiid Designer.

    jamit

      I have been through the documentation for MED (Model Extension Development) using teiid designer and also created a sample.mxd file for my project.With this I am able to add the properties from sample.mxd to my current models.But,now I have some custom properties at VDB level and would like to know whether we have any extension framework to add user defined properties at VDB level.

      The vdb earlier was a dynamic vdb and hence it was easy to add such properties at VDB level.

      Also would like to know if its possible to do using teiid designer.

        • 1. Re: How to add Extension properties to VDB using Teiid Designer.
          rareddy

          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

            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

              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)

              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?

              https://issues.jboss.org/browse/TEIIDDES-472

              1 of 1 people found this helpful
              • 4. Re: How to add Extension properties to VDB using Teiid Designer.
                jamit

                Thanks Ramesh for the prompt support.