Qlik Replicate

Qlik Replicate

Top Rated
Score 8.3 out of 10
Top Rated
Qlik Replicate

Overview

What is Qlik Replicate?

Qlik Replicate enables organizations to accelerate data real-time replication, ingestion and streaming via change data capture, across a wide range of heterogeneous databases, data warehouses and data lake platforms.
Read more

Recent Reviews

Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Qlik Replicate, and make your voice heard!

Return to navigation

Product Details

What is Qlik Replicate?

Qlik Replicate (formerly Attunity Replicate) enables organizations to accelerate data replication, ingestion and streaming across a variety of heterogeneous databases, data warehouses, and big data platforms. Boasting hundreds of enterprise users worldwide, Qlik Replicate is designed to move data securely and efficiently, with minimal operational impact. Qlik Replicate provides automated, real-time, and universal data integration across all major source endpoints such as databases, systems like SAP, mainframes and Salesforce and delivers data to streaming systems, data warehouses, and data lakes. On-premises and in the cloud.

Qlik Replicate is Enterprise-Ready. It moves data at high speed from source to target and offers a single pane of glass monitoring of data pipelines across the enterprise, all managed through a graphical interface that automates end-to-end replication. With agentless configuration, administrators and data architects can set up, control, and monitor bulk loads and real-time updates with automated change data capture (CDC) at scale.

Qlik Replicate Screenshots

Screenshot of Screenshot of Screenshot of Screenshot of Screenshot of Screenshot of

Qlik Replicate Video

Move data with minimal operational impact.

Qlik Replicate Integrations

Qlik Replicate Technical Details

Deployment TypesOn-premise
Operating SystemsWindows, Linux
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

Qlik Replicate enables organizations to accelerate data real-time replication, ingestion and streaming via change data capture, across a wide range of heterogeneous databases, data warehouses and data lake platforms.

Informatica Data Engineering Streaming, Oracle GoldenGate, and HVR are common alternatives for Qlik Replicate.

Reviewers rate Qlik Replicate Productivity 4.7.21 highest, with a score of 8.8.

The most common users of Qlik Replicate are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews

(1-25 of 32)
Companies can't remove reviews or game the system. Here's why
November 21, 2022

Replication Master.

Neel Shah | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Our essential data integration procedures, including data replication, transformation, and ingestion, have been reduced and are now more efficient and cost-effective than before. Our data integration process was simplified, and both its ease of use and the manner in which it transfers data from one place to another had a good influence on our performance.
  • It is really easy to scale up the big data integrated projects which helps a lot financially.
  • Sometimes for data replication it's really handy.
  • It can take and capture a large data.
  • It requires a stable and proper internet connection.
  • Sometimes it's harder to duplicate the environments.
  • Some more documentation could be provided.
All sizes of businesses may benefit from integrating data from various sources for analytics and business operations thanks to Qlik Replicate. Data architects and administrators may quickly and effectively set up, manage, and monitor bulk loads utilizing agentless setups due to its global visibility capabilities and centralized management of data transmission across distributed, hybrid settings.
Score 7 out of 10
Vetted Review
Verified User
We use Qlik replicate to extract data from sources to a decentralized environment to minimize the impact on our production sources. We do this on any data sources that are relevant for our data engineers. We have different types of sources that all need to be replicated and Qlic replicate has done a good job so far for our data sources like Oracle, SAP, and Microsoft SQL servers.
  • It has a really good replication speed.
  • The interface is initiative.
  • It supports many major platforms.
  • It’s a bit heavy for our relative small environment.
  • It works best if you also use other Qlik products.
  • You need experienced people to work with this tool.
Qlic replicate works best if you have a good data specialist that knows what he is doing. If you have many different source platforms, Qlic can make a connection to all. It supports many of the major platforms. If you mainly use one data source platform, the native tooling could better suit your use case. If you have a small company, it probably would be better to look for some cheaper tooling.
Bindu Bhargava Reddy Chintam | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Most of business case data pipelines are implemented and used with this application.
Previously, we had lots issue regarding replication of our realtime stream of business sales data and e-commerce data. Using this data warehousing is made easier and helpful. Even batch processing the streaming data is more convenient using this software.
  • Datawarehousing
  • Data Encoding
  • Batch Processing streaming data
  • Handle transactional Metadata
  • Bigdata complications are solved
  • Few local databases are not compatible
  • Spark processing to be needed
  • Few APi integrations are not compatible
