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

HashmapLogoBlack_edited.png
  • Hashmap on LinkedIn
  • Tweet Hashmap
  • Hashmap on Facebook
  • Hashmap Stories
  • Data Rebels on Tap on Spotify
  • Hashmap on YouTube
  • Hashmap on Instagram

© 2020 by Hashmap, Inc.