topic Re: BulkReading ODBC Connector in Connectivity & Data Prep

BulkReading ODBC Connector

Necator — Mon, 04 Dec 2023 09:16:52 GMT

Hello,

I found this article about useBulkReading on ODBC Connectors after October 2022. I just recently patched from May 22 to August 23. So now the BulkReading should be in place, but I didn't experience any load speed increase especially for big datasets. Is there anything else I need to do besides updating and re-saving the data connection?

Also I couldn't find the Advanced Tab on the ODBC Connection, where does this reference to in the article ?

Re: BulkReading ODBC Connector

TcnCunha_M — Mon, 11 Dec 2023 15:29:31 GMT

are you making full load , month load,

maybe do some delta load can help you

Re: BulkReading ODBC Connector

Necator — Mon, 11 Dec 2023 15:35:20 GMT

I found the data connection in the meantime, and also could distinguish a difference with bulk reading and none. Sadly it is still very slow for big data loads, but that seems to be a general ODBC issue. Topic can be closed.