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
redwood739redwood739 

Stored Procedure/ Apex data loader command line

We need to extract data from our database (sql server) and load it into SF. Does anyone know if we can use stored procedures in the config file for running the data loader on the command line? 

 

Thanks much 

sfdcfoxsfdcfox

Have you tried to do this already? I would imagine that you would need to use the SQL Query Bean configuration, and just replace the SELECT statement with a suitable CALL statement. In theory, this should work just fine, but I don't have the time right now to test this out.

abhisheksharmaabhisheksharma

I am wondering if you have figured out a way of calling stored proc from data loader CLI. I am trying similar thing but not sure how...

 

Thanks.