SAP Knowledge Base Article - Public

2691716 - Position Sync from Integration Center - Onboarding 1.0

Symptom

You would like to know how to sync Positions from BizX to Onboarding 1.0 using the Integration Center.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Onboarding 1.0

Resolution

Prerequisites:

  • An additional XSLT will need to be imported into Super Admin by the Operations team
  • Please follow the steps outlined in KBA 2473170  Additional Corporate structure XSLT File-Onboarding 1.0 , for this import.
  • Once that is completed, and the file is visible in the Super Admin UI, then:

Create an additional Corporate Structure level

  1. Navigate to Super Admin
  2. Corporate Structure
  3. Add Level, enter level number, Title, Data Key for Level Code,
    Data Key for Level Name, check Show in UI, Show in User Profile, and Create
    Add Corporate Structure Level.png
  4. Navigate to BizX
  5. Admin Center
  6. Integration Center
  7. My Integrations
  8. Create, select 'Scheduled Simple File Output Integration'
    Create Position sync Report.png
  9. Search for Position
  10. Select it
    Search for Report.png
  11. Choose Code (code) String(128), and Job Title (jobTitle) String(255), Position Name, ClientID.
    Select fields.png
  12. Click next
  13. Output File Type is CSV, Header Type is Simple Header
    Select file type.png
  14. Click Next, on the Configure Fields remember the headings of the report as it will be used later
    Row headings.png
  15. Click Next, Filter and sort is optional
    Filter and sort.png
  16. Destination setting, SFTP host address(URL) and credentials will go on the File Server Setting
    File server settings.png
  17. File Name is a combination of ONBAcountID_Position_Sync, File Extension is CSV,
    File Folder by standard will be /ONB/inbound (where the folder is located in SFTP)
    Folder name and path.png
  18. For scheduling, choose when it occurs, and the Start Time (Must be a future date)
    Scheduled.png
  19. Click next and save

Before running the job, additional files must be configured:

  1. Navigate to Super Admin
  2. Import/Export Settings
  3. Export these 3 files ImportPosition, FoundationImport, and FoundationImportFieldMapping
  4. Open the file in a text editor
  5. In the FoundationImport
  6. Copy the Location section of the code, and edit it to suit the Position entity.
    Copy Location.png
  7. Change the ID from SuccessFactorsLocation to SuccessFactorsPosition
  8. Change the File Mask from {AccountName}_Location*.csv to {AccountName}_Position*.csv
  9. Change the ImportXslt name from ImportLocation.xslt to ImportPosition.xslt
  10. Change the field Name from Location to Position
    Edit to Position.png
    Note: the changes made in these areas is based on the title of that level in the corporate structure
  11. In the ImportPosition file
  • Customers need to provide us with the ImportPosition XSLT file to upload into the system through the back-end
  1. Change the OrgLevel to the appropriate Org level for Position, in this example is 5
  2. The name of the variables in the ImportPosition file must be changed,
    the variables can be called anything, but they do have to match the variables in the FoundationImportFieldMapping
    Edit ImportPosition.png
  3. In the FoundationImportFieldMapping
  4. Copy the Location section
  5. Change the name from SuccessFactorsLocation to SuccessFactorsPosition
    Edit FoundationImportFieldMapping.png
  6. The Keys must match the variable in the ImportPosition XSLT.
    In the example below, they are Name and ClientID. The value must match the row heading of the report.
    Row headings excel.png
  7. If you have additional fields for Position, other than the standard fields Name and ClientID in the FoundationImportFieldMapping file, then you will need to add these additional elements within a Properties container in the ImportPosition file, see the below example showing the additional elements being added to the ImportPosition file:
    Additional Position Elements.png
  8. Save all files and import them back in Super Admin.

Keywords

Foundation Import, Position Sync, Corporate Structure, BizX, Integration, Onboarding, obd, sync, XSLT, super admin, , KBA , LOD-SF-OBD-INT , Integrations with Onboarding , How To

Product

SAP SuccessFactors Onboarding all versions