November 11, 2020

How to export data from Employee Central?

SAP Employee Central is superior HR software, which improves productivity by providing leaders with the data needed to make more effective business decisions. When working with this SuccessFactors tool, you will need to know how to export this data.

There are four main methods of exporting data from employee central:

UDF (User Data File)
Employee Delta Export
Generic Object Data
Exporting Data with Reporting

exporting data

User Data File

The user data file can be exported from the Admin Center by selecting User Information, and then Employee Export in the navigation menu. Under the Specify Export Options section, the Valid users only option enables only active users in the export file. Once the Export User File button is selected, the file will download.

There is also the option to export this data as a batch, which is under the Specify File Language, and Batch/Scheduled Processing options section. If you are exporting data as a batch, you can download the file from the Monitor Jobs screen.

Employee Delta Export

This method is for exporting employee master data from Employee Central to various payroll systems. The data from an Employee Delta Export can download from the following option:

Admin Center > Reporting > Employee Delta Export

The Employee Delta Export leverages the Employee Central HRIS SOAP API in order to export the data from Employee Central into the workbooks.

Employee Delta Export

Image Source: https://blogs.sap.com/2018/08/16/employee-central-employee-delta-export-microsoft-excel-add-in/

Generic Object Data

This method can export the following data from SuccessFactors Employee Central:

Object Definitions
Object Data
MDF Picklists
Business Rules
Configuration UIs

This data is exported in a CSV file (dependant object CSV files are combined in a ZIP file).

To create a Generic Object Export, you will need to enter the Admin Center (in Employee Files) and select Import and Export Data in the navigation menu. To export the data from the system, select the Export Data dropdown, and choose the following options:

Select Generic Object
Include Dependencies
Include Immutable IDs
Exclude Reference Objects
Select All Data Records

Once you have selected your preferred options, select the Export button. Once processed, the export file will be available for download on the Monitor Jobs screen.

generic object data employee central dashboard

Images Source: https://blogs.sap.com/2013/06/25/overview-of-the-successfactors-metadata-framework/

Exporting Data with Reporting

The Ad Hoc Reporting or Detailed Reporting option can export data in an Excel file. Ad Hoc Reporting is in the reporting section within the Admin Center. This can be found in the reporting section within the Admin Center.

Want to know more about SuccessFactors?

SAP Employee Central is only a small part of the full SuccessFactors Suite. If you are looking to drive the growth and productivity of your business, contact us on +44 (0)20 3371 9523 or book a demo.