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 following topics in the HCM Suite OData API documentation in the SAP SuccessFactors 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, however, both the server and SAP Analytics Cloud must support OData v4.0. Currently, SAP Analytics Cloud only supports OData v2.0. As a result, one-to-many navigation properties will be hidden to the end user until OData v4.0 is supported on both sides. As a possible alternative, please select the child entity as the main entity for the data query and use the parent entity as the navigation property.

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 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 Importing SuccessFactors Data to a New or Existing Model.