topic Re: Does Qlik replicate work with IOT in Qlik Replicate

Does Qlik replicate work with IOT

Kohila — Mon, 18 Dec 2023 17:35:12 GMT

Qlik replication works through internet too? We have a requirement Oracle DB to DB tables to be in sync but source is in legacy and target in OT iDMZ so both connected via internet.

Thanks

Re: Does Qlik replicate work with IOT

john_wang — Tue, 19 Dec 2023 02:54:09 GMT

Hello @Kohila ,

Thanks for reaching out to Qlik Community!

Yes, Qlik Replicate works through internet and intranet, both types of connections are supported. In general Qlik Replicate connect to source and target endpoints (DBs/Warehouse/Steaming Systems/Files Systems etc...) via the corresponding database client, for example in your scenario, Qlik Replicate utilizes the Oracle Instant Client connect to remote Oracle Server. Oracle client/server communications support the internet connections as well, there is no doubt for Qlik Replicate too.

The above mechanism are similar for both Qlik Replicate and Qlik Cloud Data Integration products.

BTW, the Qlik Replicate server should be near by the source endpoint to gain better performance (if possible put the Replicate Server and source DB server at the same intranet).

Hope this helps.

Regards,

John.

Re: Does Qlik replicate work with IOT

SushilKumar — Tue, 19 Dec 2023 07:15:19 GMT

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar

Re: Does Qlik replicate work with IOT

Kohila — Tue, 19 Dec 2023 21:49:22 GMT

Hi, Thanks for the info provided. Could you please share the link of help document to connect to OT iDMZ as target end point. This could help as a lead for our analysis.

Re: Does Qlik replicate work with IOT

Dana_Baldwin — Tue, 19 Dec 2023 22:28:11 GMT

Hi @Kohila

There is a section at this link for every target endpoint Qlik Replicate supports: Adding and managing target endpoints | Qlik Replicate Help

Thanks,

Dana

Re: Does Qlik replicate work with IOT

john_wang — Wed, 20 Dec 2023 01:15:47 GMT

Hello @Kohila ,

Besides @Dana_Baldwin comment, seems I did not get what's the "OT iDMZ" database is, Qlik Replicate does not have a prebuilt driver to connect to it. You may use generic ODBC driver(if there is a 64-bit ODBC Driver for this database) to access it.

Take note that unless enabled through Professional Services and approved by your Account Manager, the ODBC target endpoint should not be used.

Hope this helps.

Regards,

John.

Re: Does Qlik replicate work with IOT

kabip7 — Thu, 28 Dec 2023 14:29:01 GMT

Are they using Qlik Replicate? If so, that is a pretty modern tool and you can write to a bunch of different file formats such as parquet. If they are just using old-school Qlik then it's not too bad to transition off. I moved a bunch of pipelines off of Qlikview about 5 years ago because the client wanted to use a different BI tool.