HASHMAP SOLUTION PROFILE

GLOBAL OIL FIELD SERVICES

Migration and Performance Testing of Exadata to Snowflake in Azure

CHALLENGE

  • Achieve high performance for Oracle Exadata (source) table extraction and data transformation into a CSV file and ingestion into Snowflake Cloud Data Warehouse in Azure

  • Enable a migration from a traditional Oracle Exadata data warehouse environment to Snowflake Cloud Data Warehouse

OUTCOME

  • Significant performance gains for data migration from Exadata to Snowflake in Azure

  • A simple approach with a single step process to read from Exadata and migrate data to Snowflake in Azure using zero local disk space

  • Complete solution that accommodates all Exadata tables

APPROACH

  • Launch meeting to review issues and challenge for the project

  • Designed, implemented, and tested an extraction, transformation, and processing routine that demonstrated a 10x performance gain over the prior method

  • Benchmark testing extraction, compression, various tables, single thread, multiple threads, etc.

  • Complete documentation provided of the above

SOLUTION

  • Snowflake

  • Microsoft Azure

  • Hashmap Consulting Services: Cloud Data Migration, Data Engineering, Data Pipelining

Connect Now >