ETL Software

Qlik Compose is an agile data warehouse automation solution that enables enterprises to streamline data warehousing design, development and rollout.

Qlik Compose automatically generates ETL code, quickly applying updates, leveraging best practices and using proven design patterns. By automatically generating end-to-end workflow from data ingest to report generation, Qlik Compose helps enterprises reduce their dependence on development resources and enables data warehouses to be designed, created, loaded and updated much more quickly. One Fortune 500 company, for example, was able to reduce the time required for ETL data coding from 45 days to two days, reducing implementation costs by 80%.

Qlik Replicate adds even more power to ETL software through log-based change data capture (CDC) technology. Integrating seamlessly with Qlik Compose, Qlik Replicate combines real-time source data integration with automated ETL generation and supports the industry’s broadest range of heterogeneous data sources.Qlik Replicate’s CDC technology captures only the changes made to underlying source systems, avoiding the need to run periodic batch jobs. Replicate works seamlessly with ETL software by providing change tables that can be read using SQL, and by allowing changes to be processed in micro-batch, mini-batch or in continuous streams. Qlik Replicate can be integrated with a wide variety of ETL tools, including Microsoft SQL Server Integration Services (SSIS ETL), IBM WebSphere DataStage, Oracle Data Integrator and many other tools.