Open in app

Sign In

Write

Sign In

Eloi Lopes
Eloi Lopes

87 Followers

Home

About

Jun 5

Install ODI Agent on ExaCC with ODI Marketplace

Customers using Exadata Cloud at Customer (ExaCC) with ODI they want to have a local agent running on ExaCC network. ODI Marketplace didn’t allow this until a couple of months ago. Now, we can use it and we will see how to do it. The ExaCC doesn’t have Graphical User…

Oracle

9 min read

Install ODI Agent on ExaCC with ODI Marketplace
Install ODI Agent on ExaCC with ODI Marketplace
Oracle

9 min read


May 10

Install GoldenGate Microservices 21c in silent mode

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…

Oracle Goldengate

4 min read

Install GoldenGate Microservices 21c in silent mode
Install GoldenGate Microservices 21c in silent mode
Oracle Goldengate

4 min read


Mar 27

Automate OCI Data Integration Pipelines with parameters

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

3 min read

Automate OCI Data Integration Pipelines with parameters
Automate OCI Data Integration Pipelines with parameters
Oracle

3 min read


Jan 31

Changing Autonomous Database wallet in ODI Marketplace

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: Uncategorized…

Oracle

3 min read

Changing Autonomous Database wallet in ODI Marketplace
Changing Autonomous Database wallet in ODI Marketplace
Oracle

3 min read


Nov 23, 2022

OCI Data Integration — Incremental data load

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…

Etl

3 min read

OCI Data Integration — Incremental data load
OCI Data Integration — Incremental data load
Etl

3 min read


Jul 21, 2022

OCI Data Integration and Oracle Data Safe— Masking sensitive data between environments

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…

Oracle

5 min read

OCI Data Integration — Masking sensitive data between environments
OCI Data Integration — Masking sensitive data between environments
Oracle

5 min read


Jul 11, 2022

GoldenGate monitoring and sending notifications

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 Golden Gate

2 min read

GoldenGate monitoring and sending notifications
GoldenGate monitoring and sending notifications
Oracle Golden Gate

2 min read


Jun 22, 2022

Configuring GoldenGate For SQL Server and load data into Autonomous Database

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

5 min read

Configuring GoldenGate For SQL Server and load data into Autonomous Database
Configuring GoldenGate For SQL Server and load data into Autonomous Database
Oracle

5 min read


May 31, 2022

GoldenGate for Big Data — Replication to Oracle Object Storage

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…

Golden Gate

5 min read

GoldenGate for Big Data — Replication to Oracle Object Storage
GoldenGate for Big Data — Replication to Oracle Object Storage
Golden Gate

5 min read


Apr 22, 2022

ODI Disaster Recovery using Autonomous Database with Data Guard

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 Data Integrator

4 min read

ODI Disaster Recovery using Autonomous Database with Data Guard
ODI Disaster Recovery using Autonomous Database with Data Guard
Oracle Data Integrator

4 min read

Eloi Lopes

Eloi Lopes

87 Followers

Opinions expressed are solely my own and do not express the views or opinions of my employer Oracle. https://www.linkedin.com/in/eloilopes/

Following
  • Mark Rittman

    Mark Rittman

  • Barack Obama

    Barack Obama

  • David Allan

    David Allan

  • Mike Durran

    Mike Durran

  • Fernando Harris

    Fernando Harris

See all (10)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech

Teams