Oracle BIP JDBC Connection To Netezza Database Not Working
(Doc ID 2064417.1)
Last updated on APRIL 23, 2021
Applies to:
BI Publisher (formerly XML Publisher) - Version 11.1.1.9.0 to 11.1.1.9.0 [Release 11.1]Information in this document applies to any platform.
Symptoms
in BI Publisher 11.1.1.9:
1a. The seeded application does not include the Netezza database in the JDBC Data Source driver type List of values (LOV).
1b. The 11.1.1.9 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'.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |