Skip links

Category: Snowflake

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 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.

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