Informatica 8.6.0 with Netezza database

Question

Our target is a Netezza database. Our source is a .csv file. We are using Informatica 8.6.0.

In the workflow manager, in the Relational Connection Browser, I am not able to get Netezza as the Database.

Do need to add any drivers? How do i get it to show up?

Answer 1

You need to define your Netezza server properties inside Informatica's ODBC directory, something like below

[NZ_CONNECTION_NAME]
Driver                = /opt/informatica/nz/lib/libnzsqlodbc3.so
Description           = NetezzaSQL ODBC
Servername            = nz_host_name_or_ip_address
Port                  = 5480
Database              = group_generic_dims
Username              = nz_db_username
Password              = nz_db_password
CancelAsFreeStmt      = false
CommLog               = false
Ksqo                  = false
Lie                   = false
Optimizer             = false
Parse                 = false
PreFetch              = 256
Protocol              = 7.0
ReadOnly              = false
ShowSystemTables      = false
Socket                = 16384
DateFormat            = 1
TranslationDLL        =

Make sure you're pointing to the right libnzsqlodbc.so file (the driver).