Documentation

Documentation

  • Getting Started
  • Core Concepts
  • Using Fivetran
  • Usage-Based Pricing
  • Connectors
  • Applications
    • Application Reports
    • Lite Connectors
    • 15Five
    • 360Learning
    • 6sense
    • ActiveCampaign
    • Acumatica
    • Ada
    • Adjust
    • Adobe Analytics
    • Adobe Analytics Data Feed
    • Adobe Commerce
    • ADP Workforce Now
    • AdRoll
    • Affinity
    • Afterpay
    • Aha
    • Aircall
    • Airtable
    • Alchemer
    • Amazon Ads
    • Amazon Attribution
    • Amazon Cloudfront
    • Amazon Selling Partner
    • Amplitude
    • Anaplan
    • Appcues
    • Appfigures
    • Apple App Store
    • Apple Search Ads
    • AppsFlyer
    • Asana
    • Assembled
    • Attentive
    • Attio
    • Aumni
    • Auth0
    • Autodesk BIM 360
    • AvantLink
    • Awin
    • AWS CloudTrail
    • AWS Cost Explorer
    • AWS Inventory
    • Azure Boards
    • Azure Devops
    • BallotReady
    • BambooHR
    • BigCommerce
    • BillingPlatform
    • Birdeye
    • Bitly
    • Blackboard
    • Braintree
    • Branch
    • Braze
    • Brevo
    • Brex
    • Buildkite
    • Buzzsprout
    • Calabrio
    • Calendly
    • Campaign Monitor
    • Canny
    • Canvas
    • Care Quality Commission
    • Castor EDC
    • Ceridian Dayforce
    • Chameleon
    • ChannelAdvisor
    • Chargebee
    • ChargeDesk
    • ChartMogul
    • Checkout.com
    • Chorus
    • Churnkey
    • ChurnZero
    • Cimis
    • Cin7
    • CircleCI
    • Clari
    • ClickUp
    • Close
    • Coassemble
    • Codefresh
    • Collibra
    • Column
    • commercetools
    • Confluence
    • Contrast Security
    • Coupa
    • Criteo
    • Crossbeam
    • crowd.dev
    • Customer.io
    • Cvent
    • D2L Brightspace
    • dbt Cloud
    • DCL Logistics
    • DEAR
    • Delighted
    • Deputy
    • Destini
    • Dixa
    • Docebo
    • Drata
    • Drift
    • Drip
    • Dropbox Sign
    • Duoplane
    • e-conomic
    • EasyPost
    • Ellucian Banner
    • Eloqua
    • Employment Hero
    • Epicor Prophet 21
    • Eventbrite
    • Everhour
    • Expensify
    • EZOfficeInventory
    • Facebook Ads
    • Facebook Pages
    • FinancialForce
    • Flexport
    • Float
    • Fone Dynamics
    • Forj Community
    • Fountain
    • Freightview
    • FreshBooks
    • Freshchat
    • Freshdesk
    • Freshdesk Contact Center
    • Freshservice
    • Freshsuccess
    • Freshteam
    • Friendbuy
    • Front
    • FullStory
    • Gainsight Customer Success
    • Gem
    • GetFeedback
    • GitHub
    • Gladly
    • GlobalMeet
    • GoCardless
    • Gong
    • Google Ad Manager
    • Google Ads
    • Google Analytics
    • Google Analytics (MCF)
    • Google Analytics 360
    • Google Analytics 4
    • Google Analytics 4 Export
    • Google Calendar
    • Google Campaign Manager 360
    • Google Display & Video 360
    • Google Play
    • Google Search Ads 360
    • Google Search Console
    • Google Tasks
    • Gorgias
    • Greenhouse
    • GreenPowerMonitor
    • Grepsr
    • GRIN
    • Guru
    • HappyFox
    • Harvest
    • Heap
    • Height
    • Help Scout
    • Helpshift
    • HiBob
    • Hopin
    • HubSpot
    • iLevel
    • Impact
    • incident.io
    • Infobip
    • Insightly
    • Instagram Business
    • Integral Ad Science
    • Integrate
    • Intercom
    • Ironclad
    • ironSource
    • Iterable
    • Ivanti
    • Jira
    • Jira Align
    • Jotform
    • JustCall
    • Kandji
    • Katana
    • KeyPay
    • Khoros Care
    • Kissmetrics
    • Klarna
    • Klaviyo
    • Konnect Insights
    • Kustomer
    • Lattice
    • LaunchDarkly
    • LearnUpon
    • Lessonly
    • Lever
    • Liftoff
    • Lightspeed Retail
    • Linear
    • LinkedIn Ad Analytics
    • LinkedIn Company Pages
    • LinkSquares
    • LiveChat
    • Loaded Commerce
    • Lob
    • Looker
    • Loop
    • Loopio
    • Luma
    • Magento
    • Mailchimp
    • Mailgun
    • Mandrill
    • Marin Software
    • Marketo
    • Mavenlink
    • Maxio Chargify
    • Medallia
    • Megaphone
    • Meltwater
    • Mention
    • Microsoft Advertising
    • Microsoft Dynamics
    • Microsoft Lists
    • Microsoft Teams
    • Mixmax
    • Mixpanel
    • MNTN
    • Mode
    • Monday.com
    • Mux
    • Namely
    • Navan
    • nCino
    • NetSuite SuiteAnalytics
    • Notion
    • Nylas
    • Okta
    • Ometria
    • Open Data DC
    • Open Exchange Rates
    • Opsgenie
    • Optimizely
    • Oracle Business Intelligence Publisher
    • Oracle E-Business Suite
    • Oracle Fusion Cloud Applications
    • Oracle PeopleSoft
    • Oracle Siebel CRM
    • Orbit
    • Ordway
    • Ortto
    • OsCommerce
    • Outbrain
    • Outreach
    • PagerDuty
    • Papershift
    • Pardot
    • PartnerStack Vendor
    • PayPal
    • Pendo
    • Persona
    • Personio
    • Pingdom
    • Pinpoint
    • Pinterest Ads
    • Pipe17
    • Pipedrive
    • Pivotal Tracker
    • Piwik PRO
    • Playvox
    • PostHog
    • PowerReviews Enterprise
    • PowerSchool
    • PrestaShop
    • Prive
    • Productboard
    • Qualaroo
    • Qualtrics
    • QuickBooks
    • Ramp
    • Rarible
    • Recharge
    • Recurly
    • Reddit Ads
    • Reltio
    • Reply
    • RetailNext
    • Retently
    • Revel Systems
    • RevOps
    • RevX
    • RingCentral
    • Rippling
    • Rollbar
    • Rootly
    • RTB House
    • Sage HR
    • Sage Intacct
    • Sailthru
    • Salesforce
    • Salesforce Commerce Cloud
    • Salesforce Marketing Cloud
    • Salesloft
    • Salsify
    • Samsara
    • SAP Business ByDesign
    • SAP Business One
    • SAP Concur
      • Setup Guide
      • Release Notes
    • SCORM
    • Security Journey
    • SendGrid
    • Sensor Tower
    • ServiceNow
    • Sharetribe
    • ShipHero
    • ShipStation
    • Shopify
    • Shopware
    • Short.io
    • Shortcut
    • Simplecast
    • Simplesat
    • Skilljar
    • SkuVault
    • Slab
    • Slack
    • Smadex
    • Smartwaiver
    • Snapchat Ads
    • SonarQube
    • Split
    • Splunk
    • Spotify Ads
    • Spree Commerce
    • Square
    • Squarespace
    • StackAdapt
    • Standard Metrics
    • Statsig
    • Statuspage
    • Stripe
    • Stylight
    • Subscript
    • SurveyMonkey
    • Survicate
    • Swoogo
    • Tableau
    • Taboola
    • Talkdesk
    • Talkwalker
    • Teamwork
    • Tempo
    • The Trade Desk
    • Thinkific
    • TikTok Ads
    • Toggl Track
    • Transcend
    • Trello
    • Trisolute
    • Twilio
    • Twitter Ads
    • Twitter Organic
    • Typeform
    • Unicommerce
    • Upland Software
    • UpPromote
    • UserVoice
    • Veeva
    • Verizon Media
    • Vitally
    • Vonage
    • VWO
    • Web Scraper
    • When I Work
    • Wherefour
    • WooCommerce
    • WordPress
    • Workable
    • Workday Financial Management
    • Workday HCM
    • Workday RaaS
    • Workday Strategic Sourcing
    • WorkflowMax
    • WorkRamp
    • Wrike
    • Xero
    • Xray
    • Yahoo DSP
    • Yahoo Search Ads on Yahoo Japan
    • Yotpo
    • YouTube Analytics
    • Zen Cart
    • Zendesk Chat
    • Zendesk Sell
    • Zendesk Sunshine
    • Zendesk Support
    • Zenefits
    • Zingtree
    • Zoho Books
    • Zoho Campaigns
    • Zoho CRM
    • Zoho Desk
    • Zoom
    • Zuora
  • Databases
  • Files
  • Events
  • Functions
  • Destinations
  • Partner-Built
  • Transformations
  • Logs
  • Security
  • REST API
  • Local Data Processing (HVR 6)
  • Release Notes
