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

Last updated on OCTOBER 09, 2015

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

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