Enterprise data warehousing involves creating a centralized repository of operational data to meet the organization's reporting and analytics needs. Designing, building, and operating an enterprise data warehouse is beset by two major operational challenges. The first challenge to enterprise data warehousing is a rapidly changing and competitive business environment that places ever greater emphasis on agility and speed. The second enterprise data warehousing challenge is growing data volumes that strain the limits of data warehouse manageability and cost management. Many businesses are finding that they can confidently meet both these challenges with technologies from Attunity, the leading maker of enterprise data integration and management software.
Attunity Compose is an enterprise data warehouse automation solution that helps data warehouse architects and operators meet today's "need for speed" in two different ways.
First, by automating the major technical processes of enterprise data warehousing, Attunity Compose sharply reduces dependence on manual programming and thereby boosts the speed to deploy and ability to rapidly change the data warehouse structure for new business requirements. Using the Attunity Compose graphical user interface, data architects and data warehouse administrators are empowered to design and create data warehouse and data mart structures and auto-generate ETL commands—without needing to do any manual coding. And with integrated data ingestion technology in Attunity Replicate, those same architects and administrators can configure and execute data replication flows from heterogeneous source systems into the data warehouse landing area, again without any manual coding or deep technical knowledge of the source or target interfaces. Together, Attunity Compose and Attunity Replicate work with a wide range of source systems (including relational databases, mainframes, and SAP applications) and with major on-premises and cloud-based enterprise data warehousing platforms (including native support for Amazon Redshift ETL).
Along with enabling an unprecedented degree of self-service by data architects and administrators, Attunity Compose also supports today's need for speed and agility by making it simple to maintain and operate a real-time data warehouse that continuously supplies business intelligence applications with fresh data. Attunity's innovative log-based change data capture (CDC) technology feeds up-to-the-moment operational data into your warehouse without diminishing the performance of the source systems.
Attunity Visibility enables warehouse architects and operators to more effectively manage the rising tide of enterprise data by delivering deep insight into how and by whom data is being used, as well which workloads are consuming compute resources. Along with supporting chargeback and showback, ROI measurement, and infrastructure capacity planning, the Attunity Visibility solution for enterprise data warehousing usage analytics helps to identify which data and which ETL workloads are prime for offloading to a low-cost Hadoop data lake. Attunity Replicate can then be used to set up and execute tiering processes, either on-schedule or on-demand.