Integration between Successfactor and Servicenow HRSD
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2025 07:48 AM
HI,
I am trying to pull data from SF to SN HR profile table.
So I found out Trigger SAP SuccessFactors Integrations flow and source SAP Successfactors and I enabled HR profile schedule pull, which is using two flows "Retrieve Workers" and "Retrieve Effective Workers" and now my question is we have some custom field in SF side, we want to create some custom fields in SN side as well and pull the custom field's data as well, how to do that, where to change ?
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-23-2025 03:52 AM
Hello @RituparnaC43623,
- Identify the custom fields in SF: Determine which custom fields in SuccessFactors you want to integrate.
- Create corresponding fields in ServiceNow: Navigate to the HR profile table (likely
sn_hr_core_profile_person
) in ServiceNow and create new fields that match the data type and length of the corresponding SF fields. You can do this by going to System Definition > Tables, finding the table, and then creating new columns within it. - Consider the data type: Ensure the ServiceNow field type matches the data type in SuccessFactors (e.g., string, number, date, etc.).
-
Locate the integration flows:You've identified the "Retrieve Workers" and "Retrieve Effective Workers" flows. These likely use the "SAP SuccessFactors HR Profile" integration profile.
-
Modify the "Retrieve Workers" flow:
- Find the Data Source: Within the flow, locate the data source that retrieves data from SAP SuccessFactors. This might be a REST Message or an Integration Hub flow.
- Add Custom Fields: Update the data source to include the newly created custom fields from SuccessFactors. This might involve updating the OData query or REST API call.
- Transform Map: If there's a transform map involved in the flow, ensure it maps the incoming data from the custom fields in SuccessFactors to the corresponding custom fields in ServiceNow.
-
Modify the "Retrieve Effective Workers" flow:Repeat the same process as above for the "Retrieve Effective Workers" flow, as it likely uses the same data source and transform maps.
-
Test the changes:After modifying the flows, test the integration to ensure the custom field data is being pulled correctly from SuccessFactors and populating the corresponding ServiceNow fields.
-
Impact on existing data:Ensure that adding custom fields and modifying the integration flows doesn't negatively impact the existing data or functionality of the integration.
-
Data validation:Implement data validation rules in ServiceNow to ensure data quality and consistency.
-
Versioning:Consider using a version control system like Update Sets to manage changes to the integration flows and custom fields. This will help you track changes and revert to previous versions if needed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-23-2025 04:40 AM
Hi,
Data Streams are the preferred way to extend and customize SuccessFactors integrations in ServiceNow. Ensure your custom fields are included in the Data Stream output and mapped in the ETL process.
Try using Data Streams in ServiceNow to pull custom fields from SAP SuccessFactors.
Plan:
- Add custom fields to the HR Profile table in ServiceNow.
- Edit the Data Stream used for SuccessFactors integration to include your custom fields.
- Map the custom fields in the ETL Transform Map or Data Stream Transform.
Step-by-step
1. Add Custom Fields in ServiceNow
- Go to System Definition > Tables.
- Find your HR Profile table (e.g., sn_hr_core_profile).
- Add new fields matching your SuccessFactors custom fields.
2. Edit the Data Stream
- Go to IntegrationHub ETL > Data Streams.
- Find the Data Stream used for "Retrieve Workers" or "Retrieve Effective Workers".
- Edit the Data Stream Script or Field List:
- Ensure the custom fields from SuccessFactors are included in the API request and response parsing.
3. Map the Custom Fields
- Go to IntegrationHub ETL > Data Sources.
- Edit the Field Mapping for your Data Source.
- Map each custom field from the Data Stream output to the new ServiceNow field.
4. Test
- Run the Data Stream or ETL job.
- Verify that the custom field data appears in the HR Profile records.
Regards
Subbu