Netezza with Informatica 1

[naveends]

Hi Guys,

Please need your help.

Out target is Netezza database, source is .csv file, using Informatica 8.6.0.

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

Should i need to add any drivers or how do i get it.

Thanks,

 

[rasETL]

Yes - you need to Register what Informatica refers to as a "PLUG-IN" ...

1.Log into the Administration Console
2.Restart the Repository Service in Exclusive mode
3.Click the Repository Service button
4.Click the Plug-ins tab
5.Register the plug-in pmnetezza.xml found in server/bin/Plugin directory
6.After registration succeeds, restart the repository in Normal mode
7.Restart the PowerCenter Designer
8.Import the tables

 

[naveends]

Thank You Sir,

Today I will install Netezza database and then get back to you.

Thanks,

 

[naveends]

Hi,

We are using Informatica version 9.1.0 Hotfix2, we should still need to add the Plug-in for Netezza.

Thanks,

 

[rasETL]

Yes - To the best of my knowledge, registering a Plug-in is required for any version.