The main goal of this article is to use OCI Data Integration and Oracle Data Safe to load and mask sensitive data between environments. OCI Data Integration is a fully managed, multi-tenant service that helps data engineers and ETL developers with common extract, transform, and load (ETL) tasks such as…

In GoldenGate Microservices architecture (on-premise or marketplace) is not available any out of the box feature to monitor and send notifications when a process fails. Since GoldenGate microservices has an extensive list of rest APIs that we can use and integrate with any application, I decided to take advantage of…

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 SQL Server into an Autonomous Data Warehouse. Pre-requisites Oracle GoldenGate 21c for Non-Oracle Databases (SQL Server) Oracle Cloud Infrastructure (OCI)…

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…