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

Connect for JDBC Driver Bulk Load

Progress DataDirect Connect for JDBC drivers include an advanced Bulk Load feature for inserting very large numbers of records into a database as quickly as possible. Our JDBC 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

Offering a dramatic improvement over the bulk loading limitations of Type 4 JDBC drivers, the DataDirect Type 5 JDBC Bulk Load feature offers the fastest performance for inserting mass amounts of data into a database via JDBC batch operations. 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.

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 JDBC 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

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

JDBC Driver Bulk Load Import

Input Source

  • Table in a DB2, Oracle, SQL Server, or Sybase database
  • JDBC batch within a Java application
  • External CSV (comma separated value) file

Invocation Methods

  • Standard JDBC batch execution
  • DataDirect JDBC API extensions

Output Destinations

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

JDBC 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

  • DataDirect JDBC API extensions

Output Destinations

  • A table within an Oracle, DB2, Sybase, or SQL Server database
  • External CSV (comma separated value) file