Oracle Object Storage allow customers to store any type of files in any format. It can be used as a central source of data for Data Science, ETLs and Data Warehouses projects. For this article we want to store data from one source (MySQL) into Object Storage. To have data…

To configure ODI for Disaster Recovery (DR) we must make sure that the Software (ODI ) and the ODI Repositories (Database schemas stored on autonomous) are properly configured. We are going to implement this solution: Pre-requisites Autonomous Database created in Primary Region; Oracle Data Integrator (ODI) Marketplace created on Primary…

Oracle GoldenGate is a comprehensive software for enabling the replication of data in heterogeneous data environments. In this article, I’m going to show you how you can load data from a PostgreSQL into an Autonomous Data Warehouse. Pre-requisites Oracle GoldenGate 21c for Non-Oracle Databases (PostgreSQL) Oracle Cloud Infrastructure (OCI) GoldenGate deployment …

Oracle Security Zones automatically set up and enforce security policies for cloud compartments in Oracle Cloud Infrastructure. A security zone is associated with a compartment of the same name and includes security zone policies or a “recipe” that applies to the compartment and its sub-compartments Currently, OCI DB Systems also…

Kafka is widely used by countless companies for event streaming, data integration and so on. The installation of Kafka is quite simple following the documentation you can have you first topic created in less than 30 minutes. However, if you need to use Kafka in a secure way you will…

OCI Data Integration is a serverless ETL tool fully managed by Oracle. Right now, doesn’t have an FTP connector out of the box. In this article, I’m going to show you how to move data from FTP using OCI Functions. We are gonna use a python script to connect to…

ODI supports Groovy among others scripting languages. Groovy is the choice when you want to build very customized solutions on ODI when you need for example a GUI to prepare a workflow. On my github you can check all the code that I prepared. I will explain the use case. Creating a Graphical User Interface (GUI) with Groovy …

Loading data from Fusion Apps (ERP Cloud, HCM etc) to Autonomous Database is one of the most required use cases that ours customers ask for help. We can use ODI to do it, you can find how to do it here. …

Oracle Analytics Cloud(OAC) is nativity integrated with IDCS (Identity Cloud Service). There is a relation between the IDCS roles and OAC Roles, that we can find on documentation. How to assign automatically roles to new OAC users? To assign roles automatically we need to use Functions, API Gateway and Health checks. As we can see, we are going to…