OCI GoldenGate ZeroETL

We are excited to announce at Oracle CloudWorld that new ZeroETL capabilities will soon be introduced within Oracle GoldenGate 23ai on Oracle Cloud Infrastructure (OCI). OCI GoldenGate 23ai is a fully managed, real-time data integration and replication service, offering seamless data movement and manipulation across diverse environments.

What is ZeroETL?

ZeroETL is a data integration approach that eliminates the need for traditional, batch/bulk ETL (Extract, Load, Transform) pipelines. With ZeroETL, data is extracted from source systems and loaded directly into the target system, without requiring separate transformation steps. This streamlined approach enables faster and smarter data-driven insights, by significantly reducing the time and resources typically spent building complex data transformation and preparation processes. ZeroETL is particularly useful for operational-reporting, AI/ML, real-time data analytics, data warehousing, as well as migration projects, offering an exponentially more simplified and efficient way to manage and generate value from data.

OCI GoldenGate ZeroETL Mirror: Unlocking Real-Time Insights

With OCI GoldenGate ZeroETL Mirror, users can easily replicate data from any Oracle database, including on-premises and cloud databases, directly into OCI without the need for complex ETL processes or impact on source systems. This enables users to:

  • Stream data in real-time: Seamlessly replicate data changes as they occur, ensuring that your analytics, reporting, and decision-making are always based on the most current, trusted information. The data capture approach is unlike conventional ETL that competes with production resources.  With OCI GoldenGate ZeroETL, data is captured and moved from database log files, minimizing impact on source systems and allowing it to run continuously during production hours.
  • Simplify data integration: Eliminate the need for separate data transformation steps, reduce complexity, development time, and maintenance overhead.
  • Power data-driven decisions: Gain immediate access to actionable insights by loading data directly into your target databases, with transactional-integrity.
  • Leverage the cloud: Take advantage of the scalability, flexibility, and cost-effectiveness of the cloud, utilizing OCI services for secure and efficient data storage, processing, and analysis.
Figure 1 - Create a ZeroETL Mirror pipeline in OCI GoldenGate
Figure 1 – Create a ZeroETL Mirror pipeline in OCI GoldenGate

Easy, Powerful, and Affordable

OCI GoldenGate ZeroETL Mirror offers a host of benefits that make it a compelling choice for any organization looking to streamline their data integration processes:

  • Ease of use: With a simple and intuitive user interface, creating ZeroETL Mirror pipelines requires no coding expertise. Users can quickly set up data replication processes with just a few clicks, reducing the time and effort typically spent on complex ETL development.
  • Powerful functionality: OCI GoldenGate is powered by Oracle GoldenGate, the premier replication tool for Oracle databases, ensuring you can easily integrate data from various systems with advanced features like data filtering, mapping, and manipulation to provide precise control over your data. The first version of OCI GoldenGate ZeroETL Mirror supports Oracle databases running anywhere. Other source/target technologies will be supported in the future.
  • Affordable pricing: OCI GoldenGate ZeroETL Mirror is a cost-effective solution with a pay-as-you-go model and no upfront costs. You only pay for the resources you’ve used, making it accessible to organizations of all sizes.

Use Cases

The applications of OCI GoldenGate ZeroETL Mirror are vast, and it can drive value across all industries:

  • Real-time analytics: Replicate data from operational databases into a data warehouse on OCI, reducing the time and effort required for data preparation and transformation and enabling up-to-the-minute reporting and dashboards for data-driven decision-making.
  • Cloud migration: Seamlessly migrate data from on-premises databases to cloud databases on OCI, ensuring minimal downtime and smooth transition.
  • Application modernization: Integrate data from legacy systems with modern Autonomous databases on OCI, enabling digital transformation initiatives, while unlocking new possibilities.
Figure 2 - ZeroETL Mirror pipeline Mapping rules & Preview
Figure 2 – ZeroETL Mirror pipeline Mapping rules & Preview

Get Started with OCI GoldenGate ZeroETL Mirror

Unlock the power of real-time data integration and streamline your path to data-driven insights. To learn more about OCI GoldenGate ZeroETL Mirror, visit our website or contact your Oracle account team to discuss how we can help you harness the full potential of your data. With OCI GoldenGate ZeroETL Mirror, we are excited to offer a simplified, powerful, and affordable data integration solution, enabling organizations to leverage real-time data insights and drive innovation. Stay tuned for more updates and success stories as we continue to empower businesses with cutting-edge data integration capabilities!

Learn More