There’s times when everything you need is in the box, then there’s times you need to get creative. Let’s see some cases for when you want to push the envelope and get creative in OCI Data Integration with respect to dataflows. Since the initial release, the list of operators is…

Here we will use the Oracle Cloud Infrastructure Data Integration Java SDK to execute a task which has been published to an application. To execute a task you’ll need the OCID of the workspace itself, the application key and the task key. Everything else can be defaulted and overwritten when…

I’ve been reading a lot of blogs and searching to determine how to load objects from Oracle Cloud Infrastructure’s Object Storage, Amazon S3, Microsoft Azure Blob Storage and so on into the Autonomous Data Warehouse specifically for XML. There are different options posted and blogs like the links below,

Loading…

One of the simplest ways to work with Oracle Cloud Infrastructure is via the CLI. This lets you do all kinds of interesting stuff with OCI Data Integration, Data Catalog and all other services! …

In this example we will see how we can execute all OCI Data Integration tasks published to an application using the OCI PLSQL SDK. The PLSQL function below takes the Data Integration application key as a parameter and lists all the published tasks, executing each one. …

How do you call the OCI CLI from ODI? It’s easy with the Operating System task. …

This use case illustrates an OCI Data Integration solution where the integration supports many consumers staging product inventory information, the files are posted to buckets in Object Storage. There is a bucket per supplier, different file formats are supported, some suppliers work with JSON, some work with TSV others with…

Here we will use the Oracle Cloud Infrastructure CLI to execute an OCI Data Integration task which has been published to an application. To execute a task you’ll need the OCID of the workspace itself, the application key and the task key. …