OCI Data Integration, REST APIs and and sFTP
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).
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;
https://blogs.oracle.com/dataintegration/post/data-integration-and-sftp
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!