This article describes how AS400 connector works.
This connector is available in the following modes:
| Desktop mode ✅ | SaaS Online mode ❌ |
Connector scope
The AS400/DB2 connector allows you to connect to a DB2 database hosted on an IBM server of the AS400 family and to retrieve the definitions of the corresponding objects in a Relational type source. For DB2 servers installed on other operating systems, we invite you to use the DB2 plugin.
The extracted objects and their correspondences are detailed in the following table:
| AS400 Object | DataGalaxy Object | Commentaires |
| Schema | Model (container) | |
| Table | Table (structure) | |
| Column | Column | |
| Primary Key | Primary Key | This information will be used to link tables in DataGalaxy diagrams |
| Foreign Key | Foreign Key |
Step 1 : Installation
- Download DataGalaxy connector from the portal (see here)
- Extract the connector archive in the directory of your choice
- Download the AS400 plug-in from the portal and copy it into the /lib directory of the connector
Step 2 : Run AS400 connector
- After starting the connector, access to Dictionary connectors:
- If it has been correctly installed, the AS400 plug-in appears in the list
- The following information is requested:
| Paramter | Mandatory | Description |
| Server | Yes | |
| Port | Yes | |
| Instance | No | |
| User | Yes | |
| Password | Yes | |
| Advanced mode | No | Option to customize the JDBC URL used during the connection |
Technical information
The AS400 connector uses the JTOpen JDBC driver: https://www.ibm.com/support/pages/node/1118781
Releases
| Date | Plugin Version | DataGalaxy release | Desktop Connector version (minimum) | Description |
| 30/07/2024 | 3.0.1 | v3.63.0 | 5.0.4 | Migrated from java 11 to java 17 + CVE fixes |