> ## 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 SAP HANA

> Connect SAP HANA 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.
* Add rules in your [database firewall](https://docs.microsoft.com/en-us/azure/azure-sql/database/firewall-configure?view=azuresql) to allow access for Integrate.io ETL's IP addresses. Add a rule for each IP relevant to your account's region using [this list](/etl/integrateio-etls-ip-list/) (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 a SAP HANA 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/2ttHYDu3EKov-VoY/images/connectivity-and-security/image-76.webp?fit=max&auto=format&n=2ttHYDu3EKov-VoY&q=85&s=f2a7578854f37928a7eed0a5694f20a1" alt="New connection button in the Connections page" width="1200" height="829" data-path="images/connectivity-and-security/image-76.webp" />
    </Frame>
  </Step>

  <Step>
    Choose SAP HANA and name the connection.

    <Frame>
      <img src="https://mintcdn.com/integrateio/2ttHYDu3EKov-VoY/images/connectivity-and-security/image-77.webp?fit=max&auto=format&n=2ttHYDu3EKov-VoY&q=85&s=41341a11912f3e85923f3221d7ecdd55" alt="Selecting SAP HANA as the connection type" width="1200" height="829" data-path="images/connectivity-and-security/image-77.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/2ttHYDu3EKov-VoY/images/connectivity-and-security/image-78.webp?fit=max&auto=format&n=2ttHYDu3EKov-VoY&q=85&s=29ba1c3bf778a5670d6b57a99b5ef0d2" alt="SAP HANA connection configuration form with host, database, and credentials" width="1200" height="829" data-path="images/connectivity-and-security/image-78.webp" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/integrateio/2ttHYDu3EKov-VoY/images/connectivity-and-security/image-79.webp?fit=max&auto=format&n=2ttHYDu3EKov-VoY&q=85&s=6bb2788f75f15a763c8d80663cc676d5" alt="Successful SAP HANA connection test confirmation" width="1200" height="829" data-path="images/connectivity-and-security/image-79.webp" />
    </Frame>
  </Step>
</Steps>