Oracle GoldenGate Licensing – Intro

Oracle GoldenGate Licensing is easy to get wrong, it is one of the most common non compliance issues for Oracle customer. But lets start by explaining what is GoldenGate? Goldengate is a software product that provides real-time data integration and replication services for various types of databases and systems. It allows you to capture and replicate data changes in real-time, ensuring that you have a current and accurate copy of your data at all times. Oracle GoldenGate can be used for a wide range of purposes, including data integration, data migration, data synchronization, and data warehousing.

One of the main benefits of Oracle GoldenGate is its ability to replicate data in real-time, with minimal latency. It uses a variety of techniques to capture and replicate data changes, including log-based capture, timestamp-based capture, and trigger-based capture. It also provides a number of options for replicating data, including synchronous and asynchronous replication, as well as the ability to replicate data to multiple targets.

Oracle GoldenGate Licensing

Oracle GoldenGate, only (a) the users of the Oracle database from which you capture data and (b) the users of the Oracle database where you will apply the data must be counted for the purpose of determining the number of licenses required

Oracle GoldenGate, only (a) the processors running the Oracle database from which you capture data and (b) the processors running the Oracle database where you will apply the data must be counted for the purpose of determining the number of licenses required.

This means you license both source and target database servers.

How does it work for Licensing non Oracle Databases?

• Oracle GoldenGate for Non Oracle Database, only (a) the users of the Non Oracle database from which you capture data and (b) the users of the Non Oracle database where you will apply the data must be counted for the purpose of determining the number of licenses required
• Oracle GoldenGate for Non Oracle Database, only (a) the processors running the Non Oracle database from which you capture data and (b) the processors running the Non Oracle database where you will apply the data must be counted for the purpose of determining the number of licenses required.

11 frequently asked questions about Oracle GoldenGate:

1. What is Oracle GoldenGate? Oracle GoldenGate is a software product that provides real-time data integration and replication services for various types of databases and systems. It allows you to capture and replicate data changes in real-time, ensuring that you have a current and accurate copy of your data at all times.
2. What types of databases and systems does Oracle GoldenGate support? Oracle GoldenGate supports a wide range of databases and systems, including Oracle databases, MySQL databases, Microsoft SQL Server databases, IBM DB2 databases, and many others. It can also replicate data between different types of systems, such as databases, mainframes, and applications.
3. How does Oracle GoldenGate capture and replicate data changes? Oracle GoldenGate uses a variety of techniques to capture and replicate data changes, including log-based capture, timestamp-based capture, and trigger-based capture. It can replicate data in real-time, with minimal latency, using synchronous or asynchronous replication.
4. Can I use Oracle GoldenGate to replicate data between different platforms (e.g., Windows vs. Linux)? Yes, Oracle GoldenGate can replicate data between different platforms. However, you will need to purchase a separate license for each platform on which Oracle GoldenGate is installed.
5. Can I use Oracle GoldenGate to replicate data between different versions of Oracle (e.g., Oracle 11g to Oracle 12c)? Yes, Oracle GoldenGate can replicate data between different versions of Oracle.
6. How is Oracle GoldenGate licensed? Oracle GoldenGate is generally licensed on a per-CPU basis. This means that you will need to purchase a license for each CPU on which Oracle GoldenGate is installed. There are a few different editions of Oracle GoldenGate available, each with its own set of features and capabilities.
7. Can I use Oracle GoldenGate to replicate data to multiple targets? Yes, Oracle GoldenGate provides the ability to replicate data to multiple targets. This can be useful for providing additional redundancy and failover capabilities.
8. Can I use Oracle GoldenGate to perform data transformations as part of the replication process? Yes, Oracle GoldenGate provides a number of options for performing data transformations as part of the replication process. The advanced edition of Oracle GoldenGate (called Oracle GoldenGate Advanced) includes enhanced data transformation capabilities.
9. Can I use Oracle GoldenGate to replicate data between non-Oracle databases (e.g., MySQL or Microsoft SQL Server)? Yes, Oracle GoldenGate can replicate data between non-Oracle databases as well as Oracle databases. It supports a wide range of databases and systems, including MySQL, Microsoft SQL Server, IBM DB2, and many others.
10. Does Oracle GoldenGate support real-time replication? Yes, Oracle GoldenGate is designed to replicate data in real-time, with minimal latency. It uses a variety of techniques to capture and replicate data changes, ensuring that you have a current and accurate copy of your data at all times.
11. Is Oracle GoldenGate easy to set up and configure? Oracle GoldenGate is generally easy to set up and configure, especially if you are familiar with database concepts and technologies. It provides a number of tools and utilities for managing and monitoring the replication process, as well as extensive documentation and online resources.

We hope this was helpful, if you want to get help with Oracle Goldengate licensing, our experts can help you. Contact us today.