2742107 - Integration Center: Frequently asked questions

 Integration Center: FAQ

• SAP SuccessFactors HXM Suite
• Integration Center

Q. Which modules are supported by Integration Center?
A: Integration Center supports all modules which are part of Successfactors Business Suite (Employee Central, RCM, Talent).

Q. How to I create a file with one-to-many (1:M) relationships?
A: With flat file formats like .txt, .csv, et al, it's not possible to output 1:M any relationships. You have to use XML or EDI stack output types.

Q. How to I choose the right starting entity?
A: Refer to the community blog Integration Center: Choosing the Correct Starting Entity.

Q. Can we trigger integrations based on the Intelligent Service Events?
A: Yes, Integration Center integrations can be subscribed to Intelligent Services Events. Whenever the Intelligent Services Event occurs, Integration Center-based Integrations are triggered.

Guide URL: Integrating Intelligent Services with Integration Center

Q. Can I update data within SuccessFactors once an Intelligent Service Event is triggered?
A: Yes, in this case, when you create the new integration in More Integration Types, choose Trigger Type as Intelligent Services and Destination Type as SuccessFactors.

Guide URL: Integrating Intelligent Services with Integration Center

Q. Can we create integrations to read and write data within SuccessFactors using single integration?
A: Yes, choose Create -> More Integration Types, then choose Source Type as "SuccessFactors" and Destination Type as "SuccessFactors".

Q. What if an SFTP file-based integration fails?
A: Check execution manager logs for the root cause of the error.

Guide URL: Monitor an Integration

Q. Can we create multiple headers for CSV file?
A: Check KBA 2641363 - How to create an outbound EDI stacked integration which will generate multiple header lines output file
Community Blog Reference.

Q. How do I calculate age or calculate date difference?
A: Check KBA 2571171 - How to create a Age calculation field in Integration Center.

Q. How many fields/columns of data can be uploaded using CSV Inbound integration?
A: Post 1802 release, 500 columns are allowed to use in inbound CVS files. Please check for more details in the Q28, too.

Q. Does IC support wild card characters on field filters?
A: No, but we do support US% which behaves like * in filters.

Q. In advanced filters, I don’t find the field in the dropdown.
A: Only those fields are included in the dropdown which have property SAP:Filterable set to True in the metadata. This can be seen under Admin Center -> OData API Data Dictionary for fields which have "Filterable" as true.

Q. Can I filter on fields which are not part of the output file?
A: Yes, in such a case, choose the Browse button under Advanced Filter, and select the fields. Please note only fields in the entity which have property SAP:Filterable set to True in the metadata will be shown and used.

Q. Can you retrieve details of inactive users in Integration Center?
A: Yes, apply filter as STATUS in "t,f". Reference KBA 2324204 - How to retrieve inactive employees via integration center.

Q. How to I import Photos using IC?
A: Check reference KBA 2519210 - How to Upload Profile Photos using Integration Center - OData API Photo Entity.

Q. How do I extract a candidates resume and cover letter?
A: Check reference KBA 2582360 - Data Extraction Request - Candidate’s Resume and Cover Letters - Recruiting Management.

Q. Is Compound Employee API supported in Integration Center?
A: No. Integration Center only supports OData v2 API.

Q. How do I avoid duplicate rows in Integration Center output file?
A: Enable the "Server Side Pagination" option.

Q. How do I retrieve First name and Last Name for inactive employees?
A: Apply filter as STATUS = Inactive to pull the data for inactive employees using USER as a starting entity. Reference KBA 2324204 - How to retrieve inactive employees via integration center.

Q. Can Integration Center support the key pairs from other software?
A: Yes, Integration Center can support keypairs from other softwares.

Note: The key formats that are supported by Security Center are .pub and .asc (Reference Guide).

Q. Could PGP files encrypted from SuccessFactors be decrypted by other software when the files arrive to a customer's SFTP?
A: No. The key-pair, when generated in Security Center, uses public key to encrypt and private key to decrypt. Private keys cannot be downloaded from Security Center.

Q. Is DELETE operation supported via Integration Center?
A: No. Integration Center does not support DELETE operation.

Q. Can we get LMS APIs available under Integration Center?
A: No. LMS API is not supported in Integration Center. Reference KBA 2634955 - Can we get LMS APIs available under Integration Center.

Q. How do I export job requisition pre-screening questions via Integration Center?
A: Reference KBA 2826605 - How to export job requisition pre-screening question via Integration Center?

Q. Is it possible to extract a report of all the integrations from Integration Center showing how many jobs got scheduled, how many were successful, how many failed, etc?
A: The only way to check the status of the Integration Center jobs is through Execution Manager Dashboard, which is explained in this page of the guide Monitor an Integration.

Note: If you really want to extract a file containing these details, note that Execution Manager Dashboard data is populated by the OData entity EMEvent. As a suggestion, you can create a job on Integration Center querying this entity in order to obtain the details of all the Integration Center's job that are running on your instance.

Q. If I want to have a filter on a field that is not equal to null, do I just do field name is not equal to (leave blank)?

A: Yes, you can leave the filter as 'blank' if you want to filter as null.

Q. What are the recommendations on Integration Center size for file loads? 

A: 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.

Q. What is the maximum time one Integration center job will run?

A: Prior to 2H 2023, if any job ran for more than 23 hours it will be automatically interrupted. Post 2H 2023, we reduced the threshold limit of jobs running in Integration Center to 10 hours. After reaching the threshold limit, the integration jobs are auto-terminated, and you can view the logs in Execution Manager. This guardrail has been added to improve the performance of the system.

This is an expected behavior of Integration center.

 Integration Center Guide

IC, FAQ, Server Side Pagination, public key to encrypt and private key to decrypt, Age calculation field in Integration Center, Compound Employee in Integration Center, SAP:Filterable, outbound EDI stack Integration, audit, report, INT-15502, 2H 2023, 2311, release, production, preview, ic, integration centre, H2 , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To