Handling streaming data where it good at. Replication of database services are awesome. It works wide range of dbs, ware houses and Hadoop clusters with seamless cloud data replication. Big data ingestion and data pipeline creation is much easier using this software. As it partnered with azure, most of our services with azure can be used here as well.
November 02, 2022

Qlik Replicate

Score 8 out of 10
Vetted Review
Verified User
Qlik Replicate is used in IT to replicate on-prem data to off-prem Cloud solutions.
  • Replicates data across disparate platforms.
  • Pretty easy to maintain and update
  • Troubleshooting issues can be difficult as errors are not very clear.
  • Logging is minimal and not terribly helpful by default unless you increase the logging levels.
It is well suited for replicating data across disparate data platforms. If your environment only uses one data platform (i.e. only SQL Server, only Oracle, etc.) then you can probably rely upon replication solutions provided by said products.
Support is responsive and friendly. For issues specifically limited to Qlik Replicate, support tends to be quick and knowledgeable.

If the issue is deeply technical - for example very specific to a given database platform - then it can take a little longer to speak with someone that is knowledgeable enough about Qlik Replicate AND the affected database platform. The amount of time is not unbearable and I think is general reasonable given the level of unique expertise that can be required.
Score 2 out of 10
Vetted Review
Verified User
We use Qlik Replicate as one of many tools to migrate data across platforms
  • Simple task creation
  • Bugs.
  • Qlik Replicate is great because it requires no coding. But it falls short in customizability.
Simple full load data migration is where Qlik Replicate excels. However, depending on your skillset, you may wish to develop something on your own. In the case where time or skills are limited, it's great.
Score 9 out of 10
Vetted Review
Verified User
We use Qlik Replicate to Move Data over from 14 DB2 on-prem servers to AWS cloud. The tool is very easy to configure between any Source and Target. We never had any issues with it so far. It scales to a greater extent, and we can customize it to our need for Replication frequency and the format in which you want the data to be delivered into Target. It was a great suit for us, as we were looking for a tool that can read data from our Journals and not from the physical tables, so the performance of the transaction system is not Impacted. I would definitely recommend Qlik Replicate for other companies looking out for a Replication Tool.
  • Easy to Scale
  • Multiple Endpoint options
  • Options of Output format
  • Logging
  • Alerting
Well suited for scenarios where you want to read from Journals and not from Physical Tables. Data reconciliation is not done with Qlik Replicate.
December 18, 2021

Qlik Replicate Review

Score 9 out of 10
Vetted Review
Verified User
We use the Replication to replicate data from Different Sources Databases to Different databases. We use from MYSQL to Oracle, Sybase to SQL , SQL to Aurora, and Aurora to S3
  • Replication between different databases
  • Customizations
  • Transformations
  • LOB handling
  • Filtering
  • Support wise
  • Support more sources
  • Performance improvements
Specifically when we have different Source and targets triplicate and for CDC data, transaction, and batch processing.
Score 9 out of 10
Vetted Review
Verified User
We use Qlik Replicate (formerly Attunity Replicate) to load data from multiple on-prem sources (Oracle and SQL Server DBs) into the Cloud Data warehouse in Azure cloud. Software is easy to set up and configure. Software is very reliable, works great, has a scheduler that some other competitors don't have as well as a job notification process. UI is very intuitive and as long as there are no tricky transformations are deployed, users don't need any training. For heavy-duty transformations to implement, it gets tricky, and transformation functions are not obvious at times. The software supports a variety of sources and targets and works better than competitors. We run daily/weekly/monthly jobs to replicate on-prem data into the cloud and it works very well. We also have a number of near real-time replication jobs and [they] work well too.
  • Performing near-real time replications for 14TB SQL Server DB into Azure EDW
  • Performing near real time replications from 28TB on-prem Oracle DB into Azure EDW
  • Looking for Qlik to support CDS view replications from S4 HANA, both full loads and CDC
  • Better document data transformation functionality
Good and reliable software
Doug Thomas | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
We use Qlik Replicate for the replication of data in our brick-and-mortar source system databases to our cloud database. Our source systems are on many servers and we replicate them near real-time to a central cloud database. In our central cloud database, our users (product, data scientists, business analysts, etc.) can query the data directly. We also maintain data marts against the replicated data that are used by many different areas of our business as well. With Qlik Replicate we can tune replication to be cost-effective per data set. And, with Qlik Enterprise Manager we can manage and analyze all replication tasks in a single UI no matter how many Qlik Replicate servers we may have and, whether they are on Linux or Windows.
  • Many different source to target replication options
  • Common UI on Linux and Windows
  • Lots of task tuning options
  • Robust API (Enterprise Manager)
  • Easy to use UI
  • Robust scheduler
  • I would like to be able to keep task history beyond 30 days for viewing in analytics.
  • I would like integrations to more than email. Say, MSFT Teams channels.
  • Logging is great. With known resolutions to errors that are encountered it would be great to have more detailed context-sensitive help for faster resolution of errors. Especially if they are well known in the community.
  • I would like integration to source control for our at least our tasks.
We've found Qlik Replicate is well suited for near-real-time data replication from brick and mortar databases to cloud providers. We've tried a number of different options and found Qlik Replicate to be the one product that could handle all of our use cases without any issues. We also minimize any custom code needs as well as administration and application support needs.
Score 9 out of 10
Vetted Review
Verified User
Qlik Replicate is used to replicate data across on-premise databases as well as to our cloud based data lake operations.
  • Single pane of glass management with Qlick Enterprise Manager
  • Ease by which to build replication jobs
  • Simplicity of moving data from one location to another
  • Each endpoint in use has its own challenges in terms of setting up and managing
  • New features [I feel] tend to be buggy and are not easily diagnosed
  • SAP HANA as a source is still a bit of a challenge if you are hoping to use log-based replication. SAP will threaten to invalidate your support. Qlik has developed a new extractor method that will take time to mature. At this point triggers are still the primary method.
Qlik Replicate is great for moving data exactly "as is" for non-complex data objects, but not recommended for large data volumes of complex objects (BLOB, etc)
Score 9 out of 10
Vetted Review
Verified User
We first used Qlik Replicate to replicate data from the Oracle ERP system to a Microsoft SQL Server BI system. We have also started using Qlik Replicate to replicate from Salesforce to the Microsoft SQL Server BI system.
  • Flexibility for creating multiple tasks for grouping related tables
  • Table level filters
  • The scheduler feature has been very useful
  • The scheduler, while useful, has issues when trying to create or adjust a schedule more recent than the current time UTC. That is the one thing I would really like to see improved.
Qlik Replicate is very good at cross platform replication such as from Oracle to Microsoft SQL Server.
Rajesh Chauhan | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Operational Application Data (Oracle + SQL Server) replication to Data Lake (SnowFlake). The core capability is to replicate Operational data in real/batched mode to Data Lake as core to servicing enterprise data hub which enables Enterprise Reporting, Data Warehouse, and other data as application usage (Data Innovation and sharing at the edge).
  • Real time replication using Database Logs
  • Speed to setup and make it operational
  • Speed to business value realization
  • Applying the solution to SAP/HANA and other databases as source
  • Connectors/Adaptors to Tier 1 Cloud applications
  • Data type portability across multiple databases
A great tool to data replication solution for Oracle/SQLServers/etc. Fails to replicate data from SAP HANA via CDS Views and/or using SAP ODP framework. Only SAP HANA log base replication is supported which is not certified by SAP nor guaranteed for row tables. Real easy to get it set up and start realizing business value.
Score 8 out of 10
Vetted Review
Verified User
Qlik Replicate/Attunity is being used to replicate SQL server database to our cloud Snowflake database in near real time. It is being used to create strategic datamarts and dashboards to the whole organization and allows us to have access to the data without impacting the ERP production server with live queries.
  • Replication
  • Reliability
  • Incremental Speed
  • Full reload speed
  • Features such as parallel processing are not working
  • If connection is lost, a full reload is required to re-sync
Good for database to database replication. Salesforce connector did not work last I checked as it did not handle custom fields well and was erroring out due to row counts.
Score 10 out of 10
Vetted Review
Verified User
Qlik's solutions have helped make financial data more easily accessible across orgs and has provided the additional functionality my team needs to provide real-time analytics in a fast-pace Tech environment. The platforms used prior to Qlik were not as intuitive, less reliable and much slower than the solutions provided by Qlik.
  • intuitive interface
  • reliable data
  • helpful support when needed
  • smoother interface
  • faster load times
  • enhanced funtionality
