Qlik Replicate (formerly Attunity Replicate)
Empowering organisations to accelerate data replication, ingestion and streaming
All 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.
Universal data availability
Replicate, synchronise, 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.
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.
Intuitive and guided workflows
Qlik Compose for Data Warehouses helps IT teams:
- Load and sync data from sources with ease. Source feeds are loaded in real-time with a change data capture (CDC).
- Automate data model design and source mapping. Data models can be created or imported, then modified and enhanced iteratively.
- Streamline data warehouse and ETL generation. ETL code is auto-generated to populate and load data warehouses.
- Deploy data marts without manual coding. Datamart types are selected from a broad array of options including transactional, aggregated, or state-oriented.
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: Exadata, Teradata, IBM Netezza, Vertica, Pivotal, MS SQL Data Warehouse
- Cloud: AWS, Azure, Google Cloud
- Hadoop: Apache, Cloudera, Hortonworks, MapR
- Streaming platforms: Apache Kafka, Confluent
- Enterprise Applications: SAP
- Legacy: IMS/DB, DB2 z/OS, RMS, VSAM
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-optimised: Group transactions into batches to optimize ingestion and merging into data warehouses, Hadoop or cloud.
- Data warehouse optimised: Load with native performance-optimized APIs for Teradata, Oracle Exadata 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.
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 synchronise 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 minimises data source and target performance overhead.
- Centralised 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.
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
- 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.
Beautiful
Easily engage, understand, communicate, collaborate and share data to any device with eye-catching and ready-to-use visualisations.
Start your Data Warehouse journey with Qlik
Differentia Consulting are a Qlik Elite Solution Provider offering full life cycle services and complementary business discovery solutions.
Call us on +44 1494 622 600 or email: [email protected]
Request more information or a demo