Attunity Pushes Data into Amazon Redshift

March 12, 2013 Alex Woodie

The partnership between Amazon and Attunity reached a new level last month when Attunity announced that its Databeam data integration service can now pump data into RedShift, the new cloud-based data warehouse Amazon recently made available.

RedShift is a big data analysis service first unveiled by Amazon Web Services (AWS) last November, and released to wider availability in February. The offering gives customers access to database hosting services that are cheap and readily available. For example, a user will pay about $1,000 per year to host 1 TB of data in RedShift–much less than it would cost to provision and manage an on-premise big data solution. And RedShift database will scale to more than a 1 petabyte (PB), Amazon says.

Attunity will help customers load data into their RedShift environments with CloudBeam. First unveiled last July, CloudBeam combines software as a service (SaaS) that lives on the AWS cloud and Replicate, its on-premise data replication technology that supports on-premise databases, such as DB2 for i, DB2 for LUW, SQL Server, and Oracle. CloudBeam enables customers to upload data from on-premise database to Amazon Simple Storage Service (S3) up to 100 times faster than they could previously do with existing AWS utilities, the company claims.

With a few tweaks, Attunity adapted DataBeam to move data into RedShift. Like the original version of DataBeam, the newer RedShift version will support change data capture (CDC) capabilities to push deltas from on-premise databases into the RedShift big data warehouse. It will also support graphical creation of integration tasks, encryption, and performance dashboards.

“Attunity’s solution is being uniquely architected for high-speed data loading from enterprise databases to Amazon Redshift, designed to alleviate the data transfer bottleneck, and accelerate time to value,” states Attunity’s vice president of business development and corporate strategy Itamar Ankorion in a press release.

A preview version of CloudBeam for RedShift will become available this month. For more info, see www.attunity.com.