How to Send Employee Master Data to a Third Party in XML Format Using Integration Centre
The Intent of this blog is to illustrate an example on how to send the master data from Employee Central to a third party in xml format using Integration Centre.
I will illustrate 11 simple steps on how to use Integration Centre for generating XML file and share it with third party In.
Earlier we were using Adhoc/ORD reports to send the data to SFTP, however with IC we can create tags as per client requirement and make it look like a real time integration that is why we are using Integration Centre.
SAP is now empowering Integration centre to accomplish such requirements where in now there is no use of any HCI integration, Consultants can achieve it via Integration Centre.
Here we are sending the data from Integration Centre to SFTP and providing the SFTP path to the Third party.
Client Requirement: Screen shot below is the format in which the third party would like to receive the data, and this data should include only those employee whose records were either updated today or if any new employees were hired in the system.
Step 1.How to setup Integration centre: – I would not like to give you a deep insight on setting up Integration Centre since these steps are mentioned in Implementation Guide.
You need to activate it through Upgrade centre first then Need to give the Necessary “Manage integration settings” Permission, as given in Implementation guide
Step2:- Navigate to Admin CentreàCompany SettingsàIntegration Centre.
Integration page will be displayed to build a new integration select My Integration, on the right side there is an option to Create When you hover on this field you will get few drop down values, Select “More Integration type” as an option
Now you have to select the following radio buttons as given in screenshot since we would like to schedule this integration hence Trigger type should be Schedule, Source type as Success Factors since we are sending the master data from Employee Central, Destination type should be SFTP and Format should be XML.
Step3: Before starting of Integration we have to select the root node, here we are choosing “EmpJob”.
Step4:- Now as you can see in the given screenshot there are 6 steps to complete this integration.
a)Options b)Configure Fields c)Filter and Sort d)Destination Settings e)Scheduling f)Review and Run.
Step5 In Option we will give the name of our Integration.
Step6: In Configure field on the left hand side you will find a field detail view which contains a Root node, we can add as many child elements under this root node as per our requirement. For example if we want these 3 fields in our integration First Name, Last Name, User ID then we can add 3 child element and then rename them based on our requirement.
Now we need to assign attribute to these Child element, simply select your child element and click on “+” icon àAdd Attribute
Step7: After adding, you need to associate the fields with elements and attribute as defined in screenshot. For Example User ID should be mapped with the respective field in Job Info.
Step8: Next is Filter and Sort, here you can apply filters based on any specific requirement, for example, you would like to fetch the data that was modified since your last job run, then use following settings as given in below screenshot
Step9 : under destination settings, you need to maintain the SFTP server user name password, host address, and other details.
Step10: Under Scheduling, You have to define if the occurrence of this job is daily or weekly or Monthly, etc.
Step11: in the Final step you can see your complete query, now as soon as the job triggers you can see your file in the SFTP Server under defined destination folder.
I have tried to cover the basics of Integration center of sending data to sftp in xml format.
Hope it has been helpful !!
Visit Our SAP SuccessFactors HCM suite to transform your HR functions!
Great, useful blog Ashish!
Thanks Brandon. 🙂
Excellent article. Good work thank you!
Thanks Mushtaq.. 🙂
Well written Ashish!