Skip to main content
TrustRadius
Qlik Replicate

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

TrustRadius Insights

Qlik Replicate has been widely used by organizations to simplify and streamline their data integration procedures. Users have reported …
Continue reading

Qlik Replicate Review

9 out of 10
December 18, 2021
Incentivized
We use the Replication to replicate data from Different Sources Databases to Different databases. We use from MYSQL to Oracle, Sybase to …
Continue reading
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
Return to navigation

Pricing

View all pricing
N/A
Unavailable

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.

Entry-level set up fee?

  • Setup fee required

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

66 people also want pricing

Alternatives Pricing

What is Oracle GoldenGate?

Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.

What is Hornetsecurity VM Backup?

Hornetsecurity VM Backup (formerly Altaro) is a backup and replication solution for Hyper-V and VMware virtual machines. VM Backup can manage large infrastructures, with the revamped backup repository providing long-term storage and more efficient use of disk space.

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 RulePoint, Oracle GoldenGate, and HVR are common alternatives for Qlik Replicate.

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

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

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(49)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

Qlik Replicate has been widely used by organizations to simplify and streamline their data integration procedures. Users have reported that this tool effectively transfers data from one place to another, improving overall performance and efficiency in the data integration process. One of the primary use cases for Qlik Replicate is ensuring the accuracy and timeliness of data across various storage systems, which is crucial for organizations relying on real-time data analysis for making informed business decisions. Customers have found value in using Qlik Replicate for data warehousing, disaster recovery, cloud migration, and analytics purposes. This powerful tool allows for data replication, synchronization, and integration across multiple databases and storage systems. Users have successfully replicated operational application data from various sources such as Oracle ERP and Salesforce to Microsoft SQL Server BI systems, enhancing business case data pipelines and supporting reporting and dashboards. Additionally, Qlik Replicate has simplified the process of data warehousing and batch processing of streaming data, making it more convenient for users. Organizations have utilized Qlik Replicate to replicate data from brick-and-mortar source system databases to cloud databases, allowing for direct data querying and supporting various reporting needs. Users have also praised Qlik Replicate for its reliability, intuitive user interface, and support for a variety of sources and targets, making it a preferred choice for replicating on-premises data into the cloud. Overall, customers from different segments and sizes have found Qlik Replicate to be a fantastic tool for achieving seamless data replication with ease of configuration, scalability, and customization options.

Stability and reliability: Users have consistently praised Replicate for its stability and reliability, with minimal alerts, failures, or troubleshooting required. Several reviewers have mentioned this as a key benefit of using the software.

Ease of scalability: Many users have found Replicate to be highly scalable in big data integrated projects, which has had a positive financial impact for them. The ability to easily add new source tables to tasks and ensure synchronization with the latest data has been particularly appreciated by users.

Efficiency in handling large amounts of data: Replicate's ability to efficiently handle and capture large amounts of data has been highlighted by multiple reviewers. This makes it a valuable tool for data replication, warehousing, disaster recovery, cloud migration, and analytics tasks.

Latency Issues: Some users have experienced latency in certain tasks and are unsure of the cause. This issue has been mentioned by multiple reviewers, indicating a recurring problem that affects the overall performance and efficiency of the tool.

Limited Documentation and Error Reporting: Several reviewers have expressed the need for more comprehensive documentation and detailed error reporting in the tool. The lack of sufficient documentation makes it difficult for users to troubleshoot issues effectively, leading to frustration and wasted time trying to find solutions.

Challenging Support Experience: Users have voiced their desire for more agile and efficient support. They find the current support experience lacking in responsiveness and quality, highlighting areas that require improvement such as faster response times, better communication, and more knowledgeable support staff.

Users have made several recommendations based on their experiences with Qlik Replicate. Firstly, they suggest trying Qlik Replicate for change data capture (CDC) needs and conducting a proof of concept (POC) to see the benefits and suitability of the software.

Secondly, it is advised to check the hardware requirements, install recommended resources, and test the software in a representative environment with volume. Users also recommend considering any pre-requests, security requirements, and logging setup.

