Data Integration needs are growing day by day, and especially your replication needs are also increasing as your business evolves. Hence we at Oracle are strived to provide the new enhancements for the products around Oracle GoldenGate to make your experience better. I am talking about Oracle GoldenGate Foundation Suite (OGFS) which is a broader umbrella covers Oracle GoldenGate Studio and Oracle GoldenGate Management Pack (Veridata, GoldenGate Monitor, Director, REST-based Interface and OEM Plug-In). In series of blogs, I will be updating you about the new features that we have recently added for OGFS products.
Let's start with the GoldenGate (OGG) Monitor in this blog.
OGG Monitor Bundle Patch (18.104.22.168.171115) was released end of November. Mainly, we have provided three enhancements and few improvements around the product. When you are using Oracle Big Data Adapter, it requires you to provide the .properties configuration file for each Big data targets. These .properties files are needed to store the big data target related metadata information. Now with this release, you can edit, save the OGG for Big Data parameter file and .properties file from Monitor editor. All the configurations can be viewed/ modified/saved from Monitor centrally.
The other enhancement was around improving the purging history table. GoldenGate Monitor stores historical data in the repository database, and you can use Oracle or SQL Server databases for the same. In this release, we improved the performance of the purging historical data for Oracle database repository. When your historical information grows further, purging and maintaining the massive amount of data was time-consuming. Every month, OGG Monitor will create the new partition and stores all the data into the new partition. When you purge the historical data, the partition will allow Monitor to purge the data faster.
If you are an existing user and want to get the benefit of purging data improvement, you can partition your current history table by executing the oracle_partitioning.sql script after an upgrade. If you choose not to execute the oracle_partition.sql script after the upgrade, your repository table will not be changed, and you would continue running the repositories as you would earlier.
Oracle GoldenGate has released the major release in last month, OGG 12.3. In this version, Oracle GoldenGate supports two modes, Classic and Microservices architecture. The Microservices architecture is a new age of Cloud ready, REST services-based architecture, empowers you to design, build, embed, and automate all aspects of your replication environment on premise and in the cloud. You can find more details around the OGG 12.3 from the blog written by my colleague Thomas Vengal. Release Announcement for Oracle GoldenGate 12.3.
OGG Monitor certifies the OGG 12.3 Classic mode. Now you can monitor the OGG 12.3 Classic mode Instances from OGG Monitor. To Monitor the OGG 12.3 heterogeneous platforms using classic mode, please make sure that you have a more recent patch installed for OGG.
In future articles, I will write about OGG Studio, OGG OEM PlugIn and Veridata.