TrustRadius Insights for Qlik Replicate are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
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.
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.
Pros
Real time integration
User experience
Performance
Cons
Data mapping
Integration with external custom code
Likelihood to Recommend
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.
VU
Verified User
Employee in Engineering (Retail company, 1001-5000 employees)
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.
Pros
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.
Cons
It requires a stable and proper internet connection.
Sometimes it's harder to duplicate the environments.
Some more documentation could be provided.
Likelihood to Recommend
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.
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
Pros
Replication between different databases
Customizations
Transformations
LOB handling
Filtering
Cons
Support wise
Support more sources
Performance improvements
Likelihood to Recommend
Specifically when we have different Source and targets triplicate and for CDC data, transaction, and batch processing.
Alternatives
GoAnywhere MFT
For different data bases source and target support, transformations, scalability, speed
VU
Verified User
Consultant in Engineering (Entertainment company, 10,001+ employees)
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.
Pros
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
Cons
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.
Likelihood to Recommend
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.
Alternatives
Oracle GoldenGate
We tried to use Oracle GoldenGate for our Oracle source replication needs but, had too many issues with a number of our tables due to churn or size. Qlik Replicate had no issues. And, we can tune our tasks to not impact the source systems we are pulling from.
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.
Pros
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.
Cons
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.
Likelihood to Recommend
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.
Alternatives
Fivetran
The biggest advantage of Replicate in comparison to Fivetran is that we can run the application on-prem. This allows us to configure it precisely how we desire, avoid opening additional ports in our firewall, and monitor its resource consumption directly. That level of control is highly desirable for us.
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.
Pros
Replication
Synchronization
Distribution
Cons
Support
Cost
Learning curve
Likelihood to Recommend
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.
Alternatives
SQL Server Integration Services
Simple to do one-to-one copy and very reliable, as other tools a little complex in setting up the pipelines and scheduling parts. Very simple to connect to the SFTP locations and easy to download them as well.
VU
Verified User
Employee in Engineering (Logistics & Supply Chain company, 5001-10,000 employees)