top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica 8.6.0 with Netezza database

+1 vote
345 views

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?

posted Nov 6, 2014 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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).

answer Nov 10, 2014 by Shweta Singh
Similar Questions
+1 vote

I get this error at the moment of create domain on informatica Powercenter 8.6.1 silent install :

Informatica PowerCenter 8.6.1

Cannot create domain.

The installer could not create the domain. Correct the error below and select
Retry. You must successfully create the domain to continue the installation.
DEFINE_NODE_STDOUT:
DEFINE_NODE_STDERR:java.lang.UnsatisfiedLinkError: pmjrepn (A parameter must be a directory.)
at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:952)
at java.lang.ClassLoader.loadLibraryWithClassLoader(ClassLoader.java:921)
at java.lang.System.loadLibrary(System.java:452)
        at com.informatica.powercenter.sdkint.repository.ILocaleManager.<clinit>(ILocaleManager.java:38)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:187)
        at
com.informatica.pcsf.infacmd.InfaCmdMainLoop.mainLoop(InfaCmdMainLoop.java:100)
at com.informatica.pcsf.infacmd.InfaSetupMain.main(InfaSetupMain.java:34)
Exception in thread "main" java.lang.UnsatisfiedLinkError: pmjrepn (A parameter
must be a directory.)
at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:952)

Any ideas?

...