Bert Swope
This jdbc information is based on Netezza (7.2.0) JDBC for InfoSphere Information Server11.5. so, here are a few pointers for building an IBM InfoSphere Information Server (IIS) isjdbc.config file.
Where to place JAR files
For Infosphere Information Server installs, as a standard practice, create a custom jdbc file in the install path. And install any download Jar file not already installed by other applications in the jdbc folder. Usually, jdbc folder path looks something like this:
- /opt/IBM/InformationServer/jdbc
CLASSPATH
- nzjdbc3.jar
- Classpath must have complete path and jar name
CLASS_NAMES
- netezza.Driver
JAR Source URL
File name
- nz-linuxclient-v7.2.0.0.tar.gz
Unpack tar.gz
- tar -zxvf nz-linuxclient-v7.2.0.0.tar.gz -C /opt/IBM/InformationServer/jdbc
DB2 DEFAULT PORT
- 1521
JDBC URL FORMAT
- jdbc:netezza://:/
JDBC URL EXAMPLE
- jdbc:netezza://10.999.0.99:5480/dashboard
isjdbc.config EXAMPLE
CLASSPATH=usr/jdbc/nzjdbc3.jar;/usr/jdbc/nzjdbc.jar;/usr/local/nz/lib/nzjdbc3.jar;
CLASS_NAMES= org.netezza.Driver;
Isjdbc.config FILE PLACEMENT
- /opt/IBM/InformationServer/Server/DSEngine
Related References
- JDBC drivers for predefined data connectors
- DB2 JDBC ISJDBC.CONFIG Configuration
- SQL Server JDBC ISJDBC.CONFIG Configuration
- Oracle JDBC ISJDBC.CONFIG Configuration
- Netezza JDBC Error – Unterminated quoted string
- JDBC driver installation for UNIX/Linux on a supported platform
- Netezza software
- IIS-CONN-JDBC-00004E The connector failed to locate a suitable driver for the specified URL value
- JDBC connector messages
- Sample JDBC driver connection URL formats
You are the best. I have been searching the JDBC drivers/client for 2 hours and IBM website is so deep and big that there was no easy way to find it. Did too much of digging on the web finally found this page that gives me direct URL of what I wanted. THANK YOU!