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

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

SAP SuccessFactors Employee Delta Export Add-In for Microsoft Excel

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)

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

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