Skip to main content

 

 

Coupa Success Portal

3rd Party Data Warehouse Solutions

Overview

Coupa customers that have an Enterprise Data Warehouse (EDW) or Business Intelligence (BI) solution often ask us for data extracts from Coupa so they can integrate with their 3rd party Data Warehouse. We recommended that you start by looking at the existing capabilities within the Coupa platform: Data tables, Scheduled Reports, and the capabilities we have in the Coupa Analytics module. 

For customers who do not want to use Coupa Analytics or whose needs are not met by our current in-product capabilities, this offering, Coupa File Extracts for 3rd Party Data Warehouse Solutions, could be a potential consideration.

While Coupa integrations needed for a standard Coupa implementation (ERP integrations, etc.) are included as part of the Platform subscription, this additional integration solution is not included in the standard Coupa Platform subscription.

Summary of Capabilities

The following objects are available for export:

  • Requisitions
  • Purchase Orders
  • Receipts
  • Invoices
  • Expense Reports
  • Approvals
  • Approval Delegates
  • Contracts
  • User Logins
  • Invoice Payments

Data will be in a pre-defined standard Coupa CSV format and exported to a Coupa hosted SFTP server. Schedule and frequency will be predefined by Coupa, as will the extraction criteria.

Assumptions

  • Flat files use the following conventions taken from RFC 4180.
  • The delimiter is a comma: ,
  • All fields are always text qualified (enclosed) with the double quote character: "
  • Double quote characters within a field are escaped by another double quote character. If a user enters: Status is "Green" in a comment field, this would be represented as "Status is ""Green"""
  • New Line characters may be allowed within qualified field values.
  • Text-Encoding: UTF-8 (with No Byte Order Marker (BOM))
  • It is the responsibility of the client to delete the datafile from Coupa’s SFTP site once they consume the file.

Object Details

Object Extraction Criteria Frequency
Requisitions requisitions in “pending approval” status that have been updated since the last integration run hourly
Purchase Orders purchase orders that have been updated since the last integration run hourly
Receipts receipts that have been created since the last integration run hourly
Invoices invoices (except for “draft” or “new”) that have been updated since the last integration run hourly
Expense Reports Expense reports (except in draft status) that have been updated since the last integration run hourly
Approvals Approvals that have been updated since the last integration run daily
Approval Delegates Approval Delegates that have been updated since the last integration run daily
Contracts Contracts (Published) that have been updated since the last integration run daily
User Logins User logins that have been updated since the last integration run daily
Invoice Payments This will be added to the Invoice format as another (set of) line items. This will look for Approved invoices that have been updated since the last integration run hourly

Never should a customer use the Coupa API to extract data to from Coupa to send to a 3rd party Data Warehouse. That is not allowed or supported. 

 

  • Was this article helpful?