Data Warehouse Solutions for the Pivotal Big Data Suite

Attunity Replicate is a “Click-2-Load” solution engineered from the ground up to load data for Big Data analytics fast and with high-performance throughput. This software supports the Pivotal Big Data Suite including the Greenplum Database, Pivotal HD and Pivotal HAWQ.

The solution empowers Pivotal customers to quickly load data from heterogeneous data sources including Oracle, SQL Server, and IBM DB2, and then maintain the changed data continuously and efficiently. Attunity Replicate does this with change data capture (CDC)  technology, streaming changes captured from the source databases to the Pivotal Big Data Suite with very low impact on the source. This complete solution enables initiatives including BI and analytics, operational reporting, data distribution and more.

Attunity Replicate supports:

  • High-performance loads and continuous data capture
  • The Click-2-Replicate graphical user interface for designing and monitoring replication tasks
  • A wide range of data sources including mainstream relational databases and legacy systems
  • Automatic schema generation and implementation of metadata changes for the Pivotal Big Data Suite
  • Transparent data type transformations between a source and the Pivotal Big Data Suite 

 

attunity-replicate-for-greenplum.png

 

Attunity Replicate’s server architecture is tightly integrated with the Pivotal high-performance interface in order to leverage its Scatter/Gather Streaming technology for optimized fast, parallel data loading. This integrated approach ensures that all of the segments in the systems are fully utilized when loading data to provide optimal, streamlined performance.

Designed to meet reliability and high-performance requirements of the most mission-critical enterprises, the Attunity Replicate Server can also be configured directly on the Pivotal Greenplum Data Integration Accelerator (DIA). This architecture is specially built to facilitate fast data loading to the Pivotal Greenplum Data Computing Appliance (DCA), which benefits from being on DCA’s shared interconnect for high-speed data access.

  • Full Load:  With Attunity Replicate, Pivotal customers can quickly and efficiently load data from heterogeneous data sources and leverage full schema and DDL replication. 
  • Incremental Load via Change Data Capture (CDC):  Attunity Replicate streams changes captured from the source databases to the data warehouse with minimal impact on source systems.

The following screenshot captures full load progress from Oracle to Greenplum databases on the Attunity Replicate dashboard. Using this dashboard you can monitor % completion, load speed, track errors and more.

Replicate-to-greenplum-full-load-screenshot.jpg


Attunity Replicate for Hadoop

Attunity Replicate for Hadoop is certified with Pivotal HAWQ. The software delivers automated and high-performance solutions that move Big Data in and out of Hadoop for analytics. Attunity Replicate provides optimized connectivity to data stored in most enterprise data sources, enabling high-speed data offload and change data capture (CDC). The collected data is automatically loaded into Hadoop where it is made available for any Hadoop application to work on. This helps drive new insights and competitive advantages.