Examples for Bulk Inserts

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
davephillips
Posts: 2
Joined: Sun 11 Aug 2019 15:42

Examples for Bulk Inserts

Post by davephillips » Wed 13 Nov 2019 01:37

Hi, I'm using the Quickbooks ODBC driver and have just found out about the Quickbooks API throttling requests. I've been instructed to do bulk updates. I'm needing to insert about 150-200 rows of data for each connection and currently, that is too many for QB API.

Does anyone have any examples of bulk updates and how it might be submitted? I don't even know where to start and couldn't find anything in the devart Quickbooks ODBC documentation on how to do it.

Thanks!

Dave

MaximG
Devart Team
Posts: 1441
Joined: Mon 06 Jul 2015 11:34

Re: Examples for Bulk Inserts

Post by MaximG » Thu 14 Nov 2019 15:09

Thank you for your interest in our products. Our ODBC driver, like any other ODBC driver, is a library of functions that conform to Microsoft ODBC standard. For example, to work with bulk API, our driver implements the following specifications:

https://docs.microsoft.com/en-us/sql/od ... erver-2017
and
https://docs.microsoft.com/en-us/sql/o ... erver-2017

Howerver, the usage of these functions is defined by third-party tools that you use with our driver. Therefore, for questions about support for specific features, please contact the developers of third-party tools.

Post Reply