Qlik Replicate®

Universal data replication and data ingestion

Qlik Replicate empowers organizations to accelerate data replication, ingestion and streaming across a wide variety of heterogeneous databases, data warehouses, and big data platforms. Used by hundreds of enterprises worldwide, Qlik Replicate moves your data easily, securely and efficiently with minimal operational impact.

2021 Gartner® Magic Quadrant™ for Data Integration Tools

See why Gartner has recognized Qlik in the Magic Quadrant for Data Integration Tools yet again.
Get Report

Universal data availability

Replicate, synchronize, distribute, consolidate and ingest data across all major databases, data warehouses and Hadoop, on-premises and in the cloud. Qlik Replicate has enabled:

  • A global insurer to cut its nightly batch load time from 6-8 hours to under 10 minutes.
  • A large credit services organization to apply 14 million source changes to the target in 30 seconds.
Click on this image to watch the Qlik Replicate for SAP video.

Accelerate data integration for analytics

Quickly and easily set up data replication with an intuitive GUI, eliminating the need for manual coding.

  • Simplify massive ingestion into Big Data platforms from thousands of sources.
  • Automatically generate target schemas based on source metadata.
  • Efficiently process Big Data loads with parallel threading.
  • Use change data capture process (CDC) to maintain true real-time analytics with less overhead.

Accelerate your data pipeline

AWS, Hadoop, Teradata, Kafka, Microsoft SQLServer, IBM DB2, Oracle, SQL, Confluent and SAP Logos
Logos representing some of the main data sources and targets supported by Qlik Replicate: AWS, Hadoop, Teradata, Kafka, SQL Server, IBM DB2, Oracle, SQL, Confluent, SAP

Integrate data across all major platforms

Our universal software supports one of the broadest ranges of sources and targets, enabling you to load, ingest, migrate, distribute, consolidate and synchronize data on-premises and across cloud or hybrid environments. These include:

  • RDBMS: Oracle, SQL, DB2, MySQL, Sybase, PostgreSQL
  • Data warehouses: Azure Synapse, Snowflake, Exadata, Teradata, IBM Netezza, Vertica, Pivotal
  • Cloud Platforms: AWS, Azure, Google Cloud
  • Cloud Service Platforms: Databricks, Snowflake, Confluent
  • Streaming platforms: Apache Kafka, Confluent, Azure Event hubs, AWS Kinesis
  • Enterprise Applications: SAP, Salesforce
  • Mainframe: IMS/DB, DB2 z/OS, RMS, VSAM
  • Please refer to the support matrix for a complete list of connectivity options.
“Without Qlik, we could not have done the project since it would have been too costly for us in terms of development work.”
Christian Phan-Trong, Director Architecture, SwissLife
“After weeks of manual attempts, we turned to Qlik for Amazon Redshift. In less than an hour, Qlik loaded 37 million records.”
Andy Allaway, Data Scientist, Philips
Diagram representing the different ways in which you can use Qlik Replicate for data delivery. It's in-memory and file optimized data transport options support: transactional change data capture (CDC), batch CDC, data warehouse ingest and merge, and message-encoded data streaming.

A versatile platform for change data capture

With low-impact, real-time CDC for many database systems, Qlik Replicate provides flexible options to process captured data changes:

  • Transactional: Apply transactions in the order they were committed to the source to ensure strict referential integrity and lowest latency.
  • Batch-optimized: Group transactions into batches to optimize ingestion and merging into data warehouses, and many targets on-prem or in the cloud.
  • Data warehouse optimized: Load with native performance-optimized APIs for Snowflake, Azure Synapse and other EDWs that use massively parallel processing (MPP).
  • Message-oriented data streaming: Capture and stream data change records into message broker systems like Apache Kafka.
Diagram showing data being leveraged from both on-premise and cloud sources.

Performance and scale

Our universal software supports one of the broadest ranges of sources and targets, enabling you to load, ingest, migrate, distribute, consolidate and synchronize data on-premises and across cloud or hybrid environments. These include:

  • High throughput and low latency: Move data across the enterprise or hybrid environments at high speed to meet real-time business requirements.
  • Massive scale: Replicate your data across hundreds of sources and targets.
  • Low impact: Log-based, zero-footprint technology minimizes data source and target performance overhead.
  • Centralized monitoring and control: Leverage a single interface to create data endpoints, design and execute replication tasks. Monitor thousands of tasks through a single console with user-defined alerts and KPIs.

Explore Qlik Enterprise Manager

Click on this image to watch the Qlik Replicate for SAP video.

Enabling SAP analytics

Qlik Replicate is optimized to deliver SAP application data in real-time for big data analytics. With Qlik Replicate for SAP, you gain:

  • Flexibility: Move the right SAP application data to any major database, data warehouse or Hadoop, on-premises or in the Cloud.
  • Easy data access: Capture and translate complex SAP formats, then export data with an intuitive and automated interface that is purpose-built for the SAP environment.
  • Real-time integration: Leverage Qlik Replicate CDC to ingest live SAP data for real-time analytics in data lakes or other targets and create live Kafka messages for streaming analytics.
Optimize data movement for cloud native environments
Logos of key cloud environments supported by Qlik Replicate: Microsoft Azure, Amazon Web Services(AWS), and Google Cloud Platform

Optimize data movement for cloud native environments

  • Enable full hybrid mobility: Move data across, into, and off all major cloud platforms and cloud service providers.
  • Enable high performance: Efficiently compress and transfer data in multiple paths over the wide area network (WAN).
  • Secure data transfer: Leverage advanced, NSA-approved (AES-256) encryption.
Architecture diagram illustrating how Qlik Replicate can deliver data via CDC or batch from cloud and on-premises data sources (such as Hadoop, RDBMS, data warehouse, files and mainframe) to similar enterprise data sources running on-premises or in the cloud
Diagram demonstrating the Hybrid Data Delivery process

Qlik Cloud Data Services - Hybrid Data Delivery

Move on-premises data to Qlik Cloud® in near real-time for insight and analytics.

  • Automatically create and manage QVDs without scripting
  • Command and control data ingest from Qlik Cloud
  • Supports all major relational data sources, mainframe, SAP and more
Learn More

Explore our solutions for modern data integration.

  • Real-Time Data Streaming (CDC)

    Extend enterprise data into live streams to enable modern analytics and microservices with a simple, real-time and universal solution.

  • Agile Data Warehouse Automation

    Quickly design, build, deploy and manage purpose-built cloud data warehouses without manual coding.

  • Managed Data Lake Creation

    Automate complex ingestion and transformation processes to provide continuously updated and analytics-ready data lakes.

  • Enterprise Data Catalog

    Enable analytics across your enterprise with a single, self-service data catalog.

DATA SHEET

Qlik Replicate Data Sheet

WHITEPAPER

Enhance The Value of SAP Data With Real-time Data Integration for Analytics

WHITEPAPER

Qlik Replicate: High Performance, User-Friendly Enterprise Data Replication & Loading

Learn more about Qlik Replicate today.

Qlik Replicate® is a leading enterprise database replication software package that allows users to accelerate database replication, big data-ingestion, and streaming data. Replicate works across a wide range of databases, data warehouses, and Hadoop, while also allowing for seamless cloud data replication.

All logos and product names are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.