>

Allowing Integrate.io ETL access to IBM i (AS400)

Integrate.io ETL can read data from your IBM i series (AS400). This article discusses providing Integrate.io ETL access on your IBM i (AS400) and then details creating the database connection in Integrate.io ETL. 

You must provide Integrate.io ETL access to your IBM i (AS400) database. If it is behind a firewall:

  • 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.thumbnail image
  3. Choose IBM i (AS400) and name the connection.
  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.

thumbnail image

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.