Extract Employee Data from SAP SuccessFactors Employee Central

The SAP SuccessFactors Adapter supports the Compound Employee application programming interface (API). The SAP SuccessFactors Compound Employee API service is a SOAP web service used to extract employee data from SAP SuccessFactors Employee Central.

This use case describes how to extract employee data from SAP SuccessFactors Employee Central. In this use case, an FTP Adapter is used to write the data that you receive from SAP SuccessFactors to a file, but you can also use other applications.

1. Create a scheduled orchestration integration.
2. Drag an SAP SuccessFactors Adapter into the integration canvas as an invoke connection.
3. Configure the SAP SuccessFactors Adapter as follows:
   1. On the Basic Info page, provide a name.
   2. On the Operations page, select SOAP, and then select SFQL in the Select an Operation Type list.
   3. Enter a valid SFQL query in the text box. The query can include custom fields and parameters. For example:

      SELECT person, personal_information, address_information, 
      phone_information FROM CompoundEmployee

   4. Enter the batch size value.
   5. Click Test My Query. The query response is displayed for a successful query. If the query is invalid, you receive a response for the errors in the query.
   6. Review your selections on the Summary page.
4. In the mapper, set querySessionId as null or a blank value.
   
   
   
   
5. Drag an FTP Adapter into the integration canvas and configure the FTP endpoint to write the data that you receive from SAP SuccessFactors to a file.
6. In the mapper, map the response to the FTP write request.
   
   
   Description of the illustration mapper2.png
   
   
   The complete integration looks as follows:
   

   

   
   
7. Specify the tracking variable.
   1. Click Tracking.
   2. Drag the required variable to use for the tracking reference (for this example, startTime is selected).
8. Activate the integration.
9. After successful activation, you can submit the integration and monitor the runtime in Oracle Integration.