Blog Post

Oracle on Azure Blog
3 MIN READ

Unlock Analytics and AI for Oracle Database@Azure with Microsoft Fabric and OCI GoldenGate

SparshAgrawat's avatar
SparshAgrawat
Icon for Microsoft rankMicrosoft
Sep 09, 2024

The strategic partnership between Oracle and Microsoft has redefined the enterprise cloud landscape. Oracle Database@Azure seamlessly integrates Oracle’s database services with Microsoft’s Azure cloud platform, empowering businesses to maintain the performance, security, and reliability of Oracle databases while modernizing with Azure’s extensive cloud services.

 

As companies strive to accelerate their digital transformation, reduce complexity, and optimize their cloud strategies, data remains central to their success. High-quality data underpins effective business insights and serves as the foundation for AI innovation. Now in public preview, customers have the opportunity to use OCI GoldenGate—a database replication and heterogeneous data integration service—to sync their data estates with Microsoft Fabric. This integration unlocks new prospects for data analytics and AI applications by unifying diverse datasets, allowing teams to identify patterns and visualize opportunities.

 

 

A Unified Platform for Data and AI

Microsoft Fabric is an AI-powered real-time analytics and business intelligence platform that consolidates data engineering, integration, warehousing, and data science into one unified solution. By simplifying the complexity and cost of integrating analytics services, Microsoft Fabric provides a seamless experience for data professionals across various roles.

Microsoft Fabric integrates tools like Azure Synapse Analytics and Azure Data Factory into a cohesive Software as a Service (SaaS) platform, featuring seven core workloads tailored to specific tasks and personas. This platform enables organizations to manage their entire data lifecycle within a single solution, streamlining the process of building, managing, and deploying data-driven applications. With its unified architecture, Microsoft Fabric reduces the complexity of managing a data estate and simplifies billing by offering a shared pool of capacity and storage across all workloads. It also enhances data management and protection with robust governance and security features.

 

A key highlight of Microsoft Fabric is its integration with native generative AI services, such as Copilot, which enables richer insights and more compelling visualizations. This AI-driven approach can significantly impact business growth by improving decision-making and collaboration across teams. With Power BI and Synapse workloads built in and native integration with Azure Machine Learning, you can accelerate the deployment of AI-powered solutions, making it an essential tool for organizations looking to advance their data strategies.

 

OCI Golden Gate integration with Microsoft Fabric

OCI GoldenGate is a real-time data integration and replication solution that ensures high availability, disaster recovery, and transactional integrity across diverse environments. When integrated with Microsoft Fabric, OCI GoldenGate adds significant value by enabling seamless, real-time data synchronization between Oracle databases and the AI-powered analytics platform of Fabric. This ensures that data professionals can work with the most up-to-date information across their data ecosystem, enhancing the accuracy and timeliness of insights.

 

OCI GoldenGate’s ability to support complex data transformations and migrations allows organizations to leverage Microsoft Fabric’s advanced analytics and AI capabilities without disruption, driving faster, more informed decision-making and enabling businesses to unlock new levels of innovation.

 

Get started

Enhance your data strategy and drive more informed decision-making by leveraging your existing Microsoft and Oracle investments with Oracle Database@Azure by integrating it with Microsoft Fabric. Get started today through the Azure Marketplace!

 

Read the Oracle CloudWorld blog: https://aka.ms/OCWBlog24

Learn more about Microsoft Fabric at https://aka.ms/fabric

Learn more about Oracle Database@Azure: https://aka.ms/oracle   

Technical documentation: Overview - Oracle Database@Azure | Microsoft Learn 

To setup OCI GoldenGate, you can refer to the documentation here - Implement OCI GoldenGate on an Azure Linux VM - Azure Virtual Machines | Microsoft Learn

Get skilled: https://aka.ms/ODAA_Learn   

  

 

 

 

 

 

 

 

 

Updated Oct 22, 2024
Version 4.0
  • Junpei_Liang's avatar
    Junpei_Liang
    Copper Contributor

    Let's say we have OLTP oracle database deployed on OCI, and data warehouse on MS Fabric. How can we perform CDC on a Oracle Database table in Fabric Data Warehouse in real time? For example, any records in a customer order oracle table can be changed in any second, and we want to captures the changes (such, price, qty) in DW on MS Fabric. 

  • Junpei_Liang - Understand your scenario. For real time replication directly between OLTP DB on OCI and data warehouse / Lakehouse tables on MS Fabric - this is in the works, watch out for announcements at Microsoft Ignite. and reach out to us. Based on current capability you could use Golden Gate to capture the changes in real time and deliver them in Parquet format files to OneLake in MS Fabric. You could then use Fabric shortcuts to load to tables in Fabric Lakehouse and establish replication which is an involved approach. Please do respond back if you would like to learn more, have a detailed conversation.