function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Dean BarnesDean Barnes 

Dataloader Oracle -> Salesforce extract

I'm sure this is obvious, but I can't find it so forgive me. But, does dataloader have to create a csv when moving data from one database to another? If not, then does anyone have an example of the required configuration files to avoid creating the csv?

Ritesh AswaneyRitesh Aswaney

Dataloader is primarily a client application, which allows you to extract data from salesforce in csv files, and upload data to salesforce from csv files.


So CSV files are in the picture, pretty much all the time. Dataloader isn't really an integration tool.

 

However, since it can be run commandline, I've known of cases where it has been hacked to serve as one - you could schedule a dataloader instance (using an OS Scheduler such as WIndows Task Manager or Unix Cron) to pull down CSV files from Salesforce, which then feed to another process (can be dataloader if uploading to Salesforce, or then a client application for your destination db)

 

Here's a good starting point for the command line config

 

http://wiki.developerforce.com/index.php/Using_Data_Loader_from_the_command_line