> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: Connecting to IBM i (AS/400)

> Connect IBM i (AS/400) databases to Integrate.io ETL for reading data. Configure JDBC access, firewall rules, and connection settings.

* 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](/etl/integrateio-etls-ip-list/) to your database port (Refer to [this](/etl/allowing-integrateio-etl-access-to-my-server-behind-a-firewall/) 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:**

<Steps>
  <Step>
    Click the **Connections** icon (lightning bolt) on the top left menu.
  </Step>

  <Step>
    To create a connection, click **New connection**.

    <Frame>
      <img src="https://mintcdn.com/integrateio/fpWCvrjvoCDC-WOb/images/new-releases/image-5.webp?fit=max&auto=format&n=fpWCvrjvoCDC-WOb&q=85&s=3605c1de786f2d2d9a027c028064a8ae" alt="New connection button in the Connections page" width="1200" height="829" data-path="images/new-releases/image-5.webp" />
    </Frame>
  </Step>

  <Step>
    Select IBM i (AS400) and name the connection.

    <Frame>
      <img src="https://mintcdn.com/integrateio/fpWCvrjvoCDC-WOb/images/new-releases/image-6.webp?fit=max&auto=format&n=fpWCvrjvoCDC-WOb&q=85&s=0e82d4d954948e8d12a060b51d01157f" alt="Selecting IBM i (AS400) as the connection type" width="1200" height="828" data-path="images/new-releases/image-6.webp" />
    </Frame>
  </Step>

  <Step>
    Select your access type (direct connection if you've whitelisted Integrate.io ETL's IP addresses.)
  </Step>

  <Step>
    Enter your database host name.
  </Step>

  <Step>
    Enter the database name.
  </Step>

  <Step>
    Enter the user name
  </Step>

  <Step>
    Enter the user's password.
  </Step>

  <Step>
    Click **Test Connection** to make sure the connection details are correct.
  </Step>

  <Step>
    Click **Create connection** to create the connection.

    <Frame>
      <img src="https://mintcdn.com/integrateio/fpWCvrjvoCDC-WOb/images/new-releases/image-7.webp?fit=max&auto=format&n=fpWCvrjvoCDC-WOb&q=85&s=8b9f9b5840fdfdd83e117cf79704e7ee" alt="IBM i (AS400) connection configuration form with host, database, and credentials" width="1200" height="828" data-path="images/new-releases/image-7.webp" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/integrateio/fpWCvrjvoCDC-WOb/images/new-releases/image-8.webp?fit=max&auto=format&n=fpWCvrjvoCDC-WOb&q=85&s=1541868b9f621aaa9c493ce4e18b9434" alt="Successful IBM i (AS400) connection test confirmation" width="1200" height="828" data-path="images/new-releases/image-8.webp" />
    </Frame>
  </Step>
</Steps>

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.