OCI Data Integration, REST APIs and and sFTP

David Allan
2 min readDec 9, 2021


This post will cover an example of using REST Tasks from within OCI Data Integration to provide functionality within your integrations. The REST Task allows you to easily integrate an endless number of operations — the whole OCI surface has REST APIs! Create a bucket in object storage, execute a command on a compute agent, execute a function and so on. Within OCI, Functions allow you to create business functions using a fully managed, multi-tenant, highly scalable, on-demand, Functions-as-a-Service platform — functions can also be executed via REST endpoint provided for each function.

Create REST Task

The REST Task in OCI Data Integration allows users to integrate endless REST based functions; method type headers, request payload and authentication mechanisms can be defined (see this section on REST Task authentication).

Define the endpoint, method type, headers and request body

The blog below provides an example SFTP functionality via an OCI Function and executed via REST from OCI Data Integration.

See the full blog here;


In this blog, we illustrated how to perform SFTP to transfer data into / out of Object Storage within OCI Data Integration. We also saw how using OCI Functions can help integrate custom transformations as a REST Task in Data Integration.

The code for the function is here;

Hope that this information helps and inspires some great use cases to orchestrate and integrate functionality as you learn more about Oracle Cloud Infrastructure Data Integration. For more information, check out the tutorials and documentation at Oracle. Remember to check out all the blogs on OCI Data Integration also!



David Allan

Architect at @Oracle developing cloud services for data. Connect on Twitter @i_m_dave