SAP SuccessFactors Employee Profile Photo Report Extract via Integration Center

[former_member18880]

Now a days multiple customer raise a request to SAP regarding a report on Employee Profile Photo  and as per the blog #2397776 its not feasible as of now.

We have a simple solution to achieve this via Integration Center without any custom coding. In this blog will we see the detailed steps to generate the report.

Symptom

• Not able to generate a report on Photo from employees on the instance.


• Is there a report for which employees have Photos on their profile?


• Employees who have Photo and who don't have Photo on employee profile.

Environment

• SAP SuccessFactors - Employee Profile


• SAP SuccessFactors Workforce Analytics


• Adhoc reporting


• Online report Designer


• Advanced reporting

Resolution

Please refer the below steps to generate the report.

Prerequisite before generating the report: 

• Understanding of Integration Center


• SFTP credential

Step 1 : SAP SuccessFactors Integration Center

As we know Integration Center is a marvellous tool for creating file base integration and generation OData Api.

Login to SAP Successfactors Bizx Suite and navigate to Admin Center. Click on "Company Setting" under Company Processes & Cycles and click on "Integration Center".

Note: If you are not able to find integration center then check permissions.

Step 2 : Report Creation

Under Integration Center select "My Integration".



Click on Create and select "Scheduled Simple File Output Integration" this will schedule the report on SFTP.



Under "Search for Entities by Entities Name" search for keyword "Photo" and select Photo as highlighted in below screenshot.



Step 3 : Select "userId" & "photoId" as shown in the below screenshot. This will generate the give the list of users from whom the profile photo is uploaded.

Step 4 : Provide the file name, if required select filter and navigate to Destination Settings.

Under Destination Settings provide the below details -

• SFTP Server Host Address: sftpxxx.successfactors.com
  (eg: sftp4.successfactors.com)


• SFTP User Name & SFTP Password

Ignore the remaining fields because its optional

Under File Name & Folder Settings

• File Name Prefix: Give some meaningful name to report file


• Date Suffix Format: None


• File Extension: csv


• 
  
  
  

  File Folder: Provide SFTP destination location (folder) where report should be available

  
  

  (eg: incoming/Report)

  
  
  
  

Step 5 : Click Next button and under Scheduling select the frequency of report as per business requirement.



Select the Start Time i.e to schedule job

Email To: To get notified



Click on Next.

Step 6 : Under Review and Run you can Set Scheduler or Run Now.

Job Progress can be seen under Last Run Time refer the below screenshot.

 

Soon we will also be writing the blog on PPTC in detailed #SAP SuccessFactors.