How to extract SuccessFactors data to Microsoft Excel

28 September 2015

Your form has been successfully submitted.

In this article, our HR Technology director, Tom Rottiers, explains how to extract data from SuccessFactors into Microsoft Excel (and Google Sheets) using the ODATA API.

SuccessFactors has different API’s to perform basic CRUDQ operations:

  • SFAPI
  • ODATA API

Depending on the module that needs to be accessed, either SFAPI of ODATA is the preferred option.

The last releases, and especially in the Employee Central module, the ODATA support has become more important and is the go-forward solution of SAP.

What is interesting is that originally the ODATA protocol was initiated by Microsoft (https://en.wikipedia.org/wiki/Open_Data_Protocol) and therefore very well supported by Microsoft products, like Excel for example.

Extraction of data from SuccessFactors directly in Microsoft Excel or Google Sheets is done easily.

Extraction into Microsoft Excel:

Since Excel natively supports ODATA, it is just a matter of a few clicks to extract the data from SuccessFactors, no programming or scripting required.

In the following movie you can find a quick tutorial on how to do it.

Extraction into Google Sheets:

We also did an experiment to call the ODATA API from Google spreadsheets.

The test that we did was inspired by a post on Youtube by DJ Adams (https://www.youtube.com/watch?v=B9FGqJFZbzQ)

With a little scripting in Google Sheets, we also managed to call the ODATA API and extract data. There is no demonstration video of this manipulation, please don't hesitate to contact us for more info.

These examples show how easy it is to access data stored in SuccessFactors using the ODATA API and using it for subsequent reporting or testing.

If you would like to learn more, feel free to contact us for a demo!

Related articles

News
blog-img

July 3 2019

Life as an intern at Emeritis

The past 4 months, we welcomed 2 newbies to our crew: Lars & Dries, both students at the AP Hogeschool in Antwerp. They chose Emeritis for their internship and we are really happy they did :-...

read more
News
blog-img

June 18 2019

Employer Branding and the Employee Life Cycle

Employer branding is more than the communication flow from you, as an employer, to your future employee(s). Building a strong employer brand doesn’t stop after the contract has been signed,...

read more
News
blog-img

June 14 2019

Emeritis & Deloitte join forces

Emeritis is acquired by Deloitte and becomes 'Emeritis a Deloitte Business'. Want to know more about the acquisition and why we joined forces? Please read the official press release below. *...

read more

'Emeritis' refers to 'Emeritis a Deloitte business'

© 2019 Wadsup. All Rights Reserved.