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.
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.
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.
“One of the most useful things about Attunity Compose is that is gives us better data. This decreases anxiety in the business and we expect that it will give Poly-Wood a competitive edge in the market.”
Sean Rassi, President of Design and Technology, Poly-Wood
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.
Learn more about real-time data warehousing
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.