Slow loading when using QvOdbcConnectorPackage.exe (SqlServer Connector)

[agnie_john]

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.

[SankarReddy]

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]

Hi SankarReddy,

Thanks for your response.

Let me try this.

Thanks,

John.

[agnie_john]

Hi @SankarReddy ,

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

Regards,

John.