Integration Suite - iSeries (AS400) DB2 JDBC connection

[Benko]

Hi

Is it possible to install a JDBC driver to connect to the IBM iSeries DB2 database?

I have not been able to find any such driver which will deploy without the "Message: (deployJdbcDriver)Failed to deploy jdbc driver null for tenant" error message.

The links to the IBM website for drivers db2Driver11.5.4 / db2Driver11.5.5 in Note 3314847 are impossible to navigate.
In addition, there is a rodmap item for Q4 this year, for "JDBC support for IBM AS/400".
However, it isn't clear if this relates only to the Edge Integration Cell or not.
Any clarification much appreciated.
Regards
Steve


 

[chris_75]

Hi Sven,

We've also attempted to connect to a DB2 Datasource (on iSeries) using the mentioned JDBC Adapter. You can download the driver if you have an IBM ID. We have deployed JDBC Driver of IBM 11.5.9 on our Integration Suite Tenant, configured the CloudConnector, and were able to connect from the network perspective. So far, so good.

We followed every hint to connect to a specific DB on iSeries via the JDBC driver, but in the end, it failed with a licensing error. After checking the license (which was okay), we spent a long time talking with IBM and SAP. SAP mentioned the roadmap item for AS400 Driver Support (Version1) which is no longer there ;-)).

Here is SAP's response from the Service Deck and Productmanagement:

We plan to include a roadmap item for generic support of DB drivers for the JDBC adapter on the Edge Integration Cell. This means that with this delivery, the customer would be able to upload any DB driver to connect to any customer DB. However, please note, this option will only be available for Edge Integration Cell, not in the Cloud. Another point is that we will probably have to move this item to 2025.

To be honest, I don't believe SAP will come up with a working solution for Integration Suite due to incompatibility issues with IBM's JDBC Driver, their license, the Hyperscaler, and the underlying Apache Camel combination. There are similar topics and pitfalls for other adapters like OFT2, X.400, which SAP promised a long time ago but postpones every three months on the roadmap.

We gave up using/waiting for a working solution and integrate the scenarios wrapping the DB2 Data with Webservices. Not nice - but works for our requirement.

Best regards

Christian

[cwo61]

Have you tried a detour via MS SQL Server? The JDBC connection from Cloud Integration to MSSQL works great with Microsoft JDBC Driver for SQL Server. If you have a MSSQL instance you can connect your IBMi via Linked Server.