Skip to Content
Author's profile photo Rinky Karthik

Integration Center – A viable and flexible alternative for LMS Connectors !

‘Integration Center’ is one of the powerful innovations/extensions added to SuccessFactors in recent times.

What is Integration Center (IC)?

When Integration Center (IC) was first introduced in Q2 2016, its primary objective was to enable HR Admins to build, run, schedule and monitor simple File-based Outbound integration. It is easy to build integration quickly and easily through a guided workflow. Predefined templates are available to give a kick start.

It has come a long way since and effective Q1 2017, you can use Integration Center to build Inbound Integration as well !

I have seen many of my existing clients use Integration Center to primarily build simple outbound integration for Benefits vendors and interfaces with other internal legacy applications that require basic employee data on a regular basis and IC serves this purpose effectively.

One of my key SuccessFactors focus area is – Learning. I have been involved with many SuccessFactors Learning implementations and one of the challenges I have seen recently (after Employee Central) is related to the amount of Data Fields customers wanting to move from BizX to LMS.

SuccessFactors Connector files are not that easy (read User Friendly) to work with not only for HR/HRIS Admins but for Application consultants as well. I am sure you will agree with me on that if  you have used SF User Connector in the past !

I was pretty excited when I configured and used Integration Center and explored its capabilities. Considering SuccessFactors Learning has its own database and requires a file feed from BizX like other third-party applications, I have been planning to use Integration Center to build an Outbound  Integration from BizX to SuccessFactors LMS and let go of the not so user friendly Connector. I had the time and chance finally.

Here are some steps and guidelines to build an integration using Integration Center.

Concept of Integration Center

With IC  you can create an integration from a starting entity with a guided workflow. The starting entity acts as the point of reference for reading data from SuccessFactors, for example, person biographical info from SuccessFactors Employee Central. You can add data from other entities by navigating via data model relationships to fields in related entities. For example, if the starting entity is person biographical info, you can easily incorporate employment information using such navigation references.
Procedure
  1. Type in ‘Integration Center’ in the Tools search area. You will see Integration Center Landing Page. Select ‘My Integration’.

2. On the My Integrations page, choose Create  Next navigation step Scheduled Simple Flat File Output Integration

3. Selecting the right Entity is important for integration built with Integration Center. The starting Entity becomes the parent entity at the top and creates relationship between other entities. Since we are sending User Data, we will select entity ‘ User’.

 

4. The entity User contains information about system user including Personal and Organizational information.

Select the Fields you want to send to LMS. The system immediately shows data values for selected fields as shown in the figure below.  You can also click on the ‘Add’ field icon to add additional fields at this stage.

One big advantage of using Integration Center is the capability to get any data fields from any portlets and send it to LMS. In the regular LMS Connector, only fields from UDF (User Data File) can be mapped to LMS fields.

5. You can right click on any Field/Column to change the Label on the go, move the field to left/right, delete the field etc.

 

6. One great benefit of using the Integration Center instead of the UDF (Employee Data File from Export) is that : You can send any data fields (standard or Custom) to LMS without having to add it to the User Data File or UDF model in Platform.

Note : For Employee Central Customers, to send additional fields (other than those in UDF), you have to map each field from the respective Portlet via ‘Configure Business Configuration’ transaction to a custom field in Platform side.

7. Once you have validated that all fields are added, the next step is to add a Filter if needed. This is helpful if LMS is live for a certain country/division/department only and needs to receive only a subset of the Employee data e.g. only for a certain Division or Department or Country.

