Qlik Replicate

What is Qlik Replicate?

Accelerate and simplify the design, development, testing, deployment, and data warehouse updates.

Speed up time for analysis

Traditional methods of building and managing data warehouses are striving to keep up with business demands. The multi-month error-prone ETL development effort to set up a data warehouse - typically 60 to 80% of the readiness time - usually means that the data model is out dated even before the BI project starts. Modifying these fragile data warehouses causes more delays, binds qualified resources, and delays project ROI.

To speed up analysis time, the data warehouse creation and management lifecycle should be optimized whenever possible.

Modern approach to data warehousing

Qlik Compose for Data Warehouses (formerly Attunity Compose) provides a modern approach by automating and optimizing the creation and operation of the data warehouse. Qlik Compose automates warehouse design, generates ETL code, and applies updates quickly, leveraging proven best practices and design standards. Qlik Compose for Data Warehouses dramatically reduces the time, cost, and risk of BI projects, on-premises or in the cloud.

Agile data warehouse automation

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

• Quickly design, create, upload, and update data warehouses
• Generate ETL automatically to reduce time, costs and risks
• Implement best practices and templates for more effective BI projects
• Reduce dependency on highly technical development resources
• Automatically generate end-to-end workflows, from data ingestion to reporting

Intuitive and guided workflows

Qlik Compose for Data Warehouses helps IT teams:

• Easily upload and sync data from sources. Source feeds are loaded in real time with Change Data Capture (CDC).
• Automate data model design and source mapping. Data models can be created or imported, modified, and itethetistly enhanced.
• Simplify data warehouse and ETL generation. The ETL code is automatically generated to populate and load the data warehouses.
• Deploy data marts without manual coding. Data mart types are selected from a wide variety of options, including transactional, aggregated, or state-oriented.

Optimize the data storage process

Key operational features include:

• Workflow designer and scheduler: Perform all data mart data warehouse and ETL tasks as a single end-to-end process. Schedule workflow execution to align with business and IT processes.
• Lineage and impact analysis: Create metadata automatically during the design or implementation phases. Regenerate the data lineage when the changes are implemented.
• Monitoring and notification: Monitor the status of all automatically generated tasks and workflows. Send proactive status alerts.
• Data profiling: Validate data before it is loaded by identifying and notating format issues and discrepancies.
• Data quality: Configure and apply preload rules to automatically discover and fix issues with values, formats, data ranges, and duplication, and implement exception policies.

System requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD / SSD: 50 GB of free space on the main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit

Resolution: 1024×768