There are many applications where Qlik's solutions have helped my team considerably, most notably when we were tasked with providing detailed analysis with a short turn-around time (Qlik's quick interface allowed us to complete the task without delay). A scenario where Qlik is not ideal is when it's used by an untrained or inexperienced user.
Score 10 out of 10
Vetted Review
Verified User
Qlik Replicate is being used as a Data Ingestion layer from enterprise applications and source systems like ERP, CRM by directly scanning the backend DB logs on a real-time basis. Qlik Replicate is used specifically by IT for Data Warehousing and BI reporting. It helps resolve not running a batch-based ETL process to ingest the data into the Data Warehouse staging layers avoiding an expensive overhead to manage additional time-bound processes.
  • Data ingestion.
  • Real-time analytics.
  • Replicating/syncing source data (CRUD operations).
Qlik Replicate is well suited for building data pipelines to replace ETL processing, this is extremely useful when the source datasets lack identification of change records. Instead of ETL doing a row by row comparison which is more expensive Qlik Replicate does the delta changes by using watermark from the database logs eliminating the need any additional processing for sourcing the data. It is more appropriate where the need arises to ingest the source data as its generated for faster ingestion and analysis (real-time analytics).
Score 7 out of 10
Vetted Review
Verified User
It is used as a replication service(tool) to copy data from one source to another(Target) and make use of the data instead of hitting the main source and that is used for all the data analytics. This solved the problem of the cross-platform join for the end-users who want to view the data.
  • Replication
  • Synchronization
  • Distribution
  • Support
  • Cost
  • Learning curve
Organizations should use this tool if they have a variety of data sets that needed to be in one place and do cross-platform joins.
Good for replication and cross data platform querying
Reid DeWolfe | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
We use Replicate to ETL data from on our prem instances to cloud databases hosted by both ourselves and our clients. Our clients benefit greatly from having near-real-time data from our application available to them for analysis and integration purposes. Using Replicate allowed us to avoid developing our own custom processes and tooling for automating the creation of these ETL processes.
  • Reliably and quickly delivers data to and from a wide variety of endpoints.
  • Support staff responds quickly and helpfully to support requests and questions.
  • API coverage in Enterprise Manager allows for automation of administrative tasks.
  • The base Replicate web GUI is lacking. If you have dozens or more tasks, it's hard to get a sense of how they're performing. Enterprise Manager solves all of these problems but is a separate install.
  • The support portal is extremely difficult to navigate. It's hard to track down exactly what you're looking for.
  • It would be helpful to have better documentation and example queries for the tables in the Enterprise Manager analytics database.
  • Destination databases that don't support common DDL commands behave unpredictably. And the replication of schema changes isn't consistent.
It's a great solution if you have relatively static schemas and a limited number of tasks going to a small number of distinct endpoint types. In those situations, it can easily handle large volumes of data changes given appropriate host resources. However, once you end up with a larger number of tasks with a diversity of destination endpoint types Enterprise Manager becomes essential. Automating tasks via API is needed to keep management of the tool sustainable.
Score 10 out of 10
Vetted Review
Verified User
Our organization uses Qlik Replicate for streamlined data replication for ingestion across our North American data warehouses and big data platforms both on-prem and cloud environment solutions. For over 5 years we have used Qlik Replicate to move our data securely and fast! Qlik integrates with our other enterprise suites nicely and the ease of use and reliability, not to mention the economic costs, keeps us renewing year after year. The representatives and support teams at Qlik are outstanding as well. Overall, Qlik Replicate is a solution we will continue to use for years to come without our ever-evolving technological landscape.
  • Data replication.
  • Data ingestion.
  • Data streamlining across multiple platforms.
  • Not applicable, we are pleased with the performance and functionality as is.
Qlik Replicate is well suited in a data management environment where there are various databases, data warehouses, and big data platforms. When an organization has many different data stores, it is crucial for end-users to see their data as holistic, and Qlik Replicate achieves this for our very large organization. Qlik Replicate may not be suited for smaller organizations that only have a few data points.
Score 10 out of 10
Vetted Review
Verified User
As part of our migration from an on-premises Netezza Enterprise Data Warehouse to Snowflake we also replaced dozens of lengthy ETL extract processes with Qlik Replicate. This gave us one location with multiple system's data in near real-time for operational reporting as well as the ability to simply transform and load data into the Data Warehouse without the lengthy extract process. As a result, we start the process later in the day and finish much earlier despite continuing to add more data and complex processing.
  • Loads data from ERP systems.
  • Non journaled/logged sources can be run as full load only processes via API calls.
  • Monitoring and alerting.
  • Ability to enable source system owners to start and stop tasks for their maintenance windows.
  • A wizard for partitions for parallel loading.
  • Better way to analyze latency.
  • Better documentation for using flat files as a source.
