SAP Knowledge Base Article - Public

2742107 - Integration Center: Frequently Asked Questions

Symptom

This KBA provides answers to the frequently asked questions regarding Integration Center.

Environment

  • SAP SuccessFactors HXM Suite
    • Integration Center

Resolution

  1. Which modules are supported by Integration Center?
    Integration Center supports all modules that are covered by OData API, which you may refer to the "API Reference" section of the SAP SuccessFactors API Reference Guide (OData V2).

  2. How do I handle one-to-many (1:M) relationships?
    With flat file formats like .txt, .csv, etc., it's not possible to properly output 1:M relationships. For more details about this, refer to the KBA 3087941.
    It is possible to output it properly when using XML or EDI stack output types, refer to the KBA 3082922.

  3. When I execute my integration the output is missing some records. What could be causing this?
    The most common causes for this issue are the following:
    • There is some filter removing that record from the output, so review your Advanced Filters and Time-Based Filters.
    • Server-side pagination is not being used, more details in the KBA 2723468.
    • The scheduled version of your integration is outdated, refer to the KBA 2430723.

  4. Fields from User entity (or any navigation to User, like userNav field) are returning blank data. Why is that happening?
    Inactive users will always return a blank value in OData API unless you specifically ask for inactive users in the filters. This behavior is reflected in Integration Center too, refer to KBA 2786330 for more details.

  5. How do I properly choose a starting entity?
    Refer to the KBA 2761576 and the Help Portal page Best Practices on choosing the Starting Entity.

  6. What are the recommendations on Integration Center size for file loads?
    Find below the guidelines shared by SuccessFactors Engineering and Product Management colleagues:
    • We always recommend going with lower records size. Please always prefer delta load over full load wherever possible.
    • Always consider splitting jobs with very high numbers of records to be processed (which are typically long running) into multiple smaller jobs.
    • If higher number of records is inevitable (see points mentioned earlier), then for higher number of records, our recommendation is not to exceed 50k-80k records with 10-20 fields. If the number of fields increases, the number of records may need to be reduced.
    • The above figures depend on a number of parameters (e.g., number of jobs getting executed at that time on the server, the complexity of the DB query, the memory consumption of the servers), hence this should be taken as a general guideline. The recommendation is to split the jobs wherever possible.

  7. When editing the "Destination Settings" tab, the SFTP port value is defaulted to 22. Why can't I change it?
    After 2H 2023 release, the only port that Integration Center supports is 22. More details in KBA 3148291.

  8. I'm not being to extract future-dated or historical records (records from the past). Is it possible to extract them?
    Yes, it is possible. More details in the KBA 2470903.

  9. How do I check the execution logs of an Integration Center job?
    You can use the Execution Manager Dashboard tool to get the execution logs of an integration, including more details about errors. Refer to the Help Portal page Monitoring an Integration.

  10. Is it possible to trigger an Integration Center job based on the events from Intelligent Services Center?
    Yes, Integration Center integrations can be subscribed to Intelligent Services Center events so whenever the event is triggered, it will also trigger the Integration Center job linked to it. More details in the documents below:
  11. I'm seeing duplicate records in the output file generated by Integration Center. How do I fix that?
    Enable the "Server Side Pagination" option, more details in the KBA 2723468.

  12. How many fields/columns of data can be uploaded using CSV Inbound integration?
    500 columns are allowed to use in inbound CSV files.

  13. In advanced filters, I'm not finding a specific field. Why is that happening?
    Only fields which have the property SAP:Filterable set to True in the metadata will be available as filters. This can be checked on Admin Center > OData API Data Dictionary.

  14. How do I extract the resume and cover letter of candidates from Recruiting module?
    Refer to the KBA 2582360 - Data Extraction Request - Candidate’s Resume and Cover Letters - Recruiting Management.

  15. How do I export the Job Requisition pre-screening questions?
    Refer to the KBA 2826605 - How to export job requisition pre-screening question via Integration Center?.

  16. Is Compound Employee API supported in Integration Center?
    No, Integration Center only supports OData V2 API.

  17. Are LMS APIs available in Integration Center?
    No. LMS APIs arenot supported in Integration Center. Reference KBA 2634955 - Can we get LMS APIs available under Integration Center.

  18. In PGP Encryption, does Integration Center support the key pairs generated from an external software?
    Yes, this is actually done in Security Center and it supports the key pairs from other softwares.
    Note: the key formats that are supported by Security Center are .pub and .asc (refer to the Help Portal page Importing a PGP File Encryption Key).

  19. Could PGP files encrypted from SuccessFactors be decrypted by other software when the files arrive to my SFTP?
    If the key pair was generated in Security Center, it won't be possible since the private key (which is the one used to to decrypt) cannot be downloaded from Security Center.
    If the key pair was not generated by Security Center then it would be possible.

  20. How do I set up a filter for a null value?
    You can leave the filter as 'blank' if you want to filter as null.

  21. What is the maximum time that an Integration Center job will run?
    The runtime threshold for Integration Center jobs is 10 hours. After reaching the threshold limit, the integration jobs are auto-terminated. This guardrail has been added to improve the performance of the system.

See Also

Integration Center Help Portal

Keywords

IC, FAQ, Server Side Pagination, pgp, Compound Employee, ic, integration centre, threshold, limit, missing records, 1:m, one to many, one-to-many, frequently asked questions , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , How To

Product

SAP SuccessFactors HCM Suite all versions