Skip to main content

 

 

Coupa Success Portal

Architecture

Standard Flat Files or Coupa API

In the standard flat file integration approach, the data from Coupa is extracted into a pre-defined format and deposited on a Coupa hosted SFTP site. The middleware on the client side picks up the file, transforms that data and loads it into Oracle. The data from Oracle is extracted and transformed into Coupa standard file formats and deposited on the Coupa hosted SFTP by the client middleware system. Coupa then picks up the file and loads the data into Coupa.

With the API approach, the client middleware system calls the Coupa REST API to extract data from Coupa, transforms the data and loads it into Oracle. The data from Oracle is extracted and transformed by the middleware and then loaded into Coupa using the Coupa REST API.

Integration Architecture Overview

Oracle Open Interface tables and Oracle API

We use a combination of Oracle Open Interface tables, standard Oracle API and PL/SQL scripts to load and extract data to and from Oracle.

Oracle Open Interface Tables

Coupa to Oracle

The data from Coupa is extracted, transformed into native Oracle Open Interface table formats and placed on a Coupa hosted SFTP server. Using concurrent programs, the file is picked from the SFTP server and data is loaded into the Oracle staging tables and from there into the interface tables and eventually to the Oracle Base Tables.

Coupa to Oracle.png

Oracle to Coupa

The data Oracle base tables are extracted and transformed into standard Coupa file format using concurrent programs (PL/SQL scripts) and placed on a Coupa hosted SFTP server. Coupa picks up the file and loads the data into Coupa.

Oracle to Coupa.png

  • Was this article helpful?