3 Replies Latest reply on Apr 13, 2017 12:56 PM by Van Halbert

    How to add netezza native model to teiid.

    Kulbhushan Chaskar Master

      Hi,

       

      I am trying to add native model in vdb for netezza database but vdb goes into the loading state and not came into the active status.

       

      VDB Content:-

      <?xml version="1.0" ?><vdb name="SvcSourceVdb_netezzaNew" version="1"><description>VDB for: SvcSourceVdb_netezzaNew, Version: 1</description><connection-type>BY_VERSION</connection-type><model name="netezzaNew" type="PHYSICAL" visible="true"><property name="importer.tableTypes" value="TABLE"></property><source name="netezzaNew" translator-name="netezza" connection-jndi-name="java:/DSNETEZZA20170412175644083"></source></model><model name="netezzaNewNative" type="PHYSICAL" visible="true"></property><source name="netezzaNewNative" translator-name="netezza-native" connection-jndi-name="java:/DSNETEZZA20170412175644083"></source></model><translator name="netezza-native" type="netezza"><property name="SupportsDirectQueryProcedure" value="true"></property></translator></vdb>

       

      If I removed netezzaNewNative model then SvcSourceVdb_netezzaNew it gets activated.

       

      Note: I am using teiid 9.1.3 and same version of admin api client.

       

      Thanks,

      Kulbhushan Chaskar.

        • 1. Re: How to add netezza native model to teiid.
          Van Halbert Master

          Kulbhushan,

           

          In the above vdb xml, it appears you have a mis-aligned property - "</propery>" in the netezzaNewNative.    I assume that was originally suppose to be the matching property for "importer.tableTypes"?  

           

          Van

          • 2. Re: How to add netezza native model to teiid.
            Kulbhushan Chaskar Master

            Thanks Van,

             

            <?xml version="1.0" ?><vdb name="SvcSourceVdb_netezzaNew" version="1"><description>VDB for: SvcSourceVdb_netezzaNew, Version: 1</description><connection-type>BY_VERSION</connection-type><model name="netezzaNew" type="PHYSICAL" visible="true"><property name="importer.tableTypes" value="TABLE"></property><source name="netezzaNew" translator-name="netezza" connection-jndi-name="java:/DSNETEZZA20170412175644083"></source></model><model name="netezzaNewNative" type="PHYSICAL" visible="true"><property name="importer.tableTypes" value="TABLE"></property><source name="netezzaNewNative" translator-name="netezza-native" connection-jndi-name="java:/DSNETEZZA20170412175644083"></source></model><translator name="netezza-native" type="netezza"><property name="SupportsDirectQueryProcedure" value="true"></property></translator></vdb>

             

            Tried with this vdb still facing same problem.

            • 3. Re: How to add netezza native model to teiid.
              Van Halbert Master

              Can you attach the server log?

               

              Van