Automation

Deleting GoldenGate trail files via the REST API (OGG-30375)

When automating your GoldenGate deployments, or tearing down a test environment, handling trail files is important. In fact, deleting an extract or a replicat does not delete the trail files it was writing to or reading from. It leaves(…)

The GoldenGate REST API Python client is now on pip

In a previous post, I shared the OGGRestAPI Python client I built for the GoldenGate REST API. Since then, I kept using it on production deployments, fixing it and adding new features along the way.

NGINX secured distribution path with GoldenGate REST API

In a previous blog, I presented how to set up a distribution path between two GoldenGate deployments both secured with NGINX. The method I used there was purely through the Web UI. But GoldenGate also(…)

GoldenGate 26ai out-of-place patching with Python

I already covered out-of-place patching from the web UI, but patching tasks should be automated, and clicking through the same screens for every deployment can get repetitive. Let’s do the exact same out-of-place patch of(…)

How to Standardize SQL Server Disks on VMs using Ansible

INTRODUCTION Today, the benefits of automation no longer need much explanation: saving time, reducing human error, and ensuring every environment remains aligned with internal standards. What is less obvious, however, is how using an Ansible Playbook can provide advantages(…)

Production-ready GoldenGate REST client in Python

Updated in June 2026, based on the latest version of the client. In this blog, I provide GoldenGate administrators with a fully working, production-ready Python client to efficiently handle GoldenGate REST API calls. From extract creation to user(…)

Querying GoldenGate REST API log efficiently

In this blog post, I will guide you on how to query the restapi.log file of your GoldenGate deployments more efficiently. These logs are a valuable source of information for GoldenGate administrators but are unfortunately not easy to analyze.

GoldenGate REST API basics with Python

Oracle GoldenGate REST API has been around for quite some time now, but I’ve yet to see it used in practice at customers. Every time I tried to introduce it, it was some sort of novelty. Mainly because DBAs(…)

Extend session timeout in GoldenGate Microservices Web UI

If you start using the GoldenGate web UI after installing it, you might end up thinking that extending the session timeout would be nice. Since there is no clear Oracle documentation on that matter, here are multiple ways(…)

GoldenGate 26ai Installation: Graphic and Silent Mode Comparison for Automation

26ai update: This article was originally written for 23ai. But not much changes when setting up GoldenGate 26ai. Just adapt the responseFileVersion when doing the silent installation, and that’s it ! As instructed in this(…)