Oracle BIP JDBC Connection To Netezza Database Not Working
Last updated on OCTOBER 09, 2015
Applies to:BI Publisher (formerly XML Publisher) - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 11.1]
Information in this document applies to any platform.
in BI Publisher 184.108.40.206:
1a. The seeded application does not include the Netezza database in the JDBC Data Source driver type List of values (LOV).
1b. The 220.127.116.11 Certification does include Netezza with version 7.0 and 6.0 using 'Netezza Native Driver'.
2. Customer used Oracle documentation to update the WLS Classpath for 3rd party jdbc drivers:
"Fusion Middleware Configuring and Managing JDBC Data Sources for Oracle WebLogic Server 10.3.6"
3. After performing #2, and then creating a Data Source entry for Netezza which uses driver type: Netezza 4.x and driver class: org.netezza.Driver,
selecting the 'Test Connection' gets error 'Could not establish connection'.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms