HCI mapping question

[former_member554379]

Hello everyone,

I would like to know how can I do to extract data from SucessFactors and convert it into a csv File, currently I have the connection to EC configured but I don't how to create the target element or output file (csv file) with custom fields.

Thanks in advance

[Sriprasadsbhat]

Hello Roland,

You can do it in 2 ways

1) SuccessFactors Integration Center- If its just a data extract with very simple transformations you can achieve it without using SAP CPI.Below blog will help you.

https://blogs.sap.com/2017/07/02/integration-center-a-viable-and-flexible-alternative-for-lms-connec...

2) SAP CPI: If you want to perform more transformation you can follow below

a) Creating target structure: Create sample XML of your desired output and create XSD using freely avaiable online tools like freeformatter.com.This will act as target schema for message mapping.

b) Model your query using SuccessFactors adapter which will create source Schema for message mapping.

c) Use XML to CSV converter to perform XML to CSV transformation.

Regards,

Sriprasad Shivaram Bhat

[former_member554379]

Thanks For Reply, Maybe, Do you know How Can I add A Static Value in a CSV file?:

I'm converting a XML to CSV then I need to add a value at the top of this file once generated:

#TABLE--------------------------->>>>>>(this is what I need.)

address1,address2,adjSeniorityDate,autopay,birthdate ----------------(this is the CSV structure)

xxx,xxxx,xxxx,xxxx,xxxx

xxxx.xxxx.xxxx.xxx.xxxx

xxxx.xxxx.xxxx.xxxx.xxxx