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.
Solved
Trying to connect to AS400
+3- Data Voyager
Best answer by DannyRyan
Hi
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.
- Right Click on the Databases node in File Explorer.
- Select IBM DB2 from the Database Type
-
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.
+2- Head of Technical Training
Hi
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
+3- Data Voyager
Hi
+2- Head of Technical Training
Hi
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.
- Right Click on the Databases node in File Explorer.
- Select IBM DB2 from the Database Type
-
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.
+2- Head of Technical Training
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
Reply
Most Liked this week
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.