Loading
Salesforce now sends email only from verified domains. Read More
CRM Analytics
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            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.

            Note
            Note There’s a new codebase version of this connector available with the Summer ‘21 release. To learn how the new connector version impacts your existing connections, the connection upgrade path to the new version, and considerations when creating connections, see this release note. There are two connector options, this SAP HANA Cloud Connection and the legacy SAP HANA Connection. These connectors won’t use the legacy connector toggle. To migrate, create a connection with the connector mirroring the settings of your legacy connection and any new required properties. Then, update your recipes and dataflows to use the external objects from the new connection. Keep the legacy version of the connection for troubleshooting. We recommend that you complete the migration and test soon, as we’ll retire legacy connector versions beginning with the Winter ‘22 release.

            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