Connecting IA to Netezza

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
U
Participant
Posts: 230
Joined: Tue Apr 17, 2007 8:23 pm
Location: Singapore

Connecting IA to Netezza

Post by U »

Can someone please outline the process for connecting Information Analyzer to a Neteeza data source? There does not appear to be an ODBC driver for Netezza installed with the Information Server suite.

Thank you for your time.
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Generally, the native connector stage is preferred over ODBC. I always reserve ODBC as a second choice. Try using the IBM Netezza Connector. You should be able to setup a connection from IMAM, or from IA via the Import Metadata task, which takes you to IMAM.
Choose a job you love, and you will never have to work a day in your life. - Confucius
arvind_ds
Participant
Posts: 428
Joined: Thu Aug 16, 2007 11:38 pm
Location: Manali

Post by arvind_ds »

Alternatively if you want to use odbc driver to connect to netezza, then you need to install netezza client first on your datastage engine machine. Once you install netezza client, the odbc driver will be installed along with it for netezza. Use that driver and define a connection in .odbc.ini file for netezza connectivity.
Arvind
Post Reply