Solved

Trying to connect to AS400

  • 3 December 2023
  • 4 replies
  • 50 views
V
Badge +1

Hi we are trying to connect to a AS400 source using JT400 jdbc driver for a customer and keep getting "Unable to initialize pool" is there any specific configuration we are missing in DPE? If anyone has done a similar connection in the past then please do share some inputs. Will be highly appreciated.

icon

Best answer by DannyRyan 12 December 2023, 16:57

View original

4 replies

DannyRyan
Rank
Userlevel 5
Badge +9

Hi @Vikram, Happy Monday. 😀

There is configuration for IBM DB2 (which is the relational database feature of the native OS/400 operating system which AS/400 operates within)

You’ll want to the JDBC drivers from IBM here:
https://www.ibm.com/support/pages/using-jdbc-connector-connect-db2-iseries-as400

and the Ataccama DPE Configuration for IBM DB2 here:
https://support.ataccama.com/home/docs/aip/latest/installation-guides/one-platform-configuration-reference/configuring-the-dpx-modules/dpe-configuration/data-sources-configuration#DataSourcesConfiguration-IBMDb2SourceConfiguration

Let us know how you get on.
Danny

Danny | Did it answer your question? Mark it as the correct answer!
V
Badge +1

Hi @DannyRyan, thanks for your response. we tried connecting first from IDE first and imported the JT400.jar and it seems to pick all config automatically and we could connect from IDE. is there a way to extract the config to be replicated in DPE?

DannyRyan
Rank
Userlevel 5
Badge +9

Hi @Vikram 
Apologies I gave you the wrong link for the DB2 JDBC Drivers from IBM.

Here is the correct link: 
https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads

You’ll need to know your DB Level from your DB2 administrators.

Once you know which DB2 Level is correct for your database download and install those drivers.


After you have installed the DB2 JDBC Drivers. Go back into ONE Desktop application.

  1. Right Click on the Databases node in File Explorer.
  1. Select IBM DB2 from the Database Type

  2. Fill in your connection details and credentials, and test connection.

 

 

If you can not see the IBM DB” Database Type in the dropdown.

Click the ‘Manage’ button next to the dropdown, and check if the IBM DB2 Driver is configured (green tick).
 

If it is not configured, click on edit on the right hand side.

Click on Add JAR Folder, and specify the folder on your machine were the db2jdbc driver is located.

Click OK, return to the Add Database dialog and add your connection details and credentials.

 

Danny | Did it answer your question? Mark it as the correct answer!
DannyRyan
Rank
Userlevel 5
Badge +9

Once you have the JDBC drivers confirmed working.
Following the guide here to configure your DPE with the same JDBC drivers.
https://support.ataccama.com/home/docs/aip/latest/installation-guides/one-platform-configuration-reference/configuring-the-dpx-modules/dpe-configuration/data-sources-configuration/adding-a-jdbc-driver-to-dpe

Danny | Did it answer your question? Mark it as the correct answer!

Reply


Community Terms of Use & ConditionsCookie settings