N. America: (800)876-3101 | World: +44 (0) 1-344-386-367

ODBC Driver Bulk Load

Advantages of DataDirect ODBC Drivers


See Larger Image

The Progress DataDirect Connect for ODBC driver includes an advanced Bulk Load feature for inserting very large numbers of records into a database as quickly as possible. Our ODBC drivers:

  • Deliver the most reliable bulk load execution and best performance
  • Requires no application code changes or database vendor tools
  • Employ standards-based APIs across multiple databases and platforms

With the the DataDirect Bulk Load feature, enterprise organizations effectively satisfy connectivity requirements for a broad array of bulk load data access use cases. In doing so, they simplify the data access architecture; save important resources for other tasks; and improve operational performance.

The DataDirect Bulk Load feature delivers the fastest performance for inserting mass amounts of data into a database. DataDirect conducted a range of performance trials including comparing our own drivers against themselves when Bulk Load is enabled vs. disabled. Also, the DataDirect Bulk Load feature offers an array of value-add benefits when compared to competitive drivers.




The DataDirect ODBC Driver Bulk Load feature consists of two distinct, yet related types of bulk operations:

  • Importing bulk data into a database
  • Exporting bulk data from a database

Importing Bulk Data


See Larger Image

Exporting Bulk Data


See Larger Image

Each type of bulk load operation can use multiple sources of input, can be invoked in a variety of ways with the driver, and supports different output destinations. Moreover, the DataDirect Bulk Load feature provides an array of advanced functionality that ensures superior performance.

ODBC Driver Bulk Load Import

Input Source

  • External CSV (comma separated value) file
  • Parameter array insert operation within an ODBC application
  • A result set from any fetch operation (also known as “streaming”)

Invocation Methods

  • Execute via standard ODBC API calls for parameter array batch operation
  • Execute via DataDirect ODBC API extensions
  • Execute via driver Setup dialog

Output Destinations

  • A table within an Oracle, DB2, Sybase, or SQL Server database

ODBC Driver Bulk Load Export

Input Source

  • From a table in an Oracle, DB2, SQL Server or Sybase database
  • From a result set fetched from an Oracle, DB2, SQL Server or Sybase database

Invocation Methods

  • Execute via DataDirect ODBC API extensions
  • Execute via driver Setup dialog

Output Destinations

  • External CSV (comma separated value) file