> ## 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 Oracle

> Connect Oracle databases to Integrate.io ETL for reading and writing data. Configure user permissions, firewall rules, and connection settings.

* Create a user and grant it minimum permissions required for Integrate.io ETL to read or write 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 Oracle 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/K1OxIkBgHF64pvnH/images/connectivity-and-security/image-67.webp?fit=max&auto=format&n=K1OxIkBgHF64pvnH&q=85&s=e9c669c982267dab1b5ebfcde640625c" alt="New connection button in the Connections page" width="1200" height="830" data-path="images/connectivity-and-security/image-67.webp" />
    </Frame>
  </Step>

  <Step>
    Select Oracle Database and name the connection.

    <Frame>
      <img src="https://mintcdn.com/integrateio/K1OxIkBgHF64pvnH/images/connectivity-and-security/image-68.webp?fit=max&auto=format&n=K1OxIkBgHF64pvnH&q=85&s=c5344b2fe97d19dc5e96a58788a241bb" alt="Selecting Oracle Database as the connection type" width="1200" height="830" data-path="images/connectivity-and-security/image-68.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>
    Select Database Identifier and enter SID / Service Name by Database Identifier.

    <Frame>
      <img src="https://mintcdn.com/integrateio/K1OxIkBgHF64pvnH/images/connectivity-and-security/image-69.webp?fit=max&auto=format&n=K1OxIkBgHF64pvnH&q=85&s=f7c5bfc077e93692cca1e3abecb4e376" alt="Database identifier selection showing SID option" width="1200" height="830" data-path="images/connectivity-and-security/image-69.webp" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/integrateio/K1OxIkBgHF64pvnH/images/connectivity-and-security/image-70.webp?fit=max&auto=format&n=K1OxIkBgHF64pvnH&q=85&s=fe25341de88269edce6575bffa38f74b" alt="Database identifier selection showing Service Name option" width="1200" height="830" data-path="images/connectivity-and-security/image-70.webp" />
    </Frame>
  </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/K1OxIkBgHF64pvnH/images/connectivity-and-security/image-71.webp?fit=max&auto=format&n=K1OxIkBgHF64pvnH&q=85&s=545614a2530f425a9d616f00d7a07ff5" alt="Completed Oracle connection configuration form" width="1200" height="830" data-path="images/connectivity-and-security/image-71.webp" />
    </Frame>
  </Step>
</Steps>