Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 lguevara
		
			lguevara
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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?
 TimGarrod
		
			TimGarrod
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
 TimGarrod
		
			TimGarrod
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
 TimGarrod
		
			TimGarrod
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Info on Landing / Storage and Pipeline projects - https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Introduc...
Data Replication task info - https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Replicat...
