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.
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.
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.
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.