topic Re: Slow loading when using QvOdbcConnectorPackage.exe (SqlServer Connector) in Connectivity & Data Prep

Slow loading when using QvOdbcConnectorPackage.exe (SqlServer Connector)

agnie_john — Mon, 11 Apr 2022 04:56:50 GMT

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.

Re: Slow loading when using QvOdbcConnectorPackage.exe (SqlServer Connector)

SankarReddy — Mon, 11 Apr 2022 05:01:05 GMT

Hi @agnie_john

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

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

Best Regards,

Sankar Reddy K.

Re: Slow loading when using QvOdbcConnectorPackage.exe (SqlServer Connector)

agnie_john — Mon, 11 Apr 2022 05:02:34 GMT

Hi SankarReddy,

Thanks for your response.

Let me try this.

Thanks,

John.

Re: Slow loading when using QvOdbcConnectorPackage.exe (SqlServer Connector)

agnie_john — Mon, 11 Apr 2022 08:49:44 GMT

Hi @SankarReddy ,

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

Regards,

John.