In some environments we don’t have the option to use Graphical User Interface (GUI) and for that reason all programs have to be installed using command line. In this case we need to install GoldenGate Microservices 21c. Downloading GoldenGate Software The GoldenGate software can be downloaded from https://edelivery.oracle.com or download the latest version…

During the development of ETL processes one of the main goals is to have your processes fully automated and avoid manual intervention. In this case we are going to use OCI Data Integration parameters and Pl/SQL SDK to achieve this automation. Which problem do we want to solve? We have a customer that needs to receive as…

Oracle Data Integrator (ODI) Marketplace can use Autonomous Database Base (ADB) to store ODI Repositories. In this blog, I’m going to explain what needs to be changed when your organization decides to rotate the ADB wallet or for any other reason, the wallet is not valid anymore. Errors you will find when the wallet is not working: oracle.odi.core.config.MasterRepositoryResourceFailureException: ODI-10182…

As part of a Data Warehouse project, at some point there is a discussion about how to load incremental data into the Data Warehouse. There are multiple ways to achieve that, for example David Allan showed in this post how to use metadata to bring extracts from Fusion Apps. This…

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…