Technical Articles
SuccessFactors Integrations Beginners Guide- API User Creation and Connectivity
Introduction:
This is continuation of my original series SuccessFactors Integrations Beginners Guide and in this blog will show how to create API User to use it in SAP CPI.Also some basic connectivity steps from SAP Cloud Platform Integration Suite- Integration Service
There are multiple ways to create an Technical User and will see simplest way of creating one.
User Creation:
We will take file based approach where we will export existing User Data and using the same temple will be creating new User ID required for our purpose.
Step 1:
Log on to SuccessFactors as Administrator.
Step 2:
Navigate to Admin Center and open Employee Export from Tools Search bar.
Step 4:
Remove all rows except the first 2 header rows (the attributes in the fields of the existing users can be references for creating new records). Add rows for the user IDs you require, in our case SF_INT_USER ( below is just an example for reference ) .Save the file with..csv extension.
STATUS,USERID,USERNAME,FIRSTNAME,NICKNAME,MI,LASTNAME,SUFFIX,TITLE,GENDER,EMAIL,MANAGER,HR,DEPARTMENT,JOBCODE,DIVISION,LOCATION,TIMEZONE,HIREDATE,EMPID,BIZ_PHONE,FAX,ADDR1,ADDR2,CITY,STATE,ZIP,COUNTRY,REVIEW_FREQ,LAST_REVIEW_DATE,MATRIX_MANAGER,DEFAULT_LOCALE,PROXY,seatingChart,CUSTOM01,CUSTOM02,CUSTOM03,CUSTOM04,CUSTOM05,CUSTOM06,CUSTOM07,CUSTOM08,CUSTOM09,CUSTOM10,CUSTOM11,CUSTOM12,CUSTOM13,CUSTOM14,CUSTOM15,ONBOARDING_ID,PERSON_GUID,PERSON_ID_EXTERNAL,ASSIGNMENT_ID_EXTERNAL
STATUS,USERID,Username,First Name,Nickname,Middle Name,Last Name,Suffix,Title,Gender,Email,Manager,Human Resource,Department,Job Code,Division,Location,Time Zone,Hire Date,Employee Id,Business Phone,Business Fax,Address Line 1,Address Line 2,City,State,ZIP,Country,Review Frequency,Last Review Date,Matrix Manager,Default Locale,Proxy,null,Customizable Field 1,Customizable Field 2,Customizable Field 3,Customizable Field 4,Customizable Field 5,Customizable Field 6,Customizable Field 7,Customizable Field 8,Customizable Field 9,Customizable Field 10,Customizable Field 11,Customizable Field 12,Customizable Field 13,Customizable Field 14,Customizable Field 15,ONBOARDING_ID,PERSON_GUID,PERSON_ID_EXTERNAL,Assignment ID
active,SF_INT_USER,SF_INT_USER,SF_INT_USER,,,Administrator,,,M,SF_INT_USER@bestrun.com,NO_MANAGER,NO_HR,N/A,,N/A,N/A,US/Eastern,,SF_INT_USER,,,,,,,,,,,,en_US,sfadmin,,,,,,,,,,,,,,,,,,62D49D9DB4614877ABB8CCF28C954T62,SF_INT_USER,SF_INT_USER
Step 5:
Go Back to Admin Center and open Import Employee Data from Tools Search
Step 6:
Select Basic Import from drop down followed by selecting the CSV file from your desktop.Click on Validate Import File Data.
Step 6:
You should receive Validation Successful message like below and then proceed Importing by clicking Import
Step 7:
Step 8:
Look for the job you have created and if status is completed then we are good to with further steps.
Step 9:
Go back to Home Page and search for the new user created to make sure our user created successfully.
Step 10:
Reset the password to new which can be referenced in SAP CPI while creating Security Artifact.Navigate to Admin Center and search for Reset User Password to set new password.
Now we have created User Successfully in SuccessFactors.
Maintain Permission Groups:
Navigate to Admin Center and search for Manage Permission Groups to Create new Permission Group for API User.
Now you have Permission Group with name SFAPI_SCN created having user id SF_INT_USER assigned to it.
Maintain Permission Roles
Navigate to Admin Center and search for Manage Permission Roles to Create new Permission Role to grant security access to the SAP API user ID created.
Add new role and follow below instruction shown in screenshot.
In the above screenshot i have shown only roles related Manage Integration Tools.Please make sure below set of roles also needs to be assigned.
General User Permission –
- SFAPI User Login
Manage Integration Tools –
Select the following:
- Admin access to OData API
- Access to SFAPI Audit Log
- Access to SFAPI Metering Details
- Access to SFAPI Data Dictionary
- Access to OData API Metadata Refresh and Export
Employee Central API –
Select the following:
- Employee Central Foundation SOAP API
- Employee Central HRIS SOAP API
- Employee Central Foundation OData API (read-only)
- Employee Central HRIS OData API (read-only)
- Employee Central Foundation OData API (editable)
- Employee Central HRIS OData API (editable)
Metadata Framework –
Select the following:
- Read/Write Permission on Metadata Framework
- Import Permission on Metadata Framework
Manage User –
Select the following:
- Employee Export
Assign the newly created Permission Role to previously created Permission Group
Once done you should see below screen .Then Click on Make it active and make sure you have made selection to Permission Group.
Set API Login Exceptions
Navigate to Admin Center and search for Password & Login Policy Settings to make password non expiring for API user and Set IP Address Restrictions for API Users.
Now we are good to use this user in SAP Cloud Platform Integration Suite- Integration Service.
SAP Cloud Platform Integration Suite- Integration Service Configuration
Login into SAP CPI tenant and navigate to Monitoring –> Manage Security Material to create a credential that is later used in SuccessFactors OData V2 adapter.
Create a simple IFlow to get the records from SuccessFactors.
Step 1: Add Timer Event to run the IFlow whenever IFlow gets deployed.
Step 2: Add Request Reply from Pallet.
Step 3:Configure the SuccessFactors OData V2 channel ( you can use SuccessFactors SOAP for Compound Employee API ). API Server Address can be identified using SAP HELP Documentation.
Navigate to next tab Processing and click on Select Button next to Resource.There are 3 parts while forming the query
- Connect to System- Where you will input Credential and password to get the EDMX ( metadata ) file loaded to SAP CPI
- Select Entity and Define Operations: Where Operation,Entity ,Fields and Navigation levels for the entity are selected to form initial part of query .
- Configure Filter and Sorting: Filter and Sorting parameter are defined to form final query that needs to be executed from SAP CPI to fetch the data from SuccessFactors.
Finally Deploy the IFlow to get required data from SuccessFactors and can be seen using Monitoring tail of SAP CPI.
Hope this is helpful!
Regards,
Sriprasad Shivaram Bhat
Hi Sriprasad Shivaram Bhat
Great article for users who can go through each of the steps to configure by their own. Trust me users will like it and follow your blog without looking into other instructions. Also they try to bookmark.
Keep sharing more!
Thanks Yoga for the feedback.I will be happy if somebody looks into blog and give a try out.!
Regards,
Sriprasad Shivaram Bhat
Very nice blog Sri !!
Great blog! Thanks by sharing! This APIs can be executed by chatbots?
Well articulated blog! Looking for more such blogs esp. for beginners !!
Shliapa usataya, this is realy very interesting, thanks
Nice blog. Explained in simple steps. Really helpful for beginners. Thanks Sriprasad.
Thanks a lot Shiva,
Helpful DOc,
Please add IP whitelisting for API Users
Hello Sri,
Great article and the steps are very clear. Users can go through each of the steps to configure on their own. Trust me users will like it and follow your blog without looking into other instructions.
Keep sharing more!
Great article, with step by step configuration details, Thanks Sri.
I have a problem in accessing upsert functionality of SuccessFactors from CPI. I am using Succesfactors odata v2 adapter in CPI but I am unable to find the Upsert Enitity .
I cannot find the upsert Entity in the SuccessFactors OData v2 in CPI. But I am able to access the same using Postman. Other odata functionalities are accessible from CPI using Oauth2 saml bearer token. Upsert functionality belongs to function-import operation of SuccessFactors adapter. Is it implemented in SuccessFactors adapter?
Cannot find the upsert entity in SF adapter
Postman Client
In the screenshot, I am able to access the same upsert odata in postman using oauth token. I am unable to find the same in CPI. Kindly provide the solution for this issue.
Thanks in advance.