Skip links

Category: GoldenGate

Securing Oracle GoldenGate to Snowflake: Why Key Pairs Matter (Or: How Not To Leave Your Data Pipeline Wide Open)

Securing Oracle GoldenGate to Snowflake: Why Key Pairs Matter (Or: How Not To Leave Your Data Pipeline Wide Open)

in Tags

assword-based authentication for Oracle GoldenGate to Snowflake connections creates unnecessary security vulnerabilities. This guide explains why key pair authentication provides superior security for your data replication pipeline and how to implement it correctly to eliminate password-related risks in your enterprise data infrastructure.

Oracle GoldenGate Response Files: Understanding the Evolution from 12c to 23ai

Oracle GoldenGate Response Files: Understanding the Evolution from 12c to 23ai

in Tags

Your Oracle GoldenGate 21c response file won’t work for 23ai deployments—and that’s by design. Oracle fundamentally restructured GoldenGate configuration with 23ai, introducing deployment-level administrator separation, granular directory control, Configuration Service options, and enhanced security with TLS 1.3 support. This detailed comparison reveals the critical differences between response file schemas, explains why backward compatibility breaks, and provides practical migration strategies for maintaining automation across GoldenGate versions from 12c through 23ai. Learn how to leverage new capabilities like remote metrics and centralized configuration management while keeping your existing deployments running smoothly.

Oracle AI World 2025: How RheoData Helps You Accelerate AI with Your Enterprise Data

Oracle AI World 2025: How RheoData Helps You Accelerate AI with Your Enterprise Data

in Tags

Oracle AI World 2025 unveiled game-changing innovations in Oracle Database 26ai and GoldenGate that make enterprise AI initiatives faster and more practical. Learn how RheoData helps organizations leverage these technologies to transform their data into AI-ready strategic advantages with real-time integration and expert guidance.

Transforming Oracle GoldenGate Operations with AI: Building MCP Servers for Real-World Impact

Transforming Oracle GoldenGate Operations with AI: Building MCP Servers for Real-World Impact

in Tags

Remember when everyone said the cloud was just a fad? We’re hearing similar skepticism about AI in enterprise data management today. But here’s what I’ve learned after thirty years in technology leadership: the organizations that dismiss transformative technologies early often spend the most catching up

Seamless Database Access: Connecting to Oracle Database 23ai on Oracle@GCP Using VS Code

Seamless Database Access: Connecting to Oracle Database 23ai on Oracle@GCP Using VS Code

in Tags

Transform Your Database Development Experience in Minutes If you’re managing Oracle databases, you understand the importance of quick, secure connections to your cloud infrastructure. Today, we’re demonstrating just how straightforward it is to connect to Oracle Database 23ai running on Oracle@GCP using Microsoft VS Code

When Your Oracle LOBs Won’t Play Nice with Snowflake: A Real-World Solution

When Your Oracle LOBs Won’t Play Nice with Snowflake: A Real-World Solution

in Tags

This week, I found myself deep in a familiar challenge – helping a client navigate the complexities of replicating Oracle Large Objects (LOBs) to Snowflake using Oracle GoldenGate. What started as a seemingly straightforward data integration project quickly revealed the nuanced technical considerations that separate

Oracle GoldenGate to Google BigQuery: Accelerating AI-Driven Business Outcomes

Oracle GoldenGate to Google BigQuery: Accelerating AI-Driven Business Outcomes

in Tags

Your organization sits on valuable data trapped in operational silos, while competitors leverage real-time insights to capture market opportunities. Traditional batch ETL processes create 24-hour data delays that render AI models reactive rather than predictive, causing missed revenue opportunities and increased operational risk. The Solution:

Real-Time Oracle Database to Google BigQuery: Powering AI-Driven Analytics with Oracle GoldenGate 23ai

Real-Time Oracle Database to Google BigQuery: Powering AI-Driven Analytics with Oracle GoldenGate 23ai

in Tags

Modern AI and machine learning initiatives demand fresh data to deliver accurate predictions and actionable insights. While traditional batch ETL processes served us well in the past, today’s AI models require continuous data streams to maintain relevance and accuracy. The retail and supply chain industries

Oracle GoldenGate 23ai Performance Tuning: Achieving 10M Rows/Hour on X-Small Snowflake Warehouses

Oracle GoldenGate 23ai Performance Tuning: Achieving 10M Rows/Hour on X-Small Snowflake Warehouses

in Tags

Your Snowflake bills are probably 3x higher than they need to be. We  wrapped up an implementation where we slashed compute costs by 70% while improving replication performance by 67%. The secret? Properly configured Oracle GoldenGate 23ai performance settings specifically tuned for X-Small Snowflake warehouses.

Why GitHub + Local Backup Saves Careers: The Oracle GoldenGate Reality Check

Why GitHub + Local Backup Saves Careers: The Oracle GoldenGate Reality Check

in Tags

I’ve seen three DBAs lose their jobs over Oracle GoldenGate configuration losses in the past two years. Not performance issues. Not design flaws. Simple backup failures. The 3 AM Call That Changes Everything Picture this: Your phone rings at 3 AM. Production replicat REPPROD01 is

Securing Your Oracle GoldenGate to Snowflake Replication: Why Key Pair Authentication Matters More Than You Think

Securing Your Oracle GoldenGate to Snowflake Replication: Why Key Pair Authentication Matters More Than You Think

in Tags

When your business operations depend on real-time data flowing from Oracle to Snowflake, the last thing you want is a security breach that shuts down critical processes for days—or worse, exposes sensitive operational data to competitors. Yet many organizations still rely on password-based authentication for

Oracle to Snowflake: Your Complete Guide to Real-Time Data Integration with Oracle GoldenGate

Oracle to Snowflake: Your Complete Guide to Real-Time Data Integration with Oracle GoldenGate

in Tags

“Our Oracle databases are drowning in decades of business data, and our analysts are spending more time waiting for reports than analyzing them. We need to get this data into Snowflake for real-time analytics, but we can’t afford any disruption to our production systems.” Sound

Why Your Oracle Data is Trapped (And How Oracle GoldenGate 23ai Frees It for Game-Changing Snowflake Analytics)

Why Your Oracle Data is Trapped (And How Oracle GoldenGate 23ai Frees It for Game-Changing Snowflake Analytics)

in Tags

The $73 Million Question Every Executive is Asking: “Why Isn’t Our Snowflake Investment Paying Off?” Look, I’m going to tell you something that’ll change how you think about analytics. Your competitors aren’t beating you because they have better data. They’re beating you because their Oracle

AI Benefits Using Oracle GoldenGate to Replicate Vectors

AI Benefits Using Oracle GoldenGate to Replicate Vectors

in Tags

Introduction This document outlines the benefits of leveraging Oracle GoldenGate for replicating vectors to enhance AI applications. Oracle GoldenGate provides real-time data replication, enabling AI models to access the most current and relevant information. This capability is crucial for applications requiring up-to-date insights, such as