My Oracle Support Banner

Oracle BIP JDBC Connection To Netezza Database Not Working (Doc ID 2064417.1)

Last updated on DECEMBER 04, 2019

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.