8. Once Filter is added, the next step is to provide the Destination Settings (of the SFTP folder where this file will be saved. You can give a File name and your SFTP details in this step.

9. The next step is ‘Scheduling’. You can define the scheduling parameters i.e. how frequently the file will be run. Don’t forget to click on the ‘Save’ icon before clicking ‘Next’.

10. The final step is to review and run the file/schedule the job. Add the job schedule details and emails of LMS Admins or HR Admins that needs to be notified.

11. Before you submit the job, you can review the details in the last step as shown below.

 

12.I am not covering the necessary configuration steps required in LMS in this blog. However to process this file in LMS, you still have to complete the Connector mapping and schedule a Job in LMS get this file from required SFTP destination and process .

Using the same process with Integration Center (IC), you can send Employee data to any external vendor. Multiple Folders can be created in SFTP /Outgoing path and the external vendor can pick these files and process at their end.

IC is great tool to empower HR Super users without having to depend on technical programming/coding skills set.

Assigned Tags

      32 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Neat idea thanks for sharing will try this for sure

      Author's profile photo Rinky Karthik
      Rinky Karthik
      Blog Post Author

      Thanks Sandeep ! Please let me know how it goes !

      Author's profile photo Former Member
      Former Member

      Hello Rinky,

      Great blog, have been waiting for something like this for a while.

      I assume that there is also a way to configure the LMS connector to not expect the dual header line that the UDF export provides, as we cannot do this in the IC according to my knowledge?   If so, can you perhaps shed some light on that since that was thus far my biggest concern for switching to the IC.

      Thanks!

      Author's profile photo Rinky Karthik
      Rinky Karthik
      Blog Post Author

       

      Great question and I should have mentioned this in my Blog but I missed it. To use two headers, you have to define the Integration type as EDI Stacked. You can select that in Step #2 or in the following screen by selecting 'Integration Type'. The first section would be first header, second section would be second header and another for main entity values.

      I am not sure of any other method. @Sreelatha N, please share your experience if you used other methods.

       

      Author's profile photo Natasha Kowalski
      Natasha Kowalski

      Hi! great information, unfortunally I tried to do it, and didn´t get it. Could you please share some screen for the example? Thanks!

      Author's profile photo Former Member
      Former Member

      Hi Natasha,

      it is possible, check this blog: https://blogs.sap.com/2018/03/25/exporting-benefits-from-employee-center-using-integration-center-edi-format/.

      The IC Handling for EDI format is a little bit strange... but at the end it works with double header.

      Best

      Chris

      Author's profile photo Sreelatha N
      Sreelatha N

      Hi Rinky,  Thanks for sharing the information.  The Standard Employee export will take care of full chunk of data from EP to LMS.  It is useful not only in the scenarios where client would like to user filters for department it will also cover the scenario like difference of license sold i.e. EP 35K and LMS 20k which we are very often we are coming across.  We had implemented this to our customers. but while create IC we should be very careful of handling the scenarios of hire, retire and terminated as well.  To take of this scenarios I heard something in the roadmap not sure.Thanks

      Author's profile photo Rinky Karthik
      Rinky Karthik
      Blog Post Author

       

      Hi Sreelatha,

       

      Thank you  ! Yes its very helpful for Global customers. We have been hearing off late about the EC-LMS integration. May be in the next release. I don't have much insight into that.

      Author's profile photo Rinky Karthik
      Rinky Karthik
      Blog Post Author

       

      Hi Sreelatha, Can you please share your experience with the two header output. I have shared one way that I have used with Francois in the above comment. There might be other ways and I am also curious to explore how other customers are approaching this.

      Author's profile photo Maximiliano Varela
      Maximiliano Varela

      Hi,

      Good Article! I'm trying to use IC to send the LMS information on People Profile (Completed Courses) to SAP ERP but I'm not able to locate that background. Any idea??

      Thanks

      Author's profile photo Rinky Karthik
      Rinky Karthik
      Blog Post Author

      Hi Max,

       

      Are you trying to send Background data ? I don't think that's available yet. However looks like that may be available in the next Q3 release.

       

      Author's profile photo Anne-Mie Vanhulle
      Anne-Mie Vanhulle

      -Title of this article is a bit misleading. I thought you were able to upload data from IC without using the connectors. But it seems this is only for exporting and you still need the connector to upload data.

      -Any idea if/when SF is going to add LMS-data into IC?

       

       

       

      Author's profile photo Rinky Karthik
      Rinky Karthik
      Blog Post Author

       

      Hi Anne,

       

      You are right ! IC will only help one-way i.e. extracting data from SF. I am also eagerly waiting to see when LMS related entity would be available in IC. Seems like SAP was focusing mainly on Recruiting and Onboarding recently. Now that its taken care of i.e. most entities for RCM/ONB is now available in IC, I feel the next in line may be LMS. If I find out more from Q3 IRR, I will definitely share

      Author's profile photo Former Member
      Former Member

      Hi Rinky, great article and clear presentation. We've been playing around with this for a little while and agreed there are certain scenarios where it could be useful. However I seem to remember some comment in the last LMS IRR, to the effect that EC user data integration with Learning will be productized further, pretty soon. Did you catch that as well?

      It was great to meet you at ASUG in Chicago, BTW. 🙂

      -Chris

      Author's profile photo Rinky Karthik
      Rinky Karthik
      Blog Post Author

       

      Hi Chris,

       

      Thanks for your kind comments ! Yup I have also heard about the LMS-EC integration. Hopefully will hear more this week in the Q3 IRR. It was good to see you in Chicago !

      Author's profile photo Rekha Shukla
      Rekha Shukla

      while working on Organization connector we have the hierarchy as

      Department-->Division-->Business Unit coming from EC to LMS but our header file only has 3 fields,

      ORG_ID
      ORG_DESC
      ORG_ID_PARENT

      Has anyone covered, how to manage the levels when your starting entity is department and still cover the 3 levels in integration centre? Any suggestions are welcome.

      Author's profile photo Rinky Karthik
      Rinky Karthik
      Blog Post Author

      Hi Rekha,

       

      You can always use a transformation rule in the connector to default one value to the other. Also use Custom Fields to get the additional values from EC.

      Author's profile photo Anshul Walia
      Anshul Walia

      Hi Rinky

      Thanks for sharing the info.

      Is there options available  to do general Transformation in IC ?

      Thanks

      Author's profile photo Rinky Karthik
      Rinky Karthik
      Blog Post Author

      Hi Anshul,

       

      Please elaborate 'general transformation; 🙂 . You can always use the available entities to update or mass update data i.e. download a template, add data and upload. It will overwrite the tables.

       

      Author's profile photo Former Member
      Former Member

      Hi, Rinky - Though we are not using integration center here for LMS but for data extraction to third party systems, do you know how I can use multiple entities if the object selected does not have the navigation associated.

       

      for .e.g. I have selected PerPerson as my starting entity and now I would like to relate this to RBPRole to know whether the person is part of a particular RBP or not

       

      is the above feasible with integration center?

      Thanks in advance for replies

      Regards

      Rajesh

      Author's profile photo Rinky Karthik
      Rinky Karthik
      Blog Post Author

       

      Yes very much ! You can join multiple entities and the system by default suggests touch points. If you play around with the system, its pretty user friendly.

      Author's profile photo Former Member
      Former Member

      Hi Rinky,

      Could you share a doc wherein we could 'join multiple entities'.

      Thanking you in advance

      Pratap

      Author's profile photo Former Member
      Former Member

      Hi Rajesh, were you able to relate starting entity with more fields.

      Appreciate if you could send me an high level document showing how to connect entities.

      Author's profile photo Rinky Karthik
      Rinky Karthik
      Blog Post Author

      Hi Pratap,

       

      You can refer to the Integration Center guide available in help.sap.com. Just type in 'Integration Center' and you will see the guide. Its a huge document and I can't attach it here.There isn't a specific document for entity joins.

      You can join multiple entities by clicking on the + sign in the 'Configure Fields' step.

       

      Author's profile photo Former Member
      Former Member

      Thanks Rinky, appreciate your help.

      Just downloaded the guide and will read through it.

      I tried the + sign in the 'Configure Fields' but still having trouble adding other entities, my Starting Entity is "User".  Probably in my test system there could be some config missing.

      Author's profile photo Former Member
      Former Member

      Hi Rinky

      Is there any way to schedule the job hourly or minutes based. My client wants to schedule the job for every 30 min or hourly.

       

      Best Regards

      Raaj

      Author's profile photo Rinky Karthik
      Rinky Karthik
      Blog Post Author

      Hi Raaj,

       

      Good point. I don't think there is an option to schedule it  hourly yet. The only options are Once, Daily, Weekly etc. However, let me check and get back to you.

       

      Rinky

       

      Author's profile photo Anastasia Gureva
      Anastasia Gureva

      Hi Rinky!

      Thank you for your experience!

      I created the same integration, and it works a few times, but now I can’t upload the data to the LMS. User Connector SF usually gives the status “FAIL – FAILURE”. Do you know why it can be?

      Regards, Anastasia

       

      Author's profile photo T. Span
      T. Span

      Hi,

      I think your solution to create a Scheduled Simple File Output Integration is not working for the UserConnectorSF is expecting 2 headerlines;

      You should build your file with the second option Scheduled EDI/Stacked File Export where you have the possiblitity to add a second header line.

      Another problem I see when you use User as your starting entity is that you will not select inactive users. So in LMS you will not update the user to inactive status when they leave the company.

      Currently we are investigating whether we can create a Scheduled EDI/Stacked File Export that can be used to replace the Employee Export file.

      Will share the outcome, when this is successful.

      Author's profile photo Ana Pavalache
      Ana Pavalache

      Hi, have you managed to replace the employee export file with the Scheduled EDI/Stacked File

      Cheers

      A

      Author's profile photo Adam Rainwater
      Adam Rainwater

      I found a solution to show terminated employees on the integration.

      https://userapps.support.sap.com/sap/support/knowledge/en/2324204

       

       

      Author's profile photo Subramani Iyer Doraiswamy
      Subramani Iyer Doraiswamy

      Hi Rinky

       

      Can we use single header to LMS connector, if yes does that mean we use USER connector and not the USEF SF connector?

       

      Regards,

      SID