what is oracle goldengate? read&learn gg : part1

Photo by Maarten van den Heuvel on Unsplash

Welcome to the first blog of oracle goldengate series . This blog is meant for IT professionals and business managers exploring replication technologies in the market . You may be trying to solve a business problem of replicating your data in real time with integrity and security. I try to answer just 4 questions here hoping it helps you.

what is oracle goldengate?

Oracle goldengate is a replication technology to move data between different databases and data sources. Oracle goldengate also supports replication between heterogeneous source and target databases. Lets say you have OLTP oracle database , you set up a replication to a Mysql or Postgres database in real time and use them for analytics / audit or testing . You easily save on oracle licenses plus you save on compute on your source database.

why should i choose oracle goldengate 23ai?

Goldengate 23ai has a microservices architecture opposed to its previous version. Means you can have just one goldengate home for multiple deployments , so its easier to patch and upgrade. This architecture uses rest api, so its easy to administer . Your dba can login to any goldengate deployment running on cloud using the adminclient (previously ggsci ) running on his laptop. Goldengate 23ai is a enterprise software and has extended support till 2032.

what different source and target can it replicate?

Goldengate documents have a huge list of source and target replications. GG can do replication between sql databases like oracle , postgres , MySQL. It can stream to analytics platforms like Snowflake, BigQuery, Databricks, etc. It can also stream into multicloud environments and services like Amazon S3 / Redshift , Azure Data Lake / Blob Storage , Google BigQuery / Cloud Storage ,etc. You can read the complete list here .

where do i get started if i have to learn oracle goldengate?

Oracle Live Labs should be your starting points if you wish to get your hands dirty around various golden gate products and features. Another recommendation would be to read the goldengate 23ai microservices document.

References:

https://blogs.oracle.com/dataintegration/post/announcing-goldengate-23ai

https://docs.oracle.com/en/middleware/goldengate/core/23/index.html