Its great for loading data from ERP databases (iSeries, Oracle, DB2, SQL Server). Not that great for Netezza. Does minimal DDL (no unique constraints other than PK, no foreign keys).
Score 7 out of 10
Vetted Review
Verified User
Replicate data from on-prem DB2 on z/OS (mainframe) database to S3 and Aurora PostgreSQL databases in AWS cloud.
  • Support for many source and targets.
  • Ability to customize replication setup (set locking level with connection string, set the replication key, etc.).
  • Straightforward and problem-less installation.
  • Lack of APIs on replicate server to automate and monitor replication. (repctl API interface on Linux replicate server is limited and being deprecated, forcing customers to use AEM server to control replicate box)
  • AEM server (web interface) seems laggy, nonresponsive, slow, does not refresh. Needs to be more mature.
  • Task scheduler is only available on replicate server web console. AEM should have the ability to set schedules.
Simple interface, Nice AEM GUI interface for non experienced user (much simpler that Informatica). Best for simple CDC replications without any ETL manipulation for companies with inexperienced stuff.

At the same time can be customizable with JSON config files. Biggest strength is a support for a number of endpoints (supports DB2 z/OS as source)
Score 8 out of 10
Vetted Review
Verified User
For our main company-wide LIMS system to replicate for reports.
  • Easy to make DDL changes that replicate.
  • Easy to add and subtract tables.
  • Keeps up with very busy system.
  • Better explanation in help for settings to explain if change one setting how it could affect another setting.
  • A better recommendation on what to set for a combination of settings for certain circumstances
  • Make support portal much easier to use. Don't know when responding if respond to the latest comment from the support engineer or to the ticket - very confusing.
  • The responsiveness from support to be much improved. I couldn't get someone to call me on the phone to discuss everything which would take a lot less time than going back and forth on the support portal.
  • Latency alert to allow to be defined to continue sending every number of defined minutes like every 30 minutes if still above the threshold and hasn't dropped below the threshold. It's easy to miss the initial email so if emails continue to be sent then there's more of a chance to catch that replication is behind and something may be wrong or broken.
Good for a reporting scenario to replicate just the tables needed for reporting from another database.
July 16, 2021

Ease of use

Score 8 out of 10
Vetted Review
Verified User
[Qlik Replicate was] mainly used for Change Data Capture[.]
  • Change Data Capture
  • Full Loads to MPP system
  • Reading from log files from most of the sources in our case it is Oracle and SQL server
  • When doing CDC from SQL server
  • If we use Back up logs only then it doesn’t let us just add the new table we have to start the full load first and bring it to current and then start CDC
[Qlik Replicate is well suited for] change Data Capture for APS[.]
Score 10 out of 10
Vetted Review
Verified User
It is used across the company to replicate ecommerce, ERP, finance and marketing data. In lieu of complicated data flow, it enables us to have a real-time data using simple method which are convenient for users. It can also be easily monitored and users will be notified if there is any kind of issue in the replication.
  • Low latency.
  • High volume data.
  • Easiness of monitoring.
  • Alerting mechanism.
  • Less impact on the source.
  • Hourly schedule.
  • Source to target comparison.
  • Renaming tasks.
We had to develop a database and make it available to users as soon as possible. If we used other tools to replicate the data, it might take longer time. But by using QLIK, we were able to set up the target database with less effort and less time. The precision is amazing and the latency was very minimum.
June 13, 2021

Gets the job done

Score 8 out of 10
Vetted Review
Verified User
We use Qlik replicate to sync data across multiple internal database systems. It is owned by our data services team but feeds systems that are used across the entire organisation. It mitigates a potentially intensive impact to steel thread systems.

We also use it to feed our Kafka, which in turn serves our datalake in Google cloud platform.
  • Reduces impact on source systems by reading database logs
  • Allows for minor data transformations as part of the replication
  • Allows for point in time recovery
  • Their support is pretty poor. They can take a every long time to get to the root cause of issues and it can take a long time to roll out patches for bugs.
  • We asked about a pubsub target endpoint over a year ago and have not seen anything in their roadmap for it
  • QEM APIs could be improved. We've tried to automate a lot of the management but due to these limitations our solution is not as good as it could be
  • No ci/cd process promoting tasks across environments.
It's great if you need read only copies of data. Expect to have to deal with a lot of reloads though. When it fails, it can fail spectacularly though.
Return to navigation