SAP Knowledge Base Article - Public

3207854 - OAuth 2.0 Support for Employee Delta Export Add-In for Microsoft Excel

Symptom

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

With the 1H 2022 Release, SAP SuccessFactors announced OAuth 2.0 support for the Employee Delta Export Add-In for Microsoft Excel. You wish to find out how to configure OAuth for the Employee Delta Export Add-In

Environment

SAP SuccessFactors Employee Delta Export Add-In for Microsoft Excel

Resolution

  1. Access tool: the following pop up will appear



  2. In your SAP SuccessFactors instance, navigate to Manage OAuth2 Client Applications 
  3. Register Client Application
  4. Enter Application Name, Description (optional), Application URL 
  5. Generate X.509 Certificate
  6. Enter Common Name (CN) and Validity (Days) (optional)
  7. Click on Generate
  8. After that click on Download button so you can download the certificate file
  9. Open the certificate file and take a note of the Private Key value
  10. Click on Register
  11. Take a note of the API Key that got generated


  12. Back in the Employee Delta Export, enter User ID (a user with access to Compound Employee API), API Key (which was generated before) and Private Key (the private key value from certificate file)
  13. The report will begin extracting data


Please ensure to adhere to the following Best Practices:

  1. Always bind the user
  2. Always use the latest Excel Add-in version available here
  3. Configure oAuth2 client and use this data in Excel to login as per the instructions available here
  4. Limit permissions as illustrated here and set a filter for an IP address for extra security (instructions available here)

See Also

Using the Employee Delta Export Add-In for Microsoft Excel (sap.com)

Keywords

ECT‑164674, Employee Delta Export Add-In, delta export, employee delta export, export, CE, Compound Employee, CompoundEmployee, X.509, Manage OAuth2 Client Applications, Register Client Application , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HCM Suite all versions