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)
Data ingestion is always the beginning stages of getting data into a data warehouse and/or cloud. Recently, we had the opportunity to design, build, and implement a data ingestion solution using Oracle GoldenGate Service (GGS) within Oracle Cloud Infrastructure (OCI). Within the a cloud-to-cloud environment,
The error OGG-02028: Failed to attach to logmining server OGG$<extract_name> error #,### – ORA-01292 LogMiner for upstream capture cannot find log file – is an indication that the Oracle archive log file that is needed for the extract to start is missing. There are a
Machine Learning (ML) and Artificial Intelligence (AI) is all the new, hot, shiny thing in the industry today. Everyone is looking for ways to make a business decision quickly and accurately. With this goal in mind, software manufactures are attempting to give access to machine
Oracle GoldenGate has been around for nearly thirty years and each year that ticks by more and more innovation is done to improve the product. This means as Oracle GoldenGate matures, the older release of Oracle GoldenGate have to be deprecated and then desupported, over
If you are running MySQL 5.7 or earlier and not sure if you should upgrade to MySQL 8.0, we think the following four features are items you don’t want to miss out on. Features in MySQL 8.0 that are key: 1. Transactional Data Dictionary: MySQL
MySQL has long been the number two database in the world! Initially MySQL started as one of the first open source databases that the world used as an alternative to Oracle and Microsoft’s SQL Server, so much so that sometime in 2009 Oracle purchased the