topic Qlik Replicate + Informatica // Qlik Replicate + IBM Datastage: What is it used for? in Qlik Replicate

Qlik Replicate + Informatica // Qlik Replicate + IBM Datastage: What is it used for?

monon — Wed, 20 Mar 2024 11:12:56 GMT

Hello everyone,

As part of a study into the use of integration solutions, I've noticed that some users seem to be combining different tools, in particular Qlik Replicate + Qlik compose + Informatica (powercenter/ICS) or even Qlik Replicate + Qlik compose + IBM DataStage.

Is this the case for you or have you already seen this type of usage? If so, what does it involve?

Thanks for your help!

WinterCod!

Re: Qlik Replicate + Informatica // Qlik Replicate + IBM Datastage: What is it used for?

OritA — Thu, 21 Mar 2024 08:41:07 GMT

Hi,

In genreal Qlik Replicate is used to Replicate data between different database endpoints and Replicate compose allows you to intergrate data from different source. If you wish you can read more details about the producs in the products user guide (see links below). Every customer uses these product in different combinations based on their need. So the question that needs to be asked here is what is your need?

Link to Replicate users guide: https://help.qlik.com/en-US/replicate/November2023/Content/Replicate/Main/Introduction/Home.htm

Link to compose users guide: https://help.qlik.com/en-US/compose/November2023/Content/ComposeDWDL/Main/DW/Introduction/Home.htm

Regards,

Orit

Re: Qlik Replicate + Informatica // Qlik Replicate + IBM Datastage: What is it used for?

SushilKumar — Fri, 22 Mar 2024 02:16:38 GMT

Hello @monon

Thanks for reaching out to Qlik via Qlik Community Support page. Qlik replicate is very tool which use SQL extraction from source database to replicate the data to the configured target database.

Qlik Compose help you to create Datamart on the available data be it RAW/unstructured or data received from DBMS/rdbms.

And as ORIT mentioned choosing and learn more about the product totally depend upon your business requirement and infra involved ( on prem/cloud) .

Thanks & Regards,

Sushil Kumar