Enterprise Data Warehousing

Qlik 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, Qlik 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 Qlik 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 Qlik 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, Qlik Compose and Qlik 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, Qlik 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. Qlik 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.