The Tivoli Netcool Support's Guide to the JDBC Gateway describes how to use the JDBC Gateway to forward event data from Netcool/OMNIbus to a relational database.
This IBM support guide describes the JDBC Gateway for Tivoli Netcool, which reads data from the Object Server and inserts it into a target database using a specified JDBC driver provided by the database provider.
It covers database considerations for DB2, Oracle, and Sybase, configuration files such as G_JDBC.props and jdbc.map, REPORTING and AUDIT modes, performance monitoring, property settings, example installations on Linux Red Hat and Solaris, event data flow, static table updates, and common issues.
| DB2 JDBC Driver | com.ibm.db2.jcc.DB2Driver |
|---|---|
| DB2 JDBC URL | jdbc:db2// |
| Oracle JDBC Driver | oracle.jdbc.driver.OracleDriver |
| Sybase JDBC Driver | net.sourceforge.jtds.jdbc.Driver |
It reads data from the Object Server and inserts it into a target database using a specified JDBC driver.
The guide lists example JDBC drivers and URLs for DB2, Oracle, and Sybase databases.
The two schema types and modes are REPORTING and AUDIT.
Passwords are encrypted using AES encryption with the nco_keygen and nco_aes_crypt tools.