Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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