Import Data Connection to SAP SuccessFactors

You can create a connection that allows you to import models from SAP SuccessFactors.

Prerequisites

A valid SAP SuccessFactors account is required to import data into SAP Analytics Cloud. A proper setup on SAP SuccessFactors is also required to enable the connection. For more information, see the HXM Suite OData API documentation in the SAP SuccessFactors platform Product page.

When registering the OAuth Client Application on the SAP SuccessFactors site, after Certificate Generation you need to download the certificate before selecting register. If you miss this step, you need to regenerate the X.509 Certificate and download the .pem file.

When editing a SAP SuccessFactors connection, you have to re-enter the certificate and other secure credentials.

Context

Note
While OData exposes one-to-many navigation, SAP Analytics Cloud cannot follow these relationships because doing so would distort the measures at the parent level. OData v4.0 supports Lambda operators any and all, which can reduce the collection of children to a single Boolean value. For this to work, the server must support OData v4.0. Freehand queries can be used to apply the Lambda expression to the corresponding columns.

Procedure

  1. From the side navigation, choose Start of the navigation path Connections Next navigation step  (Add Connection)End of the navigation path.
    The Select a data source dialog will appear.
  2. Expand Acquire Data and select SAP SuccessFactors.
  3. On the New SAP SuccessFactors Connection dialog, do the following:
    1. Enter a name for the connection.
    2. Enter the Service URL published during your SAP SuccessFactors configuration.

      The service URL is based on the data center you are connecting to and can be found in the SAP SuccessFactors documentation: About HCM Suite OData APIs.

      Note
      Remove the text /odata/v2 from the URL. For example, if your data center is Chandler1/HCM (DC4) you would use the following text in the service URL field: https://api4.successfactors.com
    3. Enter the SAP SuccessFactors User ID of the user you want to acquire data from.

      The User ID must belong to an administrative user in SAP SuccessFactors and have Admin access to OData API and Manage OAuth2 Client Applications permissions.

    4. Enter the API Key used to connect to SAP SuccessFactors.

      The API Key is the OAuth API Key. To locate the API Key, log on to SAP SuccessFactors, and go to Manage OAuth2 Client Applications.

    5. Under Private Key, select and upload the certificate file that you generated during the SAP SuccessFactors registration process.
      Note
      The certificate file should be a .pem file.
    6. Enter your Company ID used by SAP SuccessFactors.
  4. Choose Create.
    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 Import Data to Your Model.