A Guide for Using SAP SuccessFactors Employee Central Employee Delta Export

  • by Luke Marson, Co-Founder, CEO Americas, and Principal Architect for Employee Central, iXerv
  • May 16, 2016

Learn about the SAP SuccessFactors Employee Central Employee Delta Export add-in and how you can use this feature to create simple flat-file integrations for your local payroll providers. Understand what this add-in feature does and what use cases it supports, as well as how to set up and configure the solution.
Learning Objectives

Reading this article you will learn:

  • What the SAP SuccessFactors Employee Central Employee Delta Export add-in does
  • When to use the Employee Delta Export add-in versus using web-services or middleware integration
  • How to use the Employee Delta Export feature
  • Points to consider when using the Employee Delta Export add-in
  • The key implementation steps
Key Concept

The SAP SuccessFactors Employee Central Employee Delta Export add-in for Microsoft Excel enables employee master data and employee compensation data to be extracted from SAP SuccessFactors Employee Central into Microsoft Excel so that it can be sent to a local payroll system for payroll processing. The Employee Delta Export feature uses a Microsoft Excel add-in to extract all data changes made since the last run of the Employee Delta Export. The Employee Delta Export also takes into account current, future, and retroactive effective-dated changes.

The Employee Delta Export add-in for Microsoft Excel in SAP SuccessFactors Employee Central enables employee master data to be extracted from Employee Central into a Microsoft Excel workbook. This workbook can then be provided to a payroll provider or uploaded directly into a payroll system for processing payroll. The Employee Delta Export add-in is primarily designed to provide data for local and small payrolls where there is no business case for return on investment (ROI) for building an integration on a middleware tool, or when the payroll system has no inbound integration capabilities or only has flat-file upload capabilities.

Note
The Microsoft Excel add-in has a number of prerequisites that are required for it to be used:
  • Microsoft Windows 7 or 8 (both 32- and 64-bit versions are compatible)
  • Microsoft Excel 2010 or 2013 (both 32- and 64-bit versions are compatible)
  • Microsoft XML Core Services 6 (MSXML 6.0) or later
  • Permission to execute macros in Microsoft Excel

Additionally, the Employee Profile data audit must be enabled in Provisioning and a user must be created in SAP SuccessFactors that has the required SuccessFactors application program interface (API) permissions.

The Employee Delta Export feature uses a Microsoft Excel add-in to extract data from Employee Central using the Compound Employee API (CE API) in SAP SuccessFactors. All data is extracted into a Microsoft Excel workbook.

Luke Marson

Luke Marson is co-founder, CEO Americas, and Principal Architect for Employee Central at iXerv, a global SAP SuccessFactors consulting partner. In addition to his duties as CEO, he is an active architect and subject-matter expert on SAP SuccessFactors. Luke is a Certified Professional in SuccessFactors Employee Central who has worked with over 15 customers, and is the co-author of the following books: SuccessFactors with SAP ERP HCM and SAP SuccessFactors Employee Central. He is also an author, blogger, speaker, strategist, and widely recognized expert in SAP SuccessFactors and SAP ERP HCM. Luke can be found on Twitter at @lukemarson.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.