Load Oracle data to Google BigQuery in minutes.

Replicate your Oracle database to Google BigQuery to improve the performance of your SQL queries at scale and to generate custom real-time reports and dashboards. Combine your Oracle data with other data sources such as mobile and web user analytics to make it even more valuable.

How to connect Oracle to Google BigQuery

Simple. By leveraging the Alooma enterprise data pipeline, you can easily integrate, connect, and watch your Oracle data flow into Google BigQuery.

Integrate

Add Oracle as a data source.

Connect

Map Oracle data to Google BigQuery.

Watch

See Oracle data flow into Google BigQuery.

Loading Oracle Data to BigQuery

LogMiner Change Data Capture

Suitable for Real-time replication of Oracle to BigQuery. What is it The LogMiner is a chronological view of all SQL transactions on Oracle. How it works
  1. Dump an initial snapshot of the desired tables
  2. Continuously read INSERT, UPDATE & DELETE statements from the LogMiner, then load them into staging tables
  3. Consolidate the staging tables into exact copies of the source tables
  4. Detect schema changes and adjust staging and destination tables
Pros and cons There are several attractive benefits to this method. It’s fast and is able to capture DELETES, INSERTS & UPDATES plus requires less querying overhead. The downside is that it requires retaining archive logs, which consumes more disk space. Pro Tip Allocate enough memory for the LogMiner to work efficiently.

Incremental Replication

Suitable for Real-time replication of Oracle to Bigquery. What is it ODBC connector that continuously queries for changes and replicates them to BigQuery. How it works
  1. Specify a list of tables to replicate
  2. For each table, specify the UPDATE indicator column which can be a Timestamp column indicating a change was committed for a row
  3. Alooma’s integration will continuously query each table for INSERTED or UPDATED records
  4. All changes to all tables will be loaded to corresponding staging tables
  5. Every staging table will be consolidated into an exact replica of the source table
Pros and cons The advantage of this method, is that less setup time is required. However DELETES can’t be migrated.

Oracle to BigQuery - Should you do it yourself or use a third party solution?

DON’T TRY THIS YOURSELF! It’s very complicated. But if you must, use Oracle SQL*Plus to dump tables to CSV files and load them to your data warehouse.

Calculate how much it would cost to build your own data pipeline in-house here.

Export your Oracle data along with all of
your other data sources to Google BigQuery.

Extract, transform and load your Oracle data to your data warehouse using Alooma's stream-based data pipeline as a service (ETL). Replicate your Oracle database to your data warehouse to improve the performance of your SQL queries at scale and to generate custom real-time reports and dashboards. Combine your Oracle data with other data sources such as mobile and web user analytics to make it even more valuable.

Oracle
Oracle

Oracle database is an object-relational database management system produced and marketed by Oracle Corporation.

Google BigQuery
Google BigQuery

Google BigQuery is a powerful Big Data analytics platform that enables super-fast SQL queries against append-only tables using the processing power of Google's infrastructure.

Ready to move Oracle data to your warehouse?

Leave your contact details and one of our data experts will contact you.