Overall Satisfaction with Qlik Replicate
We have recently implemented Qlik Replicate to move our data from two different data platforms to one. The sources are Oracle and DB2 and target is MS SQL. We used to have a lot of challenges utilizing the data from different platforms on reporting, analytics, and supporting downstream systems, which were mostly utilizing the SQL server. After the implementation, I think a great amount of our energy is saved and we are engaged in more productive projects and are able to to utilize our time efficiently.
- Qlik Replicate brought a great experience with respect to the ease of implementation and great UI. We had a software that was a blackbox for the team and was very hard to maintain. Qlik Replicate implementation helped us avoid dependency on one resource.
- Global transformation and in-built functions are what I like in our project.
- You can customize the conversion/transformation using a JSON file generated by Qlik Replicate, and it is very convenient.
- I think Qlik File Channel need some improvement.
- Sometimes log files are not getting deleted when you push it to purge on UI.
- Upgrading the software should be a one-click task. The software should be intelligent enough to back up the required old version of a file in the archive and apply the patch, and if all goes well, purge the archive or else it will revert back.
- We are replicating data from DB2 and Oracle. Data delivery speed is impressive.
- Our old replication software was complex and was maintained by one resource. By introducing Qlik Replicate, we have the flexibility where many resources are trained and capable to operate and there is no need for a dedicated resource to manage this tool. This helped us save time and money by reducing a dedicated resource.
- Syncsort Assure MIMIX, Microsoft SQL Server and Veeam Backup & Replication
We tried MIMIX, SQL SSIS and Veeam but our team found Qlik Replicate had an advantage over all these three in terms of speed, UI, and ease of maintenance.