Qlik Replicate®

Universal data replication and real-time data ingestion.

Qlik Replicate enables organizations to expedite data replication, ingestion, and streaming across diverse databases, data warehouses, and big data platforms. Trusted by numerous enterprises globally, Qlik Replicate facilitates the seamless, secure, and efficient movement of your data with minimal operational impact.

Widespread accessibility of data

Efficiently replicate, synchronize, distribute, consolidate, and ingest data across all major databases, data warehouses, and Hadoop, whether on-premises or in the cloud. Qlik Replicate has achieved notable results, including:

  • Significantly reducing the nightly batch load time for a global insurer from 6-8 hours to under 10 minutes.
  • Enabling a large credit services organization to apply 14 million source changes to the target in just 30 seconds.

Speed up the process of integrating data for analytics

Effortlessly establish data replication through an intuitive GUI, eliminating the necessity for manual coding.

  • Streamline the massive ingestion of data into Big Data platforms from thousands of sources.
  • Automatically generate target schemas based on source metadata.
  • Enhance efficiency in processing Big Data loads through parallel threading.
  • Leverage the change data capture process (CDC) to uphold true real-time analytics with reduced overhead.

Integrate data across all major platforms

Streamline data integration across diverse platforms with our universal software, offering support for one of the widest arrays of sources and targets. This allows you to load, ingest, migrate, distribute, consolidate, and synchronize data seamlessly, whether on-premises or across cloud or hybrid environments.

Supported platforms 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

For a comprehensive list of connectivity options, please refer to the support matrix.

A flexible platform for capturing change data

Qlik Replicate offers versatile options for processing captured data changes with low-impact, real-time Change Data Capture (CDC) for numerous database systems:

  • Transactional: Apply transactions in the order they were committed to the source, ensuring strict referential integrity and minimizing latency.

  • Batch-Optimized: Group transactions into batches to optimize data ingestion and merging into data warehouses, applicable to various targets on-premises or in the cloud.

  • Data Warehouse Optimized: Load data with native, performance-optimized APIs designed for Snowflake, Azure Synapse, and other Enterprise Data Warehouses (EDWs) utilizing massively parallel processing (MPP).

  • Message-Oriented Data Streaming: Capture and stream data change records into message broker systems such as Apache Kafka.

 

Performance and scale

Our universal software accommodates an extensive array of sources and targets, allowing you to seamlessly load, ingest, migrate, distribute, consolidate, and synchronize data, whether on-premises or in cloud or hybrid environments. Key features include:

  • High Throughput and Low Latency: Facilitate the swift movement of data across the enterprise or hybrid environments, meeting real-time business requirements.

  • Massive Scale: Replicate your data across hundreds of sources and targets, ensuring scalability to match your organizational needs.

  • Low Impact: Utilize log-based, zero-footprint technology to minimize performance overhead on data sources and targets.

  • Centralized Monitoring and Control: Benefit from a unified interface for creating data endpoints, designing and executing replication tasks. Monitor thousands of tasks through a single console, incorporating user-defined alerts and Key Performance Indicators (KPIs).

 

Enabling SAP analytics

Qlik Replicate is specifically designed to provide SAP application data in real-time for big data analytics. With Qlik Replicate for SAP, you benefit from:

  • Flexibility: Move the relevant SAP application data to any major database, data warehouse, or Hadoop, whether on-premises or in the cloud.
  • Easy Data Access: Capture and translate complex SAP formats, and export data using an intuitive and automated interface tailored for the SAP environment.
  • Real-time Integration: Harness Qlik Replicate Change Data Capture (CDC) to ingest live SAP data, enabling real-time analytics in data lakes or other targets. Additionally, generate live Kafka messages for streaming analytics.
 

Enhance data movement efficiency in cloud-native environments

Enable comprehensive hybrid mobility: Transfer data seamlessly across, into, and out of all major cloud platforms and cloud service providers.

Achieve high performance: Efficiently compress and transfer data using multiple paths over the wide area network (WAN).

Ensure secure data transfer: Utilize advanced, NSA-approved (AES-256) encryption for enhanced data security.

 

Adaptable Deployment

Our data integration platform remains neutral towards cloud and analytics vendors, ensuring you have the utmost flexibility in choosing where to store, transform, and analyze your data.

Two deployment options are available:

  1. Qlik Cloud Data Integration: This is a Qlik-managed Enterprise Integration Platform as a Service (eiPaaS).

  2. Qlik Data Integration: This is a client-managed solution that can be installed either on-premises or as a virtual machine image in a location of your preference.