topic Data Movement Gateway with source and target is on premise in Data Movement & Streaming

Data Movement Gateway with source and target is on premise

lguevara — Wed, 19 Mar 2025 21:46:28 GMT

HI,

Please I want to desing and end to end data movement pipeline from oracle on prem to sql server on prem in the same organization using Data Movement Gateway.

Is this feasible?

Re: Data Movement Gateway with source and target is on premise

TimGarrod — Thu, 27 Feb 2025 12:59:01 GMT

Yes. This is part of the purpose and a use case for the data movement gateway.

Install the gateway in your on-premise environment and configure it to communicate with Qlik Cloud. In Qlik Cloud with SQL Server as a target you can configure either a Replication project with a replication task. (Akin to Qlik Replicate where the data is captured via CDC from your source, delivered and applied to your target).

Alternately you can leverage a Pipeline project which supports Landing & Storage pattern. This patterns allows for a Type 2 of data to be stored in your target and for ELT (pushdown SQL) transformations.

Obviously it really depends on what you are trying to accomplish as to which type of project / task to leverage.

Re: Data Movement Gateway with source and target is on premise

TimGarrod — Thu, 27 Feb 2025 13:00:49 GMT

Info on Landing / Storage and Pipeline projects - https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Introduction/Data-projects.htm

Data Replication task info - https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Replicating/data-replication-task.htm