Part 1: Getting Started : Advanced Features : Using DataDirect Bulk Load

Using DataDirect Bulk Load
The drivers support DataDirect Bulk Load, a feature that allows your application to send large numbers of rows of data to a database or Salesforce instance.
The following tables describe the bulk load behavior for the drivers.

1
Supports bulk load for Oracle9i R2 and higher.

2
Supports bulk load for Microsoft SQL Server 2000 and higher.

Bulk load operations are accomplished by exporting the results of a query from a database into a comma-separated value (CSV) file, a bulk load data file. The driver then loads the data from bulk load data file into a different database. The file can be used by any DataDirect Connect Series for ODBC drivers. In addition, the bulk load data file is supported by other DataDirect Connect product lines that feature bulk loading, for example, a DataDirect Connect for ADO.NET data provider that supports bulk load.
Suppose that you had customer data on a Sybase server and need to export it to a DB2 server. The driver would perform the following steps:
1.
2.
3.
4.
Bulk Export and Load Methods
Exporting Data from a Database
Bulk Loading to a Database
The Bulk Load Configuration File
Sample Applications
Determining the Bulk Load Protocol
Character Set Conversions
External Overflow Files
Using Bulk Load for Batch Inserts
Using Bulk Load for Single Inserts/Updates/Deletes (Salesforce Driver)
Summary of Bulk Load Related Options

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.