function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
PallavDPallavD 

How to extract data from SQL server using Apex command line data loader?

Hi All,

 

I have a requirement where in I need to pull some data from a external SQL data base and push it through to SQL object using Apex command line data loader. I have a very little understanding of how the command line data loader works. Could you please provide me with the understanding/ code snippet on how to connect to sql and pull data from it? Also, what all things that needs to go in database config XML file and what all things that needs to go to Process- config XML file.

 

 

You help is much appriciated.

 

Thanks and regards,

 

Pallav

Pradeep_NavatarPradeep_Navatar

Please refer :

 

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


https://na1.salesforce.com/help/doc/en/salesforce_data_loader.pdf 

 

Read page 28 onwards. Connectivity and sql configuration is properly defined in this pdf.


Hope this helps.

URVASHIURVASHI

Hi pradeep,

The above links you provided doesnot exist.

Please provide the new links.