2 Replies Latest reply on Jan 28, 2013 7:04 PM by Daniel Caros

    How to override built-in translator properties for Dyanmic VDB

    Daniel Caros Newbie

      I am using Teiid 8.2 and have a Dynamic VDB that defines two physical models to use the default sqlserver translator, but want to override the MaxDependentInPredicates property value that is used in this translator. Below is what I have for the model and trying to define the translator override, but get a parsing excpetion when trying to deploy. Not sure on the correct syntax to setup the override and let me know if more info is needed.

       

      Thanks,

      Danny

       

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

      <vdb name="Scalability" version="1">

         

          <property name="UseConnectorMetadata" value="cached" />

       

          <translator type="sqlserver" name="sqlserver-override">
              <property value="2" name="MaxDependentInPredicates"/>
          </translator>

       

          <model visible="false" type="PHYSICAL" name="UsersDb">
              <property name="importer.useFullSchemaName" value="true"/>
              <property name="importer.importKeys" value="true"/>
              <property name="importer.importIndexes" value="true"/>
              <source name="UsersDb" translator-name="sqlserver-override" connection-jndi-name="java:/UsersDb"/>
          </model>

       

          <model visible="false" type="PHYSICAL" name="TicketsDb">
              <property name="importer.useFullSchemaName" value="true"/>
              <property name="importer.importKeys" value="true"/>
              <property name="importer.importIndexes" value="true"/>
              <source name="TicketsDb" translator-name="sqlserver-override" connection-jndi-name="java:/TicketsDb"/>      
          </model>

      ...