Skip to Content

HCI mapping question

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 30 at 03:19 AM

    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-connectors/

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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