Skip to Main Content
Cloud Management and AIOps


This is an IBM Automation portal for Cloud Management and AIOps products. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.

Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Under review
Created by Guest
Created on Mar 8, 2024

IBM JDBC Gateway for Netcool should support PostgreSQL OR MongoDB?

PostgreSQL is Opensource and widely used DB. Similarly, MongoDB as well is getting wider recognition. Support of these DBs is already there in IMPACT but missing for IBM JDBC Gateway. 

So, IBM JDBC Gateway for Netcool should support PostgreSQL OR MongoDB so that these DBs can be used in Netcool based solutions uniformly. 

Amid ongoing OSS Transformations, we are willing to replace ORACLE with some other DB- preferably PostgreSQL OR MongoDB.

  However, as per IBM documentation, neither PostgreSQL nor MongoDB  is in the list of Supported DBs for JDBC Gateway.

  Below is the link we referred (and contents pasted as well for quick ref here).

   Hereby, we would like to double confirm on this before we make any strategic decision here on target DB. Pls comment.

   https://www.ibm.com/docs/en/netcoolomnibus/8?topic=jdbc-supported-databases

   Supported databases

Last Updated: 2023-01-25

The Gateway for JDBC is supported for use with the databases listed here.

The gateway is supported for use with the databases and JDBC drivers listed in the following table.

Note: The Gateway for JDBC will support a database once the vendor supplies a suitable JDBC driver that works with the gateway. Drivers not listed in this table are not supported by IBM Software Support, but if a third party JDBC driver does not function correctly due to a fault with the Gateway for JDBC, then IBM Software Support will provide support.

Database

JDBC Driver

DB2® LUW

DB2 Type 4 Universal Driver (com.ibm.db2.jcc.DB2Driver)

DB2 z/OS®

DB2 Type 4 Universal Driver (com.ibm.db2.jcc.DB2Driver)

Informix®

IBM Informix JDBC Driver (com.informix.jdbc.IfxDriver)

Microsoft SQL Server

Microsoft JDBC Driver for SQL Server (com.microsoft.sqlserver.jdbc.SQLServerDriver)

Note: On OMNIbus installations which are JRE 1.7 based the Microsoft JDBC Driver 4.2 up till 6.4 can be used.. For OMNIbus installations using JRE 1.8, Microsoft JDBC Driver 7.0 and above may be used providing that the driver used is the JRE 1.8 version. For more details on the Microsoft JDBC Driver, please refer to the Microsoft JDBC Driver for SQL Server website. Ensure that multiple versions of the .jar files are not installed in the $CLASSPATH or in the $OMNIHOME/gates/java location simultaneously.

MySQL

MySQL Connector/J (com.mysql.jdbc.Driver)

IBM Netezza data warehouse

Netezza JDBC Driver (org.netezza.Driver)

Oracle

Oracle JDBC Thin Driver (oracle.jdbc.driver.OracleDriver)

Note: When the database connection is enabled with Kerberos authentication, the gateway must be run using Oracle Java. See: Deploying the gateway with non-IBM Java.

Sybase

Sybase jConnect for JDBC (com.sybase.jdbc4.jdbc.SybDriver)

Table 1. Supported databases and JDBC drivers

 

Idea priority Urgent