Blog

Oracle GoldenGate is one of the most favored real-time data fabric tools for its maximum availability, real-time data lakehouses, stream data process, data fabric, and data mesh capabilities. GoldenGate technologies are helping thousands of customers modernize and transform their businesses to make strategic decisions based on data analysis and interpretation of data to become more data-driven. A data-driven approach enables companies to gain insights by organizing their data with the goal of fully serving their consumers. Customers using Oracle Database@Azure can now use OCI GoldenGate, a fully managed cloud-native service, running on-premises or on Azure Compute to replicate data between Oracle Databases and Azure applications across on-premises, hybrid, and multicloud environments. OCI GoldenGate moves data in and out of these data stores in real-time into Oracle Database@Azure and is integrated with Microsoft Entra ID for seamless user access and management.

Oracle Database@Azure

Oracle Database@Azure integrates Oracle Autonomous Database Serverless, Oracle Exadata Database Service on Dedicated Infrastructure, Oracle Real Application Clusters (Oracle RAC), and Oracle Data Guard technologies into the Azure platform. Oracle Database@Azure offers the same low latency as other Azure native services and meets mission-critical workloads and cloud-native development needs. Users manage the service on the Azure console and with Azure automation tools. The services are deployed in Azure Virtual Network (VNet) and integrated with the Azure identity and access management system. The OCI and Oracle Database metrics and audit logs are natively available in Azure.

Oracle Exadata Database Service delivers proven Oracle Database capabilities on purpose-built, optimized Oracle Exadata Infrastructure in the public cloud. Built-in cloud automation, elastic resource scaling, security, and fast performance for OLTP, in-memory analytics, and converged Oracle Database workloads help simplify management and reduce costs.

Oracle Autonomous Database Serverless is also available with Oracle Database@Azure as the world’s first autonomous data management, fully managed in the cloud, to deliver automated patching, upgrades, and tuning, without human intervention. Autonomous Database is built on Oracle Exadata infrastructure, is self-managing, self-securing, and self-repairing, helping eliminate manual database management and human errors. Autonomous Database enables development of scalable AI-powered apps with any data using built-in AI capabilities using your choice of large language model (LLM) and deployment location.

Both Exadata Database Service and Autonomous Database are easily provisioned via the native Azure Portal and open up access to the broader Azure ecosystem.

Using GoldenGate with Database@Azure provides new ways for customers in any industry to create more value from their data in real-time. In this technical article, we will review several real-time data movement use cases that help organizations gain valuable insights to optimize their operations, better understand their customers, and be more competitive.

Ensure Business Continuity with Real-time Data Synchronization Across Hybrid Environments

In a data-driven environment, it is critical for customers embracing hybrid environments to keep their database footprint in sync across on-premises and Azure. GoldenGate is the most complete, highest-performing database replication solution and ensures database transactions are replicated in real-time between your databases wherever they are located.

Customers who have Oracle Database on-premises and have chosen an Azure first strategy to run other workloads need to synchronize data between the two. These workloads may need to reside on-premises or at some point will migrate to Oracle Database services in Oracle Database@Azure.

Thanks to its robust architecture, these customers can leverage OCI GoldenGate’s resilience, guaranteeing no data or transactions will ever be lost. In addition, GoldenGate provides bi-directional replication capabilities with automatic conflict detection resolution to ensure your databases always contain the latest data. These capabilities are seamlessly integrated with both on-premises and Azure components, providing a robust solution for maintaining data integrity and keeping the data up-to-date and relevant to derive accurate insights.

With GoldenGate, customers can turn data into a strategic advantage, safeguarding users from accessing stale and outdated data to make informed decisions using accurate and recent information, regardless of where it resides.

Create a Modern Data Platform using Oracle Database@Azure and Azure Services

Moving data from Oracle Database@Azure into your data lake or data lakehouse infrastructure is critical for processing machine learning (ML) and Analytics workloads.

GoldenGate is an ideal solution for managing and processing machine learning and analytics workloads. Its core strengths lie in its ability to handle high-volume data streams, replicate data in near real-time, and support data ingestion from the most popular technologies into key Azure services such as Azure Synapse Analytics, Azure Databricks, or Azure Data Lake Storage. Using its market-leading Change Data Capture (CDC) capabilities, OCI GoldenGate delivers data in real-time into your Raw or Bronze Zone for further processing. GoldenGate uniquely integrates with Oracle Databases, and no other solution provides better CDC support for your Oracle Database@Azure deployments.

Through its robust functionality, GoldenGate empowers organizations to optimize their data management processes and facilitates the seamless integration of data stored in Oracle Database@Azure into data lakes and lakehouses for advanced analytics and machine learning workloads.

Integrate Oracle Database@Azure with Your rReal-time Data Streaming Platform on Azure

Connecting data stored in Oracle Database@Azure with your real-time data streaming platform is easier than ever, thanks to OCI GoldenGate’s native support for Azure Event Hubs, Confluent Cloud, or Apache Kafka running on Azure.

OCI GoldenGate streams changed data events from 100s of data sources, including Oracle Database@Azure, into your Azure data streaming platform. It provides data pipelines access to the latest data using non-intrusive, highly efficient CDC functionality across various databases, data warehouses, and cloud platforms. This flexibility allows organizations to leverage their existing investments in data infrastructure while extending their capabilities for real-time data processing and analysis.

By leveraging GoldenGate’s capabilities, you can build robust data streaming platforms on Azure, ensuring seamless data integration, scalability, and real-time analytics. GoldenGate provides data consistency and synchronization to make it an invaluable technology for organizations striving to leverage real-time data to make informed decisions based on accurate and timely data, driving the success of your business in the cloud-native era and enhancing business operations.

Conclusion

Oracle Database@Azure integrates Autonomous Database Serverless and Exadata Database Service into the Azure data centers, providing close proximity with low latency connectivity to your Azure applications. These Oracle database services provide the ability to choose complete database automation and the highest available, and most secure platform for deploying Oracle databases. Azure users can simplify the development of innovative applications with the Oracle Database converged architecture, but can also benefit from the fully managed Autonomous Database, experience the performance of the Exadata platform, and achieve high availability with Oracle Real Application Clusters (RAC).

Oracle Database@Azure customer commercial benefits include using Azure commitments (MACC) for procuring Exadata Database Service and Autonomous Database Service, OCI Object Storage and OCI Networking Data Transfer fees (with up to the first 10TB for free per month). You can leverage existing Oracle licences as BYOL as well as licence included, a collaborative support model, support rewards and procurement in Microsoft Azure Marketplace, presented as a unified bill.

In today’s digital landscape, ensuring business continuity and enabling real-time data synchronization across hybrid environments is paramount to staying competitive and creating new revenue streams. Oracle GoldenGate empowers you to establish a powerful, affordable, modern data platform and achieve true business continuity. OCI GoldenGate synchronizes data to achieve insights in real-time, resulting in more informed business decisions across hybrid environments, leveraging the capabilities of Oracle databases in Oracle Database@Azure and Azure applications. By replicating and integrating data seamlessly, you can ensure consistency, integrity, and availability of your data throughout your entire ecosystem.

For more information

• Oracle Database@Azure
• Oracle Database@Azure documentation
• OCI GoldenGate with Entra ID for integration with Oracle Database@Azure
• OCI GoldenGate
• Become an Oracle Database@Azure Specialist
• Oracle Database@Azure is Gold Maximum Availability Architecture endorsed
• Oracle Zero Downtime Migration for Oracle Database@Azure Migrations