Skip to main content
  • Create a user and grant it minimum permissions required for Integrate.io ETL to read data from the database.
  • Allow access from Integrate.io ETL’s IP addresses to your database port (Refer to this article if you’d prefer to create an SSH tunnel or reverse SSH tunnel.)

​
To create an IBM i (AS400) database connection in Integrate.io ETL:

1
Click the Connections icon (lightning bolt) on the top left menu.
2
To create a connection, click New **connection.
New connection button in the Connections page
3
Choose IBM i (AS400) and name the connection.
Selecting IBM i (AS400) as the connection type
4
Select your access type (direct connection if you’ve whitelisted Integrate.io ETL’s IP addresses.)
5
Enter your database host name.
6
Enter the database name.
7
Enter the user name
8
Enter the user’s password.
9
Click Test Connection to make sure the connection details are correct.
10
Click Create connection to create the connection.
IBM i (AS400) connection configuration form with host, database, and credentials
Successful IBM i (AS400) connection test confirmation
With Integrate.io ETL’s 120+ integration sources and powerful transformation layer, your team will be able to make IBM i (AS400) your single source of truth.
Last modified on April 20, 2026