Data Warehouse Solutions for HP Vertica

Attunity Replicate is a complete solution engineered from the ground up to load data for Big Data Analytics fast and with high-performance throughput. Enabling operational data stores (ODS) or data warehouses for Vertica’s environments by providing high-performance, end-to-end data loading with quick time-to-value, Attunity Replicate empowers HP customers to quickly load data from heterogeneous data sources and then maintain the changed data continuously and efficiently. Attunity Replicate effectively facilitates the movement of incremental changes via Attunity TurboStream CDC, a log-based change data capture (CDC) technology, which streams high volumes of transactional changes captured from the source databases to the data warehouse with very low impact on the source.

Fast loading & throughput, drag-and-drop setup, end-to-end automation

Attunity Replicate enables fast and easy loading to HP Vertica with minimal IT resources and no development staff. The software will load the data, and complex transformations can then be added using scripts or downstream transformations in the data warehouse. This approach eliminates the need for development during data loading by automating the entire process, and developers can be leveraged effectively only when needed to support lower total cost of ownership for the entire project.

 

 

Attunity Replicate leverages the native SQL COPY utility of HP Vertica ensuring that data is loaded into HP Vertica as fast as possible. This integrated approach is designed to move large volumes of data into tables in the HP Vertica database. Attunity Replicate fully supports this high performance loading option. By leveraging HP Vertica’s native utilities, Attunity’s software executes automatic parallel data allocation, transformation and movement to achieve optimal data loading performance levels.