How to add netezza native model to teiid.

[kulbhushanc]

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.

[van.halbert]

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

[kulbhushanc]

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.

[van.halbert]

Can you attach the server log?

Van