Netezza Connectivity - DataStage vs Information Analyzer

Aruna Gutti · Post by **Aruna Gutti** » Wed Nov 14, 2007 7:41 am

Hi,

I am trying to find anyone who sucessfully connected Netezza to Information Analyzer.

We recently installed IBM Information Server and I am trying to connect to Netezza Performance Server. I successfully Connected to Netezza and retrieved Metadata from DataStage. But the same connection information is not working for Information Analyzer. I am getting 'Connection Failed' Error when trying to create a new DataStore.

I changed the server name to IP address in the odbc.ini file as per IBMs suggestion and it is still not working.

If anyone connected Netezza to Information Analyzer and DataStage successfully could you please let me know a solution.

Many Thanks,

Aruna.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 14, 2007 3:41 pm

Try doing an ODBC trace on both to learn how they handle the connection differently.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 14, 2007 3:42 pm

Try doing an ODBC trace on both to learn how they handle the connection differently.

Aruna Gutti · Post by **Aruna Gutti** » Thu Nov 15, 2007 10:46 am

Hi Ray,

The trace file is not getting created for adding a DataStore in Netezza Server.

Thanks,

Aruna.