Loading
The online Trailblazer Community becomes read-only Oct 30, 2026Read More
Important Advisory: iOS Update Impacting CG Mobile ApplicationRead More
CRM Analytics
SAP HANA Cloud Connection

You are here:

  1. Salesforce Help
  2. Docs
  3. CRM Analytics

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.

Setting Description
Connection Name Identifies the connections. Use a convention that lets you easily distinguish between different connections.
Developer Name 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.
Description Description of the connection for internal use.
Server

The name of the SAP HANA database server.

For example: 

a230u4b3-8136-439b-174e-g39669ch71c5.hana.trial-us10.hanacloud.ondemand.com
Username User name to connect to the SAP HANA database.
Port The specified server port for your SAPA Hana database. For example, 556.
Schema Schema name for the database. The default value is DBADMIN.
Database

The SAP HANA database name.The name must be in the SAP HANA sid format.

  • The SID must consist of exactly three alphanumeric characters
  • Only uppercase letters are allowed
  • The first character must be a letter

For example, L99. For more information, see the SAP documentation.
Password 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.

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.

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.
 
Loading
Salesforce Help | Article