RSS
Release notes RSS
HVR 5 Documentation
HVR 5 Documentation
  • Support
  • Sign In
Edit on GitHub

SAP Concur link

SAP Concur provides an integrated online business travel and expense management software solution that automates your travel expenses.


Featureslink

Feature NameSupportedNotes
Capture deletes
Custom datacheck
Data blockingcheck Column level
Column hashingcheck
Re-synccheck Connector level
History
API configurablecheckAPI configuration
Priority-first sync
Fivetran data modelscheck 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:

  • REPORT
  • TRAVEL_REQUEST
  • TRIP

Reimportlink

We reimport the following tables and their associated child tables in full to update them:

  • ATTENDEE_TYPE
  • DELEGATOR
  • LIST
  • LOCATION
  • REPORT_DETAILS
  • USER

The frequency with which we update these reimport tables is based on how fast we can ingest them from SAP Concur.

Table Import DurationImport Frequency
10 minutes or lessEvery sync
Between 10 minutes and 60 minutesOnce a day
More than 60 minutesOnce 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 TRIP and DELEGATOR tables.
  • Version 3.0 to sync the ATTENDEE_TYPE, REPORT, USER, LIST, and LOCATION tables.
  • Version 4.0 to sync the TRAVEL_REQUEST table and the associated child tables.

Questions?

We're always happy to help with any other questions you might have! Send us an email.

    Thanks for your feedback!
    Was this page helpful?