Load Data sql server Saas

[fkeuroglian]

Hi experts

I have a simple select * from sql table.

If i connect using ODBC connection to sql server, 2Million of records load in 51 seconds BUT if I load from qlikSaas using SQL SERVER CONNECTOR, the same table 2Millions records, load in 55 MINUTES. 

Same table, same records, same user, same everything! 

I have a public IP, that connect with the database server with Sass.

What you recommend using QLIK DATA TRANSFER installed in the local server where is the database and connect via ODBC?

Thanks a lot

[JordyWegman]

Hi,

Yes, that is because you're depended on your internet connection. I suggest to connect indeed via QDT and push the data to Qlik Sense SaaS. This way faster while it can upload the QVD at once.

Jordy

Climber