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.
Qlik, an Amazon partner, offers a radically simplified approach to AWS Redshift ETL in the context of a complete solution for data warehouse automation.
Qlik 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. Qlik Compose is conveniently available through the Amazon Marketplace, and can be launched through an Amazon Machine Instance (AMI) in the Amazon EC2 cloud.
With Qlik Compose you can:
Working seamlessly with Qlik Compose, Qlik 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. Qlik Compose integrates with Qlik Replicate (known on the AWS marketplace as Qlik 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, Qlik 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 Qlik 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.
Qlik Compose and Qlik Replicate support other major on-premises and cloud data warehouse platforms, including Teradata, Exadata, Sybase IQ, and Azure SQL Data Warehouse.