Skip to Content

With SAP having delivered the standard integration add-on and following it up with subsequent SP’s, we had set a team out to explore these solutions and here is an account of our experience.

Scope:

1.      

         Integration Scenario for Employee Data

·         Using File Download (FTP/SFTP)

·         Using Middleware

2.     

          Integration Scenario for Compensation Data

·         Using Middleware

The team that was set out to accomplish this task had the following members in it:

·         Network Engineer (Network setup, Opening ports, Firewall rules…)

·         SAP HCM Functional Consultant (Backend configuration, Field mapping, Integration testing…)

·         SFSF consultant (SFSF setup – align data models, Comp Planning exercise…)

·         Basis Consultant (Add-on installation & SP upgrades, Role / User administration)

·         SAP NW PI consultant ( Set up the PI system to broker communications between SAP & SFSF)

·         Technical (ABAP) consultant ( BADI implementation for custom field mappings)

These are skills that one would need to get the integration add-on up and running.

Let me also run through the experience we had through different phases of this project.

·         Network Setup: This is a very important and critical activity where the corporate intranet is exposed to an application that runs on the cloud. It assumes paramount importance since highly critical and confidential business data will be sent out of your corporate network and also received back (through secured communication channels off course). We had no trouble here since our network expert had enough experience in setting up multiple such similar models and hence got things set up for us in quick time.

·         Add-on installation / Role & User administration: The admin & other guides published by SAP are detailed enough to have all the requisite components installed and upgraded. Details on standard roles are also made available by SAP. SAP ERP 6.0 SPS15 – SP 38 for EA-HR 600 is the lowest version on which the integration add-on can be installed.

·         Middleware Setup: SAP NW PI & ESR content are mandatory for the integration scenario on compensation data. SAP NW PI has to be at 7.0 or higher. This was a time consuming and challenging phase. . In addition to all the instructions on the admin guide, we had to get a Hot-Fix (delivered by SAP) installed to get it all working. 

·         Configurations on SAP HCM & SFSF: Again there is enough help documentation available on this topic. It is fairly simple and easy to follow. We connected to a demo instance of SFSF and hence all configurations were in place. Our SFSF expert did all the comp planning in the SuccessFactors compensation module which was then imported and activated in SAP.

·         Integration Testing:

1.       1. Integration Scenario for Employee Data using file download (OR) middleware (SAP NW PI in our case)

Quick Facts

  • RH_SFI_TRIGGER_EMPL_DATA_REPL was the initial extraction report which was then enhanced with delta data handling, inactive logic and option to select the data transfer mechanism. SAP recommends using the latest enhanced version for all data extraction purposes – RH_SFI_SYNCHRONIZE_EMPL_DATA
  • RH_SFI_SYNCHRONIZE_EMPL_DATA report provides for extracting data for 34 standard SFSF fields + 15 custom fields
  • Each of these data fields are to be mapped to relevant fields in SAP
  • Besides the standard SAP field options available in the dropdown for each SFSF data field, customers can also have their own field mappings via BADI’s.
  • 9 SFSF fields have been defined as mandatory in the extraction report. Users have the option to either exclude or mark the other fields as required.

·         Pic 1.jpg

  • Provisions are available for users to select the data transfer mechanism – File download or Middleware
  • A report variant is mandatory to execute the report.

Pic 2.jpg

Process Walkthrough

Process a.jpg

For readers who are interested in Performance or load test, this was not a part of our agenda here as we were working with demo systems which had limited capabilities – we once had 330+users’ data sent via the middleware and the response time and synchronization on the SFSF instance was almost immediate. However, this is a small data sample and we will soon test with a larger package.

1.      2. Integration Scenario for Compensation Data using a middleware (SAP NW PI in this case)

Quick Facts

