Import Data Connection to Salesforce

You can create a connection that allows you to import data from salesforce.com (SFDC).

Prerequisites

A valid SFDC account is required to import data from SFDC to SAP Analytics Cloud. If you want to use OAuth for authentication and authorization, a proper setup on SFDC is required to enable the OAuth connection. For more information, see the OAuth 2.0 on ForceInformation published on non-SAP site documentation.

Procedure

  1. Go to Start of the navigation path (Main Menu) Next navigation step  Connection Next navigation step Connections Next navigation step  (Add Connection)End of the navigation path.
    The Select a datasource dialog will appear.
  2. Expand Acquire Data and select Salesforce Connector.
  3. In the Salesforce Connector dialog, do the following:
    1. Enter a name for the connection.
    2. Select the type of authentication you want to configure.

      There are two types of authentication for the Salesforce Connector: Basic Authentication and OAuth2 Authentication.

    3. Enter the information required for the type of authentication you chose to configure.
      • To configure a Basic Authentication, enter the Authorization URL, Username, and Password for your SFDC account. The authorization URL is used for accessing the web service to the third party application to access your user's data.

      • To configure an OAuth2 Authentication, enter the Authorization URL, Client ID, and Client Secret. Copy the Callback URI and paste it in your SFDC setup page.

      The Authorization URL defaults to https://login.salesforce.com/services/oauth2/authorize. The Client ID and Client Secret can be found in your SFDC setup page.

  4. Choose OK.

    If you chose to configure an OAuth2 Authentication, follow the steps on the screen to finish creating the connection.

    The new connection is added to the list of connections on the Connections screen.
  5. If you want to create a model based on this connection, see Creating a Model from Salesforce Data.