A data pipeline is a method in which raw data or unchanged data is ingested from various data sources and shipped to another data store, like a relational database, data lake, or a data warehouse; where the data is eventually used for analysis. Before data
Today, while helping a customer, we had to rebuild an extract. The integrated extract that we rebuilt was stuck in a loop and displaying it was an initial load extract from the HTML5 page (AdminService). The adminclient (cmd line), said it was working fine. After
Businesses are constantly finding themselves increasingly reliant on data ingestion, big data, analytics, and following traditional ETL (Extract, Transform, Load) processes; which at times can be a bottleneck to timely business functions. At AWS re:Invent 2023, Amazon recognized this and announced the concept of Zero-ETL.
Last week at Oracle Cloud World, the Oracle GoldenGate Product team announced the latest version of Oracle GoldenGate “Free”! This release of Oracle GoldenGate was produced to enable developers and small (under 20GB) production environments to build Oracle GoldenGate in an automated fashion – actually
Earlier today, I have been working on a few GoldenGate Obey files that will setup a customer’s environment; that is until I ran into an issue with AdminClient. I’m hoping this issue is more of a design overlook than a bug, but let’s see after
When building MySQL Heatwave Systems (use to be called MySQL Database Service or MDS), the need to add a Hostname to the system is critical. The system having a hostname will allow for other applications like Oracle Analytics Cloud (OAC) to connect to MySQL Heatwave.
Building a MySQL Database in Oracle Cloud Infrastructure (OCI) is easy. Within a few steps, you can build a MySQL instance for your development or production needs. To begin building, you first have to login into your OCI tenancy. After you have logged in, use
With the introduction of Oracle GoldenGate (Microservices), Oracle opened a lot of doors for people and organizations to create tools based off of the REST APIs. Initially, the REST APIs within Oracle GoldenGate were developed to ease administration and configuration of the product. This has
Creating Connections In Oracle GoldenGate (on-premises) we always have to setup a connection to the database. This is done by using the credential store to house the connection and then testing it. What happens when we move this concept to OCI and the GoldenGate Service
Deployments Deployments are a GoldenGate concept that has been around since 2017. In many cases, it is one of the more difficult things to explain, but when it clicks the concept is great and leads to many complex architectures. For the cloud, Oracle GoldenGate (Microservices)