Table of Contents
Chapter 1: Data Loader Overview.........................................................................................................1
Chapter 2: When to Use Data Loader....................................................................................................2
Installing Data Loader..............................................................................................................................................................3
Configuring Data Loader..........................................................................................................................................................4
Data Loader Behavior with Bulk API Enabled.............................................................................................................6
Configuring the Data Loader to Use the Bulk API......................................................................................................7
Uninstalling the Data Loader....................................................................................................................................................7
Chapter 3: Using Data Loader...............................................................................................................8
Data Types Supported by Data Loader.....................................................................................................................................9
Exporting Data........................................................................................................................................................................10
Defining Field Mappings........................................................................................................................................................12
Inserting, Updating, or Deleting Data Using Data Loader.....................................................................................................12
Performing Mass Updates...........................................................................................................................................13
Performing Mass Deletes............................................................................................................................................14
Uploading Attachments..........................................................................................................................................................14
Uploading Content with the Data Loader..............................................................................................................................14
Reviewing Output Files...........................................................................................................................................................16
Troubleshooting Data Loader Operations..............................................................................................................................16
Chapter 4: Running in Batch Mode.....................................................................................................18
Understanding Installed Directories and Files........................................................................................................................19
Encrypting From the Command Line....................................................................................................................................19
Upgrading Your Batch Mode Interface...................................................................................................................................20
Using the Command Line Interface........................................................................................................................................20
Configuring Batch Processes...................................................................................................................................................21
Data Loader Process Configuration Parameters.....................................................................................................................21
Data Loader Command Line Operations...............................................................................................................................29
Configuring Database Access..................................................................................................................................................29
Spring Framework Overview.......................................................................................................................................31
Data Access Objects....................................................................................................................................................31
SQL Configuration.....................................................................................................................................................31
Mapping Columns..................................................................................................................................................................33
Running Individual Batch Processes.......................................................................................................................................34
Chapter 5: Command Line Quick Start...............................................................................................36
Introduction............................................................................................................................................................................37
Prerequisites............................................................................................................................................................................37
Step One: Create the Encryption Key.....................................................................................................................................37
Step Two: Create the Encrypted Password.............................................................................................................................38
Step Three: Create the Field Mapping File............................................................................................................................39
Step Four: Create the Configuration File................................................................................................................................39
Step Five: Import the Data......................................................................................................................................................41
i
Table of Contents
