article Qlik Sense ODBC database connector performance increase: useBulkReader in Official Support Articles

Qlik Sense ODBC database connector performance increase: useBulkReader

Sonja_Bauernfeind — Fri, 05 May 2023 07:43:56 GMT

Qlik has introduced an update with Qlik Cloud and Qlik Sense Enterprise on Windows which significantly increases the performance of any ODBC database Connector when working with larger datasets.

The change was rolled out to Qlik Cloud in October 2022 and is available in any Qlik Sense Enterprise on Windows version beginning November 2022.

All new connections automatically have a Bulk Reader feature that uses larger portions of data in the iterations within a load (instead of loading data row by row). This can result in faster load times for larger datasets.

To add this feature to an existing connection, open the connection properties window by selecting Edit and then click Save. The Bulk Reader feature is now turned on. You don’t have to change any connection properties to invoke this feature.

While we believe that most customers will want all their ODBC connections to use this new capability, it is possible to turn off the Bulk Reader feature for a particular connector. To do this, add the parameter useBulkReader with a value of False to the Advanced section of the connector properties window.

Environment

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Re: Qlik Sense ODBC database connector performance increase: useBulkReader

Mimiek — Tue, 19 Dec 2023 12:38:55 GMT

Dear Sonja,

In Qlik Cloud SAAS I'm getting the error 'Invalid string or bugger length'. I did some research online and found articles where people put the cause of the error message at the 'Reload Optimization' option.

I read that there is a specific option: useBulkReader=false that needs to be entered under the advanced properties, but this is where I get stuck.

My Qlik Saas ODBC (via Direct Access Gateway) connector has no advanced properties so I cannot enter useBulkReader=false anywhere.

Do you perhaps have an idea or tip by which I am still able to retrieve data and get rid of the error message.

Thanks in advance.

Peter

Re: Qlik Sense ODBC database connector performance increase: useBulkReader

Sonja_Bauernfeind — Tue, 19 Dec 2023 13:21:27 GMT

Hello @Mimiek

Please contact our support through chat to get more direct assistance for this.

All the best,
Sonja

Re: Qlik Sense ODBC database connector performance increase: useBulkReader

cjgorrin — Thu, 11 Apr 2024 10:58:55 GMT

Hi there,

Please, be aware that this feature combined with PostgreSQL causes strings to be cut to 255 characters.

If you turn the bulk load off, strings are not cut, at least in version May 2023 Patch 9.

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-PosgreSql-connector-cut-off-strings-containing-more/ta-p/2123526

article Qlik Sense ODBC database connector performance increase: useBulkReader in Official Support Articles

Qlik Sense ODBC database connector performance increase: useBulkReader

Environment

Related Content

Re: Qlik Sense ODBC database connector performance increase: useBulkReader

Re: Qlik Sense ODBC database connector performance increase: useBulkReader

Re: Qlik Sense ODBC database connector performance increase: useBulkReader