Compensation Data Export

  • SAP NW PI is mandatory for this standard integration to work. File download options are not available here.
  • Field sets and field assignments for compensation data export is to be defined separately in IMG.
  • SAP provides a set of standard data extraction elements (predefined logic) for exporting data to basic compensation fields in SFSF. Custom logic will have to be plugged in via BADI’s to export data to other data fields.
  • Compensation templates have to be created and assigned to a group ID on SFSF before data can be exported from SAP.
  • Field set from SAP & Comp Group ID from SFSF are prerequisites to run the compensation data extraction program (RH_SFI_SYNCH_COMP_DATA)

o   Field sets will define what data is extracted from SAP and how these values are determined

o   Group ID will define the set of compensation templates to which data is to be extracted to

Compensation Planning in SFSF

  • Comp data from SAP is first imported into staging tab
  • Compensation forms are to be created to import this data from staging tables.
  • Complete the Compensation Planning exercise in SFSF – Comp forms should be found in the completed section
  • Create an Ad-Hoc report to import the comp results back to SAP

Compensation Data Import

  • Field sets and field assignments have to be defined separately for importing data from SFSF.

Pic 6.jpg

  • Fields can either be imported from SFSF or entered during data activation or determined via BADI’s.·   
  • Field set from SAP for data import & Ad-Hoc report ID from SFSF are prerequisites to run the compensation data import program (RH_SFI_IMPORT_COMP_DATA) 

o   Field sets will define what data is imported from SFSF and how these values are determined

o   Ad-Hoc report are used by the SFSF API’s for extracting data out of SFSF

Pic 7.jpg

