AWS Redshift ETL

Businesses seeking cost-effective ways to launch or expand data analytics initiatives are increasingly turning to Amazon Web Service's Redshift platform for cloud data warehousing. Along with its resource elasticity, scalability and usage-based pricing model, a major appeal of AWS Redshift is the agility that its customers gain by not having to deploy or maintain on-premises data warehouse infrastructure.

But that agility can be compromised by the difficulties of AWS Redshift ETL. Specialized scripts are required to design a Redshift data warehouse, load data from on-premises sources, transform the data and then manage and update the data warehouse to meet the needs of data analytics. The development of AWS Redshift ETL scripts can be complex, time-consuming, and error-prone, and can slow the launch of a data analytics program or act as an impediment to needed updates to your data warehousing environment.

Attunity, an Amazon partner, offers a radically simplified approach to AWS Redshift ETL in the context of a complete solution for data warehouse automation.

Automate and Accelerate AWS Redshift ETL with Attunity Compose

Attunity Compose DWH automation software makes AWS Redshift data warehouse creation and AWS Redshift ETL faster and easier so you can fully capitalize on the agility benefits of cloud data warehousing. Attunity Compose is conveniently available through the Amazon Marketplace, and can be launched through an Amazon Machine Instance (AMI) in the Amazon EC2 cloud.

With Attunity Compose you can:

  • Create or import your data warehouse model using an intuitive design interface
  • Leverage design patterns that align with Vault, Inmon, or Kimball data warehousing approaches
  • Configure rules for data profiling and quality.
  • Automatically generate Amazon Redshift ETL code, greatly reducing the need for manual cloud ETL scripting
  • Easily update your warehouse model in response to changing business needs, with Compose automatically performing the corresponding Amazon Redshift ETL updates.

Migrate Data from Source Systems to AWS Redshift with Attunity Replicate

Working seamlessly with Attunity Compose, Attunity Replicate moves data from your source systems into the landing area of your AWS Redshift data warehouse, where it can then be subjected to your AWS Redshift ETL processes. Attunity Compose integrates with Attunity Replicate (known on the AWS marketplace as Attunity CloudBeam) which you can use for ingesting data into Redshift from elsewhere in the AWS cloud – such as AWS SQL Server replication from either AWS RDS or AWS EC2. For AWS cloud data integration between your RDS or EC2 source database systems and your Redshift platform, Attunity Cloudbeam/Replicate supports high-performance bulk loading as well as real-time change data capture.

For migrating on-premises data to the Redshift cloud, you can download and run a local instance of Attunity Replicate. Through a graphical interface you can quickly and easily configure and execute any source-to-warehouse data flow—with no need for manual coding.

Attunity Compose and Attunity Replicate support other major on-premises and cloud data warehouse platforms, including Teradata, Exadata, Sybase IQ, and Azure SQL Data Warehouse.