GETTING THE MOST OUT OF AMAZON REDSHIFT

If you are looking to move your Enterprise Data Warehouse to the cloud, Amazon Redshift provides an excellent scalable platform. We are ready to help you migrate your current aging on-premises data warehouse workloads from the following platforms:

  • Oracle Data Warehouse (Exadata)
  • SAP IQ (formally Sybase)
  • Teradata
  • IBM PureData System for Analytics (formerly Netezza)
  • Pivotal Greenplum
  • Micro Focus Vertica

Here are some of the technologies we can use to help you with your Amazon Redshift solutions.

Getting Started with Amazon Redshift

Here are some introductory services to help get you started on migrating to Amazon Redshift, or to optimize your current solutions. Our special support program for Amazon Redshift provides database performance tuning, helping with data migration, and other valuable forms of assistance.

Optimizing Redshift Performance with AWS SCT

Amazon introduced a feature called Redshift Optimization for the Schema Conversion Tool (SCT). You can now use AWS SCT to optimize your Redshift databases. For more information, see Optimizing Amazon Redshift by using the AWS Schema Conversion Tool.

Based on the experience of our Data Management Team, we came to the conclusion that if the performance of Redshift clusters is satisfying, using SCT’s recommendations will be sufficient for most customers.

However, if cloud storage performance does not meet your requirements or expectations, you may launch the optimization of the Redshift data storage.

 

As a part of the Redshift optimization project, AWS SCT provides recommendations based on the selection of Distribution Keys and Style, as well as the best choice for the Sort Keys.

Essentially, the Redshift optimization project can be considered a regular AWS Schema Conversion Tool migration project with the source and target pointing to Redshift clusters. Here you have to make an important decision: whether to use a copy of the source cluster as a target or start the optimization project from scratch.

In the following video, we will demonstrate the essentials of using the Redshift Optimization to improve the query performance.

Let's get together to talk about Amazon Data Warehouse Solutions
Contact us today

Featured services

Here are several services that we offer related to supporting your Amazon Redshift solutions.

Contact us today to help you with Amazon Data Warehouse Solutions
Contact us

Learn More

Blog posts

We have some great blog posts to highlight our experiences with migrating on-premises data warehouses to Amazon Redshift, optimizing query performance, using the Schema Conversion Tool, and more.

AWS Schema Conversion Tool: General Approach to Migration of Data Warehouses to Amazon Redshift
6 December 2016 Bill Ramos

This post continues our video blog series on the AWS Schema Conversion Tool (SCT). In our previous blog posts, we talked about using AWS SCT for transactional database migration projec...

AWS Schema Conversion Tool: Specific Features of Migrating Data Warehouses to Redshift
14 December 2016 Bill Ramos

This continues our video blog series on the AWS Schema Conversion Tool (SCT). In the previous blog post we’ve talked about the general approach of data warehouses migration to Amazon...

Using Amazon Redshift performance tuning tips to reduce query times by 800%
14 December 2017 Bill Ramos

Often database administrators experience decreases in query performance with Amazon Redshift as the size of data increases. The problem becomes even more significant when we start talk...

Extracting Data from Warehouses with Data Migration Agents in AWS Schema Conversion Tool
15 March 2017 Bill Ramos

Migrating data warehouses to Amazon Redshift represents a serious challenges when you consider what it takes to transfer huge amounts of data in parallel. On February 16, 2017, Amazon ...

Optimizing your Redshift Storage with AWS Schema Conversion Tool
2 March 2017 Bill Ramos

Amazon introduced the new feature called Redshift Optimization for the Schema Conversion Tool (SCT) November 17, 2016 release. You can now use AWS SCT to optimize your Amazon Redshift ...

Database Compare Suite 4.5 Released — Amazon Redshift and SQL Server 2000 support
12 October 2016 Bill Ramos

We are proud to announce the latest version of the Database Compare Suite tool, which now adds support for Amazon Redshift and SQL Server 2000. For customers looking to upgrade their S...

Introducing Fast Data Comparison in Database Compare Suite version 4.6
27 January 2017 Bill Ramos

Many of us regularly use Database Compare Suite — a tool developed by DB Best — for database migration and upgrade projects. This powerful and handy software solution helps confirm...

Using data extraction filters for smart database migration with AWS Schema Conversion Tool
29 June 2017 Andrey Ivanov

Amazon introduced the data extraction agents in the previous release of AWS Schema Conversion Tool (SCT). They allowed for migrating all the data from your on-premises data warehouse p...

Loading Amazon Redshift Data Utilizing AWS Glue ETL service
27 December 2017 Bill Ramos

Your CIO made a strategic decision to move to AWS and you are wondering how to move your Enterprise Data Warehouse (EDW) on Teradata: should you opt for using Teradata Software Tiers ...

Using AWS Snowball Edge to transfer multiple terabytes of data into the Amazon cloud
10 January 2018 admin

One of the main concerns during large-scale database migrations to the cloud is how long will the data transfer last. When you need to move multiple terabytes of data, the migration pr...

Reference data sheet

Amazon Web Services Migration
17 November 2016 Bill Ramos

DB Best Technologies is internationally known for comprehensive Data Management Services, database development and migration, and the creation of highly successful web and mobile syste...

BI and AA Offering for AWS
8 November 2016 Bill Ramos

In combination with Amazon RDS, Amazon Redshift, Amazon Kinesis and Amazon EMR, DB Best has helped dozens of customers deliver Business Intelligence solutions across their entire organ...

Data Management for Amazon Web Services
8 November 2016 Bill Ramos

DB Best Technologies is internationally known for comprehensive Data Management Services, database development and migration, and the creation of highly successful web and mobile syste...

Modernize Your Data Warehouse with Amazon Redshift
16 January 2019 Bill Ramos

Is your data warehouse still on-premises and you're thinking of shifting to the Amazon cloud? Go with the team of engineers and developers that have helped shift countless customers to...

Let us help you with your project!
Contact us for a FREE quote today.
Request a quote