ETL and data integration projects focus on moving data from source to target systems in order to maintain data integrity, synchronize data sources, and build integrated data stores such as data warehouses (DW) in support of business intelligence (BI) applications.
Traditionally, this type of data integration has been done in a batch manner, processing entire tables from operational databases. Nowadays however, the demand is for increasingly up-to-date and often real-time information for better business decision-making. This presents IT teams with the dual challenge of architecting data integration solutions that deliver data on time, while maintaining efficient use of resources. These challenges are further intensified by:
- Low latency requirements – going from daily transfers to near real-time updates
- Increasingly large data volumes
- Shrinking batch windows for moving and processing information
- Complexity of infrastructure (Legacy, non-relational data sources) often due to corporate mergers/consolidation
Attunity provides a solution for these challenges by extending the capabilities of common ETL tools and homegrown programs to enable real-time and efficient integration. Based on innovative change data capture (CDC) technology, Attunity Stream dramatically reduces the amount of data that needs to be processed and delivers only data changes in real-time.
Providing the most comprehensive suite of CDC support in the industry, the Attunity solution is standard based, leveraging known skill sets and supporting any ETL or data integration product. This allows organizations to reduce the cost of real-time integration and leverage the investments made in purchasing or building data integration solutions.
In addition, Attunity Connect facilitates the integration with legacy, non-relational data sources by providing a suite of data connectors that make such data sources seamlessly accessible to ETL tools using standard SQL queries.
Learn more: