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, EMPLOYEE_WORKFLOW_REQUEST, 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 | ||
| 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 |
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 connectors.
To zoom, open the ERD in a new window.NOTE: 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_PERMITEMPLOYMENTEMPLOYMENT_TERMINATIONEXTERNAL_PERSONAL_INFOEXTERNAL_TIME_DATAEXTERNAL_TIME_RECORDEXTERNAL_TIME_SEGMENTHOLIDAYHOLIDAY_CALENDARHOLIDAY_CATEGORYJOB_APPLICATION_AUDITJOB_APPLICATION_STATUS_AUDIT_TRAILJOB_APPLICATIONJOB_OFFERJOB_OFFER_APPROVERJOB_REQUISITION_POSTINGJOB_REQUISITIONOFFER_LETTERPAYROLL_RUN_RESULTS_ITEMPAYROLL_RUN_RESULTSPICK_LISTPICK_LIST_VALUEPOSITIONPOSITION_MATRIX_RELATIONSHIPPOSITION_REQUISITION_STATUSPOSITION_RIGHT_TO_RETURNTALENT_POOLTEAM_GOAL_OWNERTIME_ACCOUNT_TYPETIME_COLLECTORTIME_ZONEUSERSVENDOR_INFOWORK_ORDERWORK_SCHEDULEWORKFLOW_REQUEST
NOTE:
- 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.