Activate Compensation data in SAP

  • Field set for data import and SFSF comp template ID are pre-requisites for running the data activation program (RH_SFI_ACTIVATE_COMP_DATA
  • Fields which was earlier defined as “entered during activation” can be advised with values here.

Pic 8.jpg

Pic 9.jpg

Pic 10.jpg

Conclusion

We acknowledge that this integration add-on, when put to test AS-IS is flawless. Complications could kick in when we try to align custom data models on SAP with SFSF data models and try to have real-time integrations & synchronizations around these processes. We have started to work in this direction and will share our experiences on this forum soon.

With specific reference to Hybrid deployment models, everyone understands that it is imperative to have a very clear strategy in place – Purpose of both these instances (SAP HCM & SFSF) in a synchronized set up has to be clearly differentiated such that one compliments the other and does not contradict in any way and it’s important for SAP to facilitate this transformational journey. As we speak today, if I ask myself this question: Has SAP done enough to facilitate a smooth transition to a Hybrid model? the answer is an obvious NO. I am sure a lot of my fellow consultants will agree with me.

Let me explain why I think so – Let’s consider a hybrid setup advocated by SAP – SAP HCM On-Premise for the Core HR solution (with or without Time & Payroll) and SFSF Bizx suite for all Talent Management processes. One foremost mandate for most customers would be around having a centralized system for all master data and have applications, built around this centralized system, consume data from a common source, perform all employee processes and update the common source will all the latest changes.

For this to materialize, it is important to have a complete and a comprehensive suite of standard process integrations which links up every single component on SFSF Bizx talent management suite with On-Premise SAP HCM Ex:  if I use Performance Management in SFSF, there should be a provision to bring the appraisal data back to SAP so that I have one instance centralizing all the master data in it. This applies to every other component on SFSF like Learning or Succession or Goals Management. On this note, SAP & SFSF have started right with the Pay for Performance & Attract to hire (expected soon) process integrations but should look at increasing the pace at which these integrations are delivered. It will also be interesting to see how a fusions of mobile apps from SAP & SFSF work in a synchronized or hybrid setup.

To report this post you need to login first.

15 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member

    Thanks for the post. Harish and I worked closely on conducting the pilot test. I wanted to provide some additional clarity on the PI related hot fix referenced in the post.

    We ran into issue with Proxy Server and Certificate exchange using axis adapter. This was resolved by SAP’s hotfix. Before the hotfix SAP PI SOAP adapter was not able to reach SuccessFactors site and resulting into “Connection Timeout” error. Post fix, we were able to see the trace of passing through proxy server and certificate exchange in SOAP adapter trace.

    (0) 
    1. Former Member

      Hi Praveen and Hamish,

      Excellent post, thank you!

      I’m trying to create a pilot for my company using our PI 7.11 and I’m receiving the exact same “timeout” error. Can you please let me know where exactly can I find this Hot-Fix?

      Thanks in advance

      (0) 
      1. Former Member

          Hi Rodrigo,

         

        You should first install #1514898 XPI inspector to reproduce the issue and get the trace. Use example 50 in the tool for this. Once you analyze it is not your network issue you can create a SAP customer ticket to get the hot fix. You may also attach XPI PI inspector log with the message.

        (0) 
  2. Former Member

    Useful document thanks. In our scenario we have no middleware, so just file extract using the BizX add-on then file-transfer (SFTP).

    Similarly, we have no Portal, only ERP. Out of interest, any experience of establishing SSO to Successfactors with just ERP and no Portal?

    (0) 
  3. Former Member

    Thanks Harish for such a nice blog.

    We want to send  Employee Data from SuccessFactor to  3rd party ( non-Sap) systems using PI 7.3 as the middleware.If i understand correctly there are 2 ways SF can connect to PI 1) CSV file ( using SFTP) 2) SOAP( with axis protocol).

    Can you please let me know which is the best here  and also step by step process for each?

    I heard that SF is having API for each business process ( i.e employee data, payroll, time management etc).. Does the API means webservice ? Can we import this in PI?

    Thank in advance.

    (0) 
    1. Luke Marson

      Hi Biplab,

      From SuccessFactors you can use the APIs for each process and use the PI middleware to retrieve it for you 3rd party system. The API would use a web service in this scenario.

      Best regards,

      Luke

      (0) 
      1. Former Member

        Hi Luke,

        If we useĀ RH_SFI_SYNCHRONIZE_EMPL_DATA for employee data to SuccessFactors, Do we have any option to execute a delta run on ad-hoc basis.

        Example :
        UserA part of full load : Day 1
        UserA status changed to inactive
        UserA part of delta load : Day 2

        If we miss the file from Day2, do we have the capability to trigger the same delta again?

        Regards,
        Balu

        (0) 
  4. Former Member

    Hi Harish,

    Thanks for the great blog.  One question – with integration for Compensation, where are the eligibility rules and budgets maintained – on the SAP side or in SFSF? 

    Paul

    (0) 
  5. Former Member

    Harish,

    Thank you for the post it has been very helpful. My client is running into an issue getting the data to populate in the Compensation forms. We are sending the data over from SAP to SuccessFactors, we have the group id setup but the data is still not populating in the forms.

    You mention the compensation data staging table in this post. How is the staged data table referenced to the form? Is it referenced on the XML template? Any guidance would be greatly appreciated.

    Regards,

    Don

    (0) 
  6. Former Member

    hi,

    I am installing the add-on via file download, and have configured through the transaction SM69 to execute an external command sending file to SFTP server SFSF.

    Anyone know how to make these connections?

    Thank you very much.

    (0) 
  7. Former Member

    Hi Harish,

    We have SAP to SF integration for our client and have report RH_SFI_SYNCHRONIZE_EMPL_DATA to synch data between SAP and SF but we are having issues running this report. After the report had run we have 0 employees which are successfully processed and majority of error out records have error Technical error: Web service: Application Error”

    Is this due to connection problem between SAP and SF where records are failing to move from SAP to SF or getting stuck in PI middle ware

    Error.jpg 

    (0) 
  8. Muniyappan Marasamy

    Hi Harish,

    1. is it mandatory or optional to Complete the Compensation Planning exercise in SFSF?


    we have sent compensation carsalary to Successfactors and we can see it in the log that compensation is updated in staging table. but when we checked in the system, employee id is not having any compensation details. currsalary is empty.

    2. for report RH_SFI_IMPORT_COMP_DATA, where can i find the adhoc report name?

    is this entity name which is present in the SFAPI data dictionary?

    i have checked in my SF instance, but i dont find any entity called “1503”

    Regards,

    Muni

    (0) 

Leave a Reply