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 Connection

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            SAP HANA Connection

            Create a remote connection using the SAP HANA 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, the new SAP HANA Cloud Connection and this legacy SAP HANA Connection. These connectors don’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 retire legacy connector versions beginning with the Winter ‘22 release.

            Connection Settings

            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 dataflows 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.
            URL

            SAP HANA database connection string. Must end in .xsodata. Enter in the format: https://<Database Name>.ondemand.com/<Service Definition Path>

            For example: 

            https://connectorshanatp.hanatrial.ondemand.com/Package/ProductODataService.xsodata
            Password Password to connect to the SAP HANA database.
            Username User name to connect to the SAP HANA database.

            SAP HANA Connector Considerations

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

            • This connector can sync up to 10 million rows or 5 GB per object, whichever limit it reaches first.
            • It’s an OData-based connector.
            • Connection to on-premises SAP HANA is not supported.
            • Maximum number of characters in a field is 32,000.
            • Maximum number of concurrent data sync runs is 3.
            • You can sync data from up to 100 objects in CRM Analytics. This total includes local and external objects.
            • 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.
            • Queries that take longer than 10 minutes to return initial data to CRM Analytics causes a “timeout exceeded” error message. The best practice in this situation is to simplify or segment your queries.

            See Also

             
            Loading
            Salesforce Help | Article