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

# SAP HANA

You can use the SAP HANA connector from the CData Sync application to move data
from any supported source to the SAP HANA destination. To do so, you need to add
the connector, authenticate to the connector, and complete your connection.

## Add the SAP HANA Connector

To enable Sync to use data from SAP HANA, you first must add the
connector, as follows:

<ol>
  <li>Open the **Connections** page of the Sync dashboard.</li>
  <li>Click **Add Connection** to open the **Select Connectors** page.</li>
  <li>Click the **Destinations** tab and locate
  the **SAP HANA** row.</li>

  <li>
    Click the **Configure Connection** icon at the end of that row to open
    the **New Connection** page. This action opens the
    **Add Connection** dialog.

    **Note:** If the **Configure Connection** icon is not
    available, click the **Download Connector** icon to install
    the SAP HANA connector.
  </li>

  <li>Enter a name for your connection in the **Add Connection** dialog.</li>
  <li>Click **Add** to open the **Settings** tab for your connector.</li>
</ol>

For more information about installing new connectors, see
[Connections](https://docs.sync.cdata.com/26.4/en/connections/connections.md).

## Authenticate to SAP HANA

After you add the connector, you need to set the required properties.

* **Server:** Enter the name of the server that runs SAP HANA.
* **Port:** Enter the port number for SAP HANA. The default port value is **39013**.

CData Sync supports authenticating to SAP HANA in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

* [**Password**](#password) (default)
* [**OKTA**](#okta)
* [**Kerberos**](#kerberos)

### Password

To connect with your user credentials, set the following properties:

<ul><li>**Auth Scheme:** Select **Password**.</li>
<li>**User:** Enter the username that you use to authenticate to your SAP HANA account.</li>
<li>**Password:** Enter the password that you use to authenticate to your SAP HANA account.</li></ul>

### Okta

To connect with single sign-on (SSO) via Okta, specify the following properties:

<ul><li>**Auth Scheme:** Select **OKTA**.</li>
<li>**User:** Enter the username that you use to authenticate to your Okta account.</li>
<li>**Password:** Enter the password that you use to authenticate to your Okta account.</li>
<li>**SSO Login URL:** Enter the login URL that is used by your SSO provider.</li>
<li>**SSO Properties:** Enter a semicolon-separated list of the single sign-on (SSO) properties that you want to use (for example, *SSOProperty1*=*Value1*;*SSOProperty2*=*Value2*;...).</li></ul>

### Kerberos

To connect with Kerberos, specify these settings:

<ul><li>**Auth Scheme:** Select **Kerberos**.</li>
<li>**User:** Enter the username that you use to authenticate to your SAP HANA account.</li>
<li>**Password:** Enter the password that you use to authenticate to your SAP HANA account.</li>
<li>**Kerberos KDC:** Enter the host name or IP address of your Kerberos Key Distribution Center (KDC) machine.</li>
<li>**Kerberos Realm:** Enter the Kerberos realm that you use to authenticate to Kerberos.</li>
<li>**Kerberos SPN:** Enter the service principal name (SPN) for the Kerberos domain controller.</li>
<li>**Kerberos User:** Enter the principal name for the Kerberos Domain Controller. The name should be in the form ***Host*/*User*@*Realm***.</li>
<li>(Optional) **Kerberos Keytab File:** Enter the full file path to your Kerberos keytab file.</li>
<li>(Optional) **Kerberos Ticket Cache:** Enter the full file path to an MIT Kerberos credential cache file.</li></ul>

## Complete Your Connection

To complete your connection:

1. Specify the following properties:
   * **Database:** Enter the name of your SAP HANA database.
   * **Schema:** Enter the schema for your SAP HANA database.
   * **Include System Objects:** Select whether you want to fetch Hana System schema and tables. By default, the **Enable** checkbox is not selected.
   * **Use SSL:** Select whether you want to enable Secure Sockets Layer (SSL). By default, the **Enable** checkbox is not selected.
2. Define advanced connection settings on the **Advanced** tab. (In most cases, though, you should not need these settings.)
3. Click **Create & Test** to create your connection.

## More Information

For more information about interactions between CData Sync and SAP HANA, see
[SAP HANA Connector for CData Sync](https://cdn.cdata.com/help/SNN/synch/default.htm).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.