Agile Data Warehouse Automation

Dramatically reduce the time, cost, and risks of data warehousing projects

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

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

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

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

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

Data warehouse process optimization

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.
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.

Learn more about Attunity Compose today.