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.
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.
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.
