Enterprises are increasingly drawn to cloud-based data warehousing services, with Amazon Redshift leading the growing market. While cloud data warehousing saves time and money compared to traditional on-premises data warehousing, users of services like Amazon Redshift often face challenges around cloud ETL. Cloud ETL entails extracting data from diverse source systems, transforming it to a common format, and loading the consolidated data into the data warehouse platform to best serve the needs of enterprise business intelligence, reporting and analytics. Fortunately, there are solutions from Attunity that simplify and automate the cloud ETL process, bringing the benefits of cloud data warehousing within reach of any organization large or small.

Attunity Compose: Cloud ETL as Part of DWH Automation

Available through the Amazon Web Services Marketplace, Attunity Compose is an innovative data warehouse automation solution that empowers data architects and data warehouse administrators to design and implement data warehouses and data marts without doing any manual coding. Bundled with Attunity Compose for Amazon Redshift, Attunity Cloudbeam makes it easy to configure and execute data migrations from nearly any type of source system into the staging area of a cloud data warehouse – again with no manual coding. Seamlessly integrated and remarkably easy to use, Attunity Compose and Attunity Cloudbeam accelerate and automate all aspects of cloud ETL for cloud data warehousing.

With Attunity Compose for Amazon Redshift you can create custom data warehouse designs through an intuitive design studio, or simply import a design such as Data Vault, Inmon, and Kimball. Attunity Compose then automatically generates the Amazon Redshift ETL code needed to transform data in your warehouse staging area to meet the requirements of your warehouse design pattern. With a click, you can create the warehouse structures and execute Redshift ETL tasks, monitoring the cloud ETL progress through a central console.

Cloud ETL is just as easy for data marts as it is for the data warehouse: Simply configure your fact and dimension tables by using the Attunity Compose star schema wizard, and Attunity Compose then automatically generates the cloud ETL command set that's needed to correctly populate the data mart.

Attunity Cloudbeam: Cloud ETL from Any Data Source

Attunity Cloudbeam -- the AWS marketplace name for Attunity Replicate -- is a universal solution for moving data from nearly any type of source system into your cloud data warehouse staging area, where it can then undergo the transformations specified in the cloud ETL code that's automatically generated by Attunity Compose. With no manual coding, data warehouse architects and administrators can use Attunity Cloudbeam to configure and execute data feeds from cloud sources such as Amazon RDS or databases running in Amazon EC2; or by using an on-premises instance of Attunity Replicate to access nearly any type of on-premises source system such as relational databases, legacy data warehouses, or mainframes. Attunity Cloudbeam and Attunity Replicate support high-performance bulk loading and incremental change data capture (CDC) to power your real-time data warehouse and deliver timely analytics.

Along with fast and easy feeding of an Amazon Redshift data warehouse, Attunity Replicate also supports cloud data transfer to other destination systems such Azure and Google Cloud, and even data warehouse Hadoop platforms such as AWS Elastic MapReduce – all through a single unified data integration solution.