SAP Concur link
SAP Concur provides an integrated online business travel and expense management software solution that automates your travel expenses.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| Custom data | check | |
| Data blocking | check | Column level |
| Column hashing | check | |
| Re-sync | check | Connector level |
| History | ||
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | check | Get the models: source / transform |
| Private networking |
Setup guidelink
Follow our step-by-step SAP Concur setup guide to connect SAP Concur with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all SAP Concur connectors.
To zoom, open the ERD in a new window.Updating datalink
Fivetran will use one of the following strategies to update the tables that you included in your sync:
Incrementallink
We update the following tables and their associated child tables incrementally:
REPORTTRAVEL_REQUESTTRIP
Reimportlink
We reimport the following tables and their associated child tables in full to update them:
ATTENDEE_TYPEDELEGATORLISTLOCATIONREPORT_DETAILSUSER
The frequency with which we update these reimport tables is based on how fast we can ingest them from SAP Concur.
| Table Import Duration | Import Frequency |
|---|---|
| 10 minutes or less | Every sync |
| Between 10 minutes and 60 minutes | Once a day |
| More than 60 minutes | Once a week |
Concur API versionlink
Fivetran uses different versions of the SAP Concur REST API to sync different tables:
- Version 1.1 to sync the
TRIPandDELEGATORtables. - Version 3.0 to sync the
ATTENDEE_TYPE,REPORT,USER,LIST, andLOCATIONtables. - Version 4.0 to sync the
TRAVEL_REQUESTtable and the associated child tables.