SAP SuccessFactors Private Preview
SAP SuccessFactors is a cloud-based human capital management software.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | ADMIN_REASSIGN_OFFER_APPROVER, BACKGROUND_CHECK_RESULT, CANDIDATE_COMMENTS, CANDIDATE_TAGS, EMPLOYEE_TIME_ACCOUNT_BALANCE, INTERVIEW_INDIVIDUAL_ASSESSMENT, INTERVIEW_OVERALL_ASSESSMENT, JOB_APPLICATION_COMMENTS, JOB_APPLICATION_INTERVIEW, JOB_APPLICATION_ONBOARDING,JOB_APPLICATION_ONBOARDING_STATUS, JOB_APPLICATION_QUESTION_RESPONSE, JOB_APPLICATION_STATUS, JOB_APPLICATION_STATUS_LABEL, JOB_REQUISITION_GROUP_OPERATOR, JOB_REQUISITION_LOCALE, JOB_REQUISITION_OPERATOR, JOB_REQUISITION_QUESTION, JOB_REQUISITION_SCREENING_QUESTION, PICK_LIST_OPTION, SUCCESSOR, and WORK_OPPORTUNITY_TAX_CREDIT tables. |
| History mode | ||
| Custom data | check | BACKGROUND_CERTIFICATES, EMPLOYEE_COMPENSATION, EMPLOYEE_JOB, EMPLOYEE_PAY_COMP_RECURRING, EMPLOYMENT, EMPLOYMENT_TERMINATION, FO_BUSINESS_UNIT, FO_COST_CENTER, FO_DEPARTMENT, FO_DIVISION, FO_LOCATION, JOB_REQUISITION, PER_PERSON, PER_PERSONAL, POSITION, and USERS tables. |
| Data blocking | check | |
| Column hashing | ||
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
Setup guide
Follow our step-by-step SAP SuccessFactors setup guide to connect SAP SuccessFactors with your destination using Fivetran connectors.
Schema information
This schema applies to all SAP SuccessFactors connections.
Explore SAP SuccessFactors schema ERD
All the date fields are presented in the millisecond time-format.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
BACKGROUND_AWARDBACKGROUND_CERTIFICATESBACKGROUND_CHECK_REQUESTBACKGROUND_COMMUNITYBACKGROUND_COMPENSATIONBACKGROUND_COURSESBACKGROUND_EDUCATIONBACKGROUND_INSIDE_WORK_EXPERIENCEBACKGROUND_LANGUAGESBACKGROUND_MEMBERSHIPSBACKGROUND_MOBILITYBACKGROUND_PREFERRED_NEXT_MOVEBACKGROUND_PROMOTABILITYBACKGROUND_SPECIAL_ASSIGNBACKGROUND_TALENT_POOL_CORPBACKGROUND_TALENT_POOLBACKGROUND_VAR_PAY_EMPLOYEE_HIST_DATACANDIDATECANDIDATE_BACKGROUND_CERTIFICATECANDIDATE_BACKGROUND_EDUCATIONCANDIDATE_BACKGROUND_INSIDE_WORK_EXPERIENCECANDIDATE_BACKGROUND_LANGUAGECANDIDATE_BACKGROUND_OUTSIDE_WORK_EXPERIENCECANDIDATE_BACKGROUND_TALENT_POOL_CORPCANDIDATE_BACKGROUND_TALENT_POOLCANDIDATE_PROFILE_EXTENSIONCOMPETENCY_RATINGCOUNTRYCURRENCYCURRENCY_CONVERSIONEMPLOYEE_BENEFICIARYEMPLOYEE_COMPENSATIONEMPLOYEE_JOBEMPLOYEE_PAY_COMP_NON_RECURRINGEMPLOYEE_PAY_COMP_RECURRINGEMPLOYEE_PENSION_PAYOUTEMPLOYEE_TIME_CALENDAREMPLOYEE_TIME_SHEET_ENTRYEMPLOYEE_TIME_SHEETEMPLOYEE_TIME_VALUATION_RESULTEMPLOYEE_TIMEEMPLOYEE_WORK_PERMITEMPLOYEE_WORKFLOW_REQUESTEMPLOYMENTEMPLOYMENT_TERMINATIONEXTERNAL_PERSONAL_INFOEXTERNAL_TIME_DATAEXTERNAL_TIME_RECORDEXTERNAL_TIME_SEGMENTFO_BUSINESS_UNITFO_DIVISIONFO_DEPARTMENTFO_LOCATIONFO_COST_CENTERHOLIDAYHOLIDAY_CALENDARHOLIDAY_CATEGORYJOB_APPLICATION_AUDITJOB_APPLICATION_STATUS_AUDIT_TRAILJOB_APPLICATIONJOB_OFFERJOB_OFFER_APPROVERJOB_REQUISITION_POSTINGJOB_REQUISITIONOFFER_LETTERPAYROLL_RUN_RESULTS_ITEMPAYROLL_RUN_RESULTSPER_PERSONALPER_PERSONPICK_LISTPICK_LIST_VALUEPOSITIONPOSITION_MATRIX_RELATIONSHIPPOSITION_REQUISITION_STATUSPOSITION_RIGHT_TO_RETURNTALENT_POOLTEAM_GOAL_OWNERTIME_ACCOUNT_TYPETIME_COLLECTORTIME_ZONEUSERSVENDOR_INFOWORK_ORDERWORK_SCHEDULEWORKFLOW_REQUEST
- By default, we do not capture deletes for these tables. However, you can capture their deletes by manually re-syncing them.
- You must enable the
lastModifiedDateTimefield in your application to sync incremental endpoints. - We re-import all other tables not listed above during every sync to capture new and updated records. For those tables, if a record is missing in a sync, we mark it as deleted.
API endpoint permissions
If you encounter sync failures because of missing permissions, depending on the error, you must provide the API user role with one of the following permissions:
- Onboarding Integration permission
- Enable Export permission
Onboarding Integration permission
- Log in to your SAP SuccessFactors instance as an Administrator.
- Go to Admin Center > Manage Permission Roles.
- Select the role assigned to the API user you're using for the integration and then click Edit.
- Go to Permission Settings > Administrator Permissions > Manage Integration Tools.
- Enable Onboarding Integration permission.
- Save the changes.
Enable Export permission
- Go to Admin Center > Manage Permission Roles.
- Select the role assigned to the API user. Click Edit.
- Go to Permission Settings > Employee Data Export permissions.
- Enable Export permission for all the entities, and make sure that the query entity permission has no target population.
For detailed guidance on required permissions and role configurations, see the SAP SuccessFactors OData API Permissions Documentation.