Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lguevara
Partner - Creator II
Partner - Creator II

Data Movement Gateway with source and target is on premise

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?

 

1 Solution

Accepted Solutions
TimGarrod
Employee
Employee

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.

View solution in original post

2 Replies
TimGarrod
Employee
Employee

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.