Amazon Redshift
Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. It uses SQL to analyze structured and semi-structured data across data warehouses, operational databases, and data lakes.
Like many other data warehouses, Redshift uses columnar storage to support analytic workloads efficiently. It is based on PostgreSQL and designed specifically for large-scale analytics and reporting.
Omni Loader is currently optimized for data ingestion from Redshift, while ingestion into Redshift is still in development.
Amazon Redshift data types we support
Export Amazon Redshift Database
It may make sense to migrate your data away from Amazon Redshift. You may want to do it permanently or just need to share your tables with a collague in a different format.
We will copy all your tables with their data and apply indexing and relationships exactly as they are in your current Amazon Redshift database. In a nutshell, you get exactly the same database in another database engine. Each time you run the migration, we will copy all the tables again. Of course, we have a built-in scheduler, so you can run this overnight and have a fresh database copy in the morning.
Take a look at the quick tutorials below to see how it's done.
Import data into Amazon Redshift Database
Additionally, if you want to import data on a regular basis and do not want to recreate the whole target database from scratch every time, but rather do tiny targeted sync of only changes since the last run, please use Full Convert Pro or Ultimate.
Take a look at the quick tutorials below to see how it's done.