Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
agnie_john
Partner - Contributor II
Partner - Contributor II

Slow loading when using QvOdbcConnectorPackage.exe (SqlServer Connector)

Hi,

I am trying to connect sqlserver using qlik connector for sqlserver (QvOdbcConnectorPackage.exe)

It takes long time to load data.

The same table is loaded fast when using ODBC connetion type.

 

ODBC Connection Type                                                         :     28 min to load Type : ODBC

Connection String : ODBC CONNECT TO [GlobalDB;]

 

SQLConnector (QvOdbcConnectorPackage.exe)       :    110 min to load

Type : QvOdbcConnectorPackage.exe
Connection String : CUSTOM CONNECT TO "provider=QvOdbcConnectorPackage.exe;driver=mssql;host=xxx.xx.x.xx;port=1433;database=GlobalDB;Encrypt=false;TrustServerCertificate=false;Min_TLS=1.2;Trusted_Connection=false;Use_NTLM=false;Integrated Security=false;allowNonSelectQueries=false;EnableQuotedIdentifiers=1;ReturnSpecificTypeAsOdbcType=yes;"

 

but as i requirement i need to use SQLConnector (QvOdbcConnectorPackage.exe)  .

Is there any setting to boost the performance?

Thanks,

John.

3 Replies
SankarReddy
Support
Support

Hi @agnie_john 

Can you please try to change the ODBC connector package config file strategy to the engine and then check.

<add key="mssql-reading-strategy" value="engine" />

Folder Path: C:\Program Files\Common Files\QlikTech\Custom Data\QvODBCConnectorPackage

Best Regards,

Sankar Reddy K.

agnie_john
Partner - Contributor II
Partner - Contributor II
Author

Hi SankarReddy,

Thanks for your response.

Let me try this.

 

Thanks,

John.

agnie_john
Partner - Contributor II
Partner - Contributor II
Author

Hi @SankarReddy ,

I tried with your solution.but there is no improvement.Is there anything i need to change in the configuration?

 

Regards,

John.