Qlik Data Gateway Direct Access vs Data Movement

[mgranillo]

Can someone explain to me the main difference between Data Gateway Direct Access and Data Gateway Data Movement? Is it that one pulls data (direct access) vs. pushes data (data movement)?

[Daniele_Purrone]

Hi @mgranillo ,

Data Movement is basically to move on premise data into a cloud data warehouse (Amazon, Google, and so on) or to Qlik Cloud in the qvd format. So, we consider it as part of the Data Integration offering.
Direct Access is basically to fetch data from on premise and load it into a Qlik Sense app. We consider it part of Data Analytics. 

I hope this clarifies it!

[mgranillo]

@Daniele_Purrone Thank you for the response.  Will Data Movement convert tables into QVDs and do we need to purchase the data integration product to utilize Data movement? 

Also for anyone else reading this, this is the video that shows Data Movement in action: https://www.youtube.com/watch?v=rKvwuZcYc0U&t=19s

[Daniele_Purrone · Accepted solution]

Hi @mgranillo ,

the answer is “yes to both”. 
One of the purposes of data integration is to “Create ready to consume datasets in a cloud data warehouse, or in Qlik Cloud, from the data copied by the landing data task.”

The gateway facilitates that when the database is on a client managed environment.
However, if you’re purpose is only to have data from client managed to a qvd in Qlik Cloud, you might be able to achieve that without Data Integration, by using the “Access” gateway to load the data into a Qlik Sense app that will then STORE it in Qlik Cloud.
Data integration allow to simplify this process, but also has many other features that are specific to that suite. 

[RenzoFantini]

Good morning gentlemen/experts,

a very simple question about it.

Since my company moved to cloud on July 24 and since we signed a capacity (50GB) contract, I would like to rise a question: Is data movement the best toll to generate QVDs from an on-prem DWH since it does not have a double (byte read from DB + total generated QVDs weight) impact on capacity consumption?
Atm we have "installed" 3 servers:

• Data Gateway Direct access: we used it only to load only small table and to write back on our DWH on prem server.
• Data Transfer: we used it to load heavy table.
• Data Gateway Data Movement:
  Since Data Gataway Direct access is a stand alone product (cannot be integrated with any ETL tool) we decided to move all QVDs generated by Data Transfer to Data Movement.

Is it a correct approach and direction?
Many thanks,