It sounds like Qlik replicate will be a good fit for yo0ur replication project. Replicate has many options on how to configure "Tasks" which will copy data from a source to a target database. A replicate task usually has two phases, A full Load phase where the underlying tables are copied from source to target, and CDC phase where replicate typically reads source transaction logs to process changes to the target.
Unless using the Log stream task pair architecture replicate will normally move data directly from the source to the target database. With a Log Stream task there is an intermediate level staging area where the target side task will read from. This type of task is best suited for when you have a single source and multiple target databases.
I am trying to push QLIK as the tool of choice for data replication at my work. Does QLIK behind the scene use a publisher-subscriber approach where an instance of QLIK runs close to the publisher database and another instance runs close to the subscriber database and then there is a "messaging bus" that transfers data between the two?
My team is looking to build in-house replication on the pub-sub model with a queue in the middle. But if QLIK has a similar structure than there is no point building a similar system in-house.
It sounds like Qlik replicate will be a good fit for yo0ur replication project. Replicate has many options on how to configure "Tasks" which will copy data from a source to a target database. A replicate task usually has two phases, A full Load phase where the underlying tables are copied from source to target, and CDC phase where replicate typically reads source transaction logs to process changes to the target.
Unless using the Log stream task pair architecture replicate will normally move data directly from the source to the target database. With a Log Stream task there is an intermediate level staging area where the target side task will read from. This type of task is best suited for when you have a single source and multiple target databases.
