Agile Data Warehouse Automation
Challenge
Today’s data warehouse must meet fast-changing business requirements, support new data sources, and deliver solutions in quick iterations. Traditional ETL tools lack the agility, ease of use and level of automation needed to answer these requirements.
Solution
Data Warehouse Automation (DWA) is a modern approach to data warehousing. An evolution from traditional ETL, it provides automation and optimizations from designing the warehouse, to generating ETL code, to quickly applying updates, all leveraging best practices and proven design patterns.
Attunity® Compose for Data Warehouse is an innovative DWA software platform that streamlines this process end to end. It dramatically reduces the time, costs, and risks of data warehousing projects. Attunity Compose is also integrated with Attunity Replicate® to enable real-time data warehousing with continuous and incremental data acquisition from major enterprise data sources.
Attunity® Compose for Data Warehouse supports major enterprise data warehouses including Microsoft SQL Server, Teradata (on-premise and in the cloud), Oracle/Exadata, Amazon Redshift, Azure SQL DW and Snowflake.
Rapid data warehouse implementation
Attunity® Compose for Data Warehouse provides line of business (LOB) and IT teams with:
- Speed. Data warehouses and data marts can be built in days or weeks, dramatically faster than with traditional ETL tools.
- Design Automation. Data warehouse structures are quickly defined and deployed, based on proven design patterns such as Vault, Inmon, and Kimball.
- ETL Automation. Attunity Compose automatically generates 80% or more of the “Extract, Transform, and Load” commands, dramatically reducing implementation time and resources.
Faster ETL processing
- Rapid updates. Iterate and update data warehouse solutions frequently to align IT and LOB needs. Dynamically propagate source, business rule or model changes to the target data warehouse.
- Version Control. Attunity® Compose for Data Warehouse further optimizes the data warehousing process by centralizing and automating project version control. Users can compare, lock and/or merge versions and track changes, improving team productivity and agility.
Data warehouse process optimization
Attunity solves the challenges associated with traditional BI tools. Attunity® Compose for Data Warehouse provides IT teams with:
- Enterprise Data Quality. Teams can leverage integrated data profiling, quality and lineage capabilities, and automatically generate project documentation.
- Simplified Development, Testing, Acceptance and Production (DTAP): Attunity Compose further accelerates data warehousing rollouts and updates with the ability to create and deploy project deployment packages directly from the Compose user interface.
Enable real-time data warehouse analytics with easy, efficient change data capture. Attunity software provides streaming change data capture (CDC) and DW automation for all major data warehouse platforms, complementing existing ETL/ELT processes.