You can create a data pipeline that loads data from a source endpoint to an on-premises SAP HANA database. To provide the information SnapLogic® AutoSync needs to connect to SAP HANA, supply new credentials in the wizard, or select saved credentials that were created in the IIP or the wizard. Refer to Create credentials for a description of how to create new credentials in the AutoSync wizard.

Supported Account types

The IIP provides multiple Account types for most endpoints and not all types are compatible with AutoSync. When you create or edit a data pipeline, the existing credentials list only includes compatible Accounts. AutoSync supports the following IIP Account types:

  • SAP HANA Account

Known limitations

  • SAP HANA supports a maximum of 5000 characters in columns with a varchar datatype.

Connection configuration

When you select SAP HANA as a destination, you'll be asked to select a Groundplex that has connectivity to your on-premises SAP HANA database. The Connect to on-premises endpoints page provides details about limitations and constraints.

To configure a data pipeline to use SAP HANA:

  • Select saved credentials or create new ones with the following properties:
    • Credential label: A unique, meaningful name such as SAP-Accounting-Admin. If a configuration with the same name exists, AutoSync displays an Asset conflict error message.
    • Hostname: The hostname part of the connection URL.
    • Port number: The port number for SAP HANA. Default value: 30015
    • Database name: The name of the destination database.
    • Username: A username for an account with the correct permissions for AutoSync to load and synchronize data. For example,Autosync_SAP_User.
    • Password: The password for the account. Multiple retries with an invalid password can cause your account to be locked.
    • Share: (Optional) Select a user group to share this configuration with. Environment admins (formerly Org admins) create user groups to share credentials. If you are a member of a user group, you can select it from the dropdown. You can also select the global shared folder, which shares the credentials with everyone in your Org.
    • Validate and Save: After saving and validating, AutoSync adds the configuration to the list of saved credentials.
  • Select schema: From the drop-down list, choose the schema to load data into. AutoSync populates the list from your SAP HANA account.