You need to sign in to do that
Don't have an account?
lovecrm
How to extract data from sfdc using commandline on weekly basis to a particular folder.
Hi All,
Iam in need of extracting related data from 4 diff objects of SFDC on weekly basis and send it to FTP.
Can anyone of you know how to approach with this.
Can we schedule extracting data on weekly/daily basis from SFDC using ANT tool.
We are having Autosys Job scheduling tool.
So, If i can extract files from SFDC to a local folder on weekly basis then i can use autosys tool to get that files and through query map those and send the data to FTP.
Any information/suggestion to approach would be appreciated.
Thankyou in advance.
carol.
Hello,
You can use a scheduled batch to extract and send to a FTP server.
The batch should use the DataLoader in command line to extract the information from SalesForce to a folder in CSV files
the second part of the batch could transfer those files by FTP.
Thankyou...
Here after extract ,the data need to be mapped as there are from 5 different objects.
I get data from Opp's, Visit, VisitOpp's and these are having relations which to be mapped and then from the User object need to get the names for createdBy and ModifiedBy fields.
can we do all these in the second part of the batch?
If so, can you please detail me how to do the scheduled batch.
Or can I find any information how to work with batch anywhere?
Thankyou,
carol.
If your datamapping tools accept command line, it could be part 2 of the batch file.
A batch file is a .BAT file.
Ift could be something like that
@echo off
PUSHD "C:\Program Files\salesforce.com\Apex Data Loader 15.0\bin\"
CALL process.bat ..\MyConfFolder MyBeanToExecute
Call mapping tool with command line
Call FTP script to export your result in the FTP server