Lastly, many users find Qlik Replicate worth the cost and believe it is an excellent tool for reducing stress during data replication or loading. They suggest getting a demo of the software to better understand its capabilities and determine if it suits the company's needs.

Attribute Ratings

Reviews

(1-25 of 35)
Companies can't remove reviews or game the system. Here's why
João Florêncio | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
ResellerIncentivized
I have been studying the tool together with my company's pre-sales team. It is a fantastic tool for implementation in customers of different segments and sizes.
  • Full load of transactional databases
  • Very fast CDC incremental loads
  • Replication from one source to multiple targets
  • Database synchronization
  • I have not identified any new needs in my uses
Qlik Replicate is a fantastic tool for replicating data between databases. Its use in analytical environments is essential to ensure speed in data delivery between transactional and analytical bases, keeping these bases updated and reducing the waiting time of complex and costly loads that greatly impact data environments.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
In my previous company, we used Qlik Replicate as the primary tool for near-real-time data integration. The flexibility it provides allows you to perform simple ETL tasks directly within the software. This was crucial for our retail company with an ecommerce platform, as we needed to fulfill orders quickly and align stock information almost immediately.
  • Real time integration
  • User experience
  • Performance
  • Data mapping
  • Integration with external custom code
As a retail company, it is crucial to have consistent and accurate stock information across all systems. Qlik Replicate is a useful tool for achieving this goal, as it efficiently replicates data in near-real-time. However, it may not be the best option for data that requires pre-aggregation before replication. In such cases, using another tool or Qlik View/Sense script may be more appropriate and avoid the need for replicate.
Fernando Tonial | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
Qlik Replicate is used to data integration allows organization to replicate, synchronize, and integrate data across multiple databases, data warehouses, and other data storage systems.

The main use case for Qlik Replicate is to ensure that data is accurate and up-to-date across my organization's various data storage systems. This is particularly important for organizations that rely on real-time data analysis to inform business decisions, as Qlik Replicate ensures that all relevant data is available for analysis in a timely manner. Some common ways that Qlik Replicate is used include:Data Warehousing: Qlik Replicate can be used to replicate data from operational databases to data warehouses for analysis.Disaster Recovery: Qlik Replicate can be used to replicate data in real-time to a secondary location for disaster recovery purposes.Cloud Migration: Qlik Replicate can be used to move data from on-premises systems to cloud-based systems.Analytics: Qlik Replicate can be used to move data from various sources into a single location for analysis.Overall, Qlik Replicate is a versatile tool that can be used to ensure that data is accurate and up-to-date across an organization's various data storage systems.
  • Data Warehousing: Qlik Replicate can be used to replicate data from operational databases to data warehouses for analysis.
  • Disaster Recovery: Qlik Replicate can be used to replicate data in real-time to a secondary location for disaster recovery purposes.
  • Cloud Migration: Qlik Replicate can be used to move data from on-premises systems to cloud-based systems.
  • Analytics: Qlik Replicate can be used to move data from various sources into a single location for analysis.
  • More detailed documentation with errors that occurred in the tool.
  • More agile and efficient support.
  • It works best if you also use other Qlik products.
  • Few APi integrations are not compatible
Qlik Replicate works very well with relational data platforms, both on premise and in the cloud, for example Oracle, SQL Server, PostgreSQL, MySQL and others, it also works very well with DB2.
If the data source is MongoDB, it is more complicated and currently there is no possibility of sending data to MongoDB.
November 21, 2022

Replication Master.

Neel Shah | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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.
Score 2 out of 10
Vetted Review
Verified User
Incentivized
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
Incentivized
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.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Qlik Replicate to replicate data between our cloud-based datamart and on-prem applications.
  • Replication rate
  • Performance
  • Easy to configure
  • Pricing
  • Support
Replication between datamart and applications.
December 18, 2021

Qlik Replicate Review

Score 9 out of 10
Vetted Review
Verified User
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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.
Reid DeWolfe | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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.
Return to navigation