2 Replies Latest reply on Jul 14, 2010 10:22 AM by ab.jeevagunta

    Dynamic VDB in Teiid 7.0

    ab.jeevagunta

      Hi,

       

      With respect to the below article titled "Dynamic VDB in Teiid 7.0"

       

      http://community.jboss.org/wiki/DynamicVDBinTeiid70

       

      Can I deploy this dynamic vdb through Admin API using addVDB method? In one of the previous threads it was mentioned that, we need to archive the .def file so that addVDB recognizes it as a valid vdb archive (not sure if it is applicable for only previous releases). Can we do the same in 7.0, archive the <name>-vdb.xml and use the Admin API to deploy dynamically?

       

      Thanks in advance,

      Abraham

        • 1. Re: Dynamic VDB in Teiid 7.0
          rareddy
          Can we do the same in 7.0, archive the <name>-vdb.xml and use the Admin API to deploy dynamically?

          Yes. You would supply the Dynamic VDB XML file instead of the <name>.vdb file that is created with Designer. The name you specify in the "deployVDB" method on the admin API must be in the form "<name>-vdb.xml". The "<name>" should match with the name inside the XML file. The format of this file is backed by a schema file "vdb-deployer.xsd", which is included with kit and also in the teiid-client-{version}.jar.

           

          There has been similar request before, check out my comment on the JIRA on how you can create this XML file from existing class. (Just note that there is no guarantee that this class will not change in future releases as this is not part of the public API, but this class is available in the above mentioned client jar. So, you can use it.

           

          https://jira.jboss.org/browse/TEIID-1082

           

          You also correct that except for the LDAP, all the provided translators support dynamic metadata. Please note that, using the Dynamic VDB approach, you will not be able to create view layers as you may have done with Teiid Designer. Check out documentation on Dynamic VDB in the Reference Guide.

           

          Let us know how this works.  We would love hear more about how you solved your data integration issue with Teiid in blog post.

           

          Thanks.

           

          Ramesh..

          • 2. Re: Dynamic VDB in Teiid 7.0
            ab.jeevagunta

            Thank you very much for the detailed info on this. I will try it and will let you know.

             

            Thanks once again,

            Abraham