In this blog will discuss about the Export and Import Feature of Talent Intelligence Hub (TIH), which was released during second half of 2023. For more comprehensive understanding of Talent Intelligence Hub and its usage across SAP SuccessFactors suite you may please refer the IDP - “Talent Intelligence Hub: Implementation Considerations”
We will cover the following items in this blog:
- Current data structure in TIH
- Use Cases where Export/Import feature of TIH can be used.
- Export and Import Feature details in TIH
- Using SAP API (Business Accelerator) Hub to get the .icd files for Export/Import
- Integration Center Job setup to Export/Import data from/in TIH
- Sample Import and Export templates/files
- How to get Skillsplex Library data in TIH
So, let’s start with understanding first what are the different data elements in Talent Intelligence Hub and what are the different use cases where this Export and Import feature will be useful.
Current data structure in Talent Intelligence Hub (TIH)
There are two main components of TIH where data can be exported/imported:
- The TIH (Attributes) Library
- The Growth Portfolio
Further TIH (Attributes) Library has following set of data points and I have marked the ones which are today available with Export/Import Feature:
S.No. | TIH (Attributes) Library Entities | Can be used with Export/Import feature? |
1 | Proficiency Scale | No (should be created manually in TIH) |
2 | Attribute Type | No (should be created manually in TIH) |
3 | Attributes | Yes |
4 | Attribute’s Translation (Text) | Yes |
5 | Tags | Yes |
6 | Tag’s Translation (Text) | Yes |
7 | Behaviors | Yes |
8 | Behavior’s Translation (Text) | Yes |
9 | Attribute-Tag mapping | Yes |
10 | Attribute-Behavior mapping | Yes |
Use Cases
There are different scenarios where TIH Export/Import feature is useful:
- Import Feature
- Upload the above data in bulk in TIH either to update or create new. E.g.: Upload 100 new Skills in Attribute library, make attributes inactive in bulk, associate skills to multiple employee’s Growth portfolio etc.
- Integration with 3rd Party systems. E.g.: Get attribute data from another 3rd party system to SF TIH, could be the Skill Library data, could be Skill Profile data of employee to be migrated into Growth Portfolio which was maintained in different system earlier
- Export Feature
- Extract the data from TIH to know External Id or wsmid of an attribute for different mappings within SuccessFactors modules. E.g.: For attribute to tag mapping, one needs to know the external Id of both the attribute and tag in TIH OR while mapping the Skill/Competency attribute to Job Roles in Job Profile Builder, wsmid is required for mapping.
- Extract the data from TIH to send it to other 3rd party systems. E.g.: Sending Growth Portfolio data to other 3rd party systems for their consumption of Employee’s Skill profile data OR sending Attribute Library data to other 3rd party systems to maintain one common Skill/Competency Library in a customer’s organization across multiple systems.
Export and Import Feature Details
Talent Intelligence Hub leverages Integration Center for importing and exporting entities.
Prerequisites
Before starting with Export/Import process one needs to download the .icd (Integration Centre Definition) files from SAP API (Business Accelerator) Hub using below links:
Export/Import | SAP API (Business Accelerator) Hub links | Templates available for Export/Import |
TIH Library Export | · Attributes · Attribute’s Translation (Text) · Tags · Tag’s Translation (Text) · Behaviors · Behavior’s Translation (Text) · Attribute-Tag mapping · Attribute-Behavior mapping* | |
TIH Library Import | ||
TIH Growth Portfolio Export | · Growth Portfolio | |
TIH Growth Portfolio Import |
*Attribute-Behavior mapping - currently this only supports Behavior mapping with Competency Attribute type
What we get from SAP API (Business Accelerator) Hub links?
Each of the above link will take us to API Hub Page, where we see 3 different tabs:
- Overview: this tab provides detail about each entity and what fields are part of each template and how to use these templates.
Eg: SuccessFactors Talent Intelligence Hub Library Import Templates
- Integration Center Definition: “.icd” files can be downloaded from this tab.
- Documents: Sample import files representing the file formats are provided in this tab for reference.
Integration Center Job Setup for TIH
Importing Entities
The integration definition files contain all the details required for the inbound integration process.
Steps to setup Import Job:
- Go to Admin Center and choose Integration Center Settings.
- From the Integration Center Landing Page, select My Integrations.
- From the Integration Center - My Integrations page, choose + Create > Import an Integration Definition.
- Choose Browse and upload the integration definition file(In this case any of TIH import .icd files). You may get a warning message post that, please select OK in that step and proceed.
- From the Options page, enter an integration name and choose Next.
- On the Configure Fields page, review the sample data and choose Next. You may also choose to upload your own file to verify if it’s aligned to respective .icd file template.
- On the Source Settings page, specify the SFTP server details and choose Next. Also remember to upload your import file at designated sftp folder.
- On the Scheduling page, select the frequency as required or just select Suspended/Not Scheduled to run the job without scheduling it in recurrence and then choose Next.
- Now from Review and Run page, check the details of the job, then choose Run Now to run the inbound integration.
- You can check status of your job by going to Admin Center > Scheduled Job Manager
- Once the job is completed go to Admin Center > Manage Talent Intelligence Hub and check the data uploaded in Attributes Library, Tags etc.
Exporting Entities
The integration definition files contain all the details required for the exporting the data from TIH.
Steps to setup Export Job:
- Go to Admin Center and choose Integration Center Settings.
- From the Integration Center Landing Page, select My Integrations.
- From the Integration Center - My Integrations page, choose + Create > Import an Integration Definition.
- Choose Browse and upload the integration definition file (In this case any of TIH export .icd files). You may get a warning message post that, please select OK in that step and proceed.
- From the Options page, enter an integration name and choose Next.
- On the Configure Fields page, review the sample data and choose Next.
- On the Destination Settings page, specify the SFTP server details and choose Next.
- On the Scheduling page, select the frequency as required or just select Suspended/Not Scheduled to run the job without scheduling it in recurrence and then choose Next.
- Now from Review and Run page, check the details of the job, then choose Run Now to run the Export job.
- You can check status of your job by going to Admin Center > Scheduled Job Manager
- Once the Job is completed, check and download the exported file from your sFTP folder.
Sample Import Templates
Tags
Tag Text (Translations)
Attribute Import
Attribute Tag Mapping
Sample Export Files
Attribute Export File
Note: from 2403 release, Attribute Export file has got an extra ‘id’ column which is the ‘wsmid’ of an Attribute. This wsmid is used while mapping an Attribute (Skill/Competency) to Job Role via import.
Growth Portfolio Export File
Note: Few key pointers for Growth Portfolio Import/Export
- The Growth Portfolio import-export includes the current proficiency of the employee.
- The mandatory date format for imports is YYYY-MM-DD
- Person external Id- External ID of the person. This helps to have only one Growth Portfolio for multiple user assignments in the system.
- Proficiency Level - Proficiency level of the person for a particular attribute.
- Status- Allowed values are I and A. I for Inactive, A for Active. When marked I, then the attribute will not be visible on the portfolio.
- Preference Value - Allowed values are 0 or 1. 1 implies that the person is passionate or highly interested about the attribute.
- Proficiency Assigned Date - This is the last modified date for the attribute on the growth portfolio.
How to get SkillsPlex Library data in TIH
SkillsPlex library of skills was available earlier to be downloaded when Skills were part of Job Profile Builder (JPB)
Now, this entire library is available to be imported into TIH. The Import files can be downloaded from https://api.sap.com/package/TalentIntelligenceHubSkillsPlexAttributeImport/overview and then use the Import feature(as explained above) to load this data into TIH.
The documents provided in this package can be used to import SkillsPlex data into Talent Intelligence Hub of SAP SuccessFactors. This package provides data file for SkillsPlex Attributes, Tags, and Attribute to Tag Mapping.
Note: This is useful for customers, who had SkillsPlex earlier enabled at Job Profile Builder and now want to leverage that library in TIH as well.
Thanks for reading this blog and let me know any feedback/suggestions in comments.
- SAP Managed Tags:
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 |
