---
schema_version: "1"
id: f7bd896f62e12a4025022b7dca07aa33268f400cace45f2b5f3da50fd8de65fb
title: SAP HANA Cloud Connection
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_connectors_sap_hana_cloud.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_sap_hana_cloud.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2f0bfadf9732a8bf6e05c9c7571d7b4bae929e9cf6eff3a57f9aa61d52854dd2
description: Create a remote connection using the SAP HANA Cloud connector to sync data from cloud-based SAP HANA to CRM Analytics.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# SAP HANA Cloud Connection

Create a remote connection using the SAP HANA Cloud connector to sync data from cloud-based SAP HANA to CRM Analytics.

## Create the Connection

1. On the Data Manager Connections tab, click **New Connection**.
2. Click the name of the connector, and click **Next**.
3. Enter the connector settings.
4. To validate your settings and attempt to connect to the source, click **Save & Test**. If the connection fails, CRM Analytics shows possible reasons.

All settings require a value, unless otherwise indicated.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d167109e72">Setting</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d167109e75">Description</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e72 ">Connection Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e75 ">Identifies the connections. Use a convention that lets you easily distinguish
              between different connections.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e72 ">Developer Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e75 ">API name for the connection. This name can’t include spaces. The API name is
              used in your recipes to reference data extracted through this connection. You can’t
              change the developer name after you create the connection.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e72 ">Description</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e75 ">Description of the connection for internal use.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e72 ">Server</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e75 ">
              <p>The name of the SAP HANA database server.</p>
              <div>
                <p>For example:
                </p>
                <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>a230u4b3-8136-439b-174e-g39669ch71c5.hana.trial-us10.hanacloud.ondemand.com</code></pre>
              </div>
            </td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e72 ">Username</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e75 ">User name to connect to the SAP HANA database.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e72 ">Port</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e75 ">The specified server port for your SAPA Hana database. For example, <code>556</code>.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e72 ">Schema</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e75 ">Schema name for the database. The default value is <code>DBADMIN</code>.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e72 ">Database</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e75 ">
              <p>The SAP HANA database name.The name must be in the SAP HANA sid format.
              </p>
              <ul>
                <li>The SID must consist of exactly three alphanumeric characters</li>

                <li>Only uppercase letters are allowed</li>

                <li>The first character must be a letter</li>

              </ul>
              <p style="margin-bottom:0;"> For example, <code>L99</code>. For more information, see the <a href="https://help.sap.com/docs/SAP_HANA_PLATFORM/2c1988d620e04368aa4103bf26f17727/7672838aa9c44c7ab9d10188531669f3.html" target="_blank">SAP documentation</a>.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e72 ">Password</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d167109e75 ">Password to connect to the SAP HANA database. Salesforce Government Cloud
              customers with FIPS 140-2 encryption must have a password of at least 14
              characters.</td>

          </tr>
        </tbody>
      </table>

## Filter Data Synced to CRM Analytics

Exclude unnecessary or sensitive data from syncing to CRM Analytics with data sync filters. Filters run on the source object and speed up data sync by pulling only the data you need into CRM Analytics. If you plan to use excluded data in the future, use a recipe filter to limit the data written to a dataset instead of a data sync filter.

1. From Data Manager, click the **Connections** tab.
2. Select the connection associated with the object to filter.
3. Click the name of the object to filter.
4. Click **Data Sync Filter**.
5. Enter the filter.
6. Click **Save**.

For the SAP HANA Cloud connector, enter a SQL filter with quotes around object names. For more information, see [SAP HANA’s WHERE documentation](https://developers.sap.com/tutorials/hana-webide-dt-getting-started-6.html).

Keep these behaviors in mind when working with the SAP HANA connector.

- Connected object names must start with a letter and contain only letters, digits, or underscores. Object names can’t end with an underscore.
- Only field names with combinations of alphanumeric, dot, underscore, or dash characters are supported. If a connector includes field names that contain other characters, such as spaces or brackets, the sync fails.
- The connector can sync up to 10 million rows or 5 GB per object, whichever limit is reached first.
- This is a JDBC-based connector.
- Connection to on-premises SAP HANA isn’t supported.