Data Warehouse Migration to Amazon Redshift

Trust ABCloudZ for fast and secure migration of your Netezza, Teradata, Vertica or Greenplum data warehouse to Amazon Redshift.

Typical challenges that we see

Data Warehouse migration to AWS is a daunting task with a lot of hidden issues and possible problems. With our extensive experience, we can overcome all of the challenges migration projects have to offer.



Mapping the table index strategy of the source data warehouse to Amazon Redshift

Amazon Redshift does not use indexes for optimizing query performance.

Amazon Redshift is different from other data warehouse solutions in that there is no CREATE INDEX command. Instead, Amazon Redshift uses features like Sort and Distribution Keys to optimize query performance.

We use the features in Amazon’s Database Migration Service with the Schema Conversion Tool (SCT) to optimize the Sort and Distribution Keys. SCT uses the table statistics to come up with different options to choose from. In most cases, you can pick the recommendation suggested by the SCT tool.

If you do happen to make a mistake a query performance becomes an issue, SCT uses the table statistics to suggest updates and recreates the table to take advantage of the new setting.

How can I migrate terabytes of data to the Amazon cloud?

Imagine you have an 80 TB database that needs to be extracted and imported into Amazon Redshift or Aurora database. Normally, it would take up to several weeks for extracting and migrating such databases over the internet. ABCloudZ Solution Architects have proven experience with leveraging a Snowball Edge device for transferring huge datasets to the AWS cloud. You can hookup a Snowball Edge device to your on-premises database, extract data and upload data to the Snowball Edge and send it back to Amazon for completing the data import process during your data warehouse migration to AWS.

Getting started

At ABCloudZ, we have a set of entry-level offers to help you understand your modernization landscape. We also can demonstrate you the value of moving Netezza, Teradata, Vertica or Greenplum data warehouses to Amazon Redshift.

We can help you choose the best option for migrating data warehouses to AWS, as well as modifying the architecture of your entire system by adding the latest business intelligence and advanced analytics solutions.

General approach to migration of data warehouses to Amazon Redshift

The following video provides an overview on how to migrate your Oracle, Teradata, Greenplum and Netezza data warehouses to Amazon Redshift using the AWS Schema Conversion Tool. The video also covers how AWS SCT provides guidance on creating the appropriate sort and distribution keys for you based on query statistics and runtime query statistics from the source database.

Data integration support

Like most organizations running with an existing enterprise data warehouse solution, you have a substantial investment in data integration software for extract-transform-load (ETL) processes.

We have you covered when it comes time to migrate these packages to Amazon Redshift. Here is an example of the key data integration platforms.