Apex Code Development You need to sign in to do that
Don't have an account?
msimonds Data Loader question
I wanted to see if someone on these boards could give me an answer to my question (s)!
We are currently migrating over to SFDC. Yesterday I downloaded the AppExchange Data loader and ran some tests on this application. We have some internal systems which will need to retrieve data from SFDC once we are live.
I know that the data loader can be installed via Linux but what I need to know is the following:
1) Once this is installed on Linux:
a) can it be run as batch to dump the data to a specific location on a server?
b) has anyone been successful dumping data to their own database (oracle, MySql, etc.)?
2) If this is possible, can someone point me in the right direction or post some examples of what they have done in the past to make this work?
These internal systems/teams must be able to access the data (some required tables/fields).
Thanks in advance,
Mike
Message Edited by msimonds on 11-07-2006 07:44 AM
Message Edited by msimonds on 11-07-2006 07:51 AM
It is indeed possible to schedule the AppExchange Dataloader (including the Linux version) to move data between salesforce.com and your local DB. I have done this for a few different customers now. You need to update the config files and write a script to manage the transfer (.bat for windows, .sh for unix variants). Then, schedule this script to execute using your scheduler of choice (eg cron). The current version of the dataloader does not directly connect with any databases, so you need to use .csv flat files as your intermediary. However, scheduling imports or exports of .csv files to/from your DB of choice should be fairly simple.
Here are some resources:
http://blog.sforce.com/sforce/2005/06/sforce_data_loa.html
http://blogs.salesforce.com/features/2006/03/appexchange_dat.html
-Cory
http://sourceforge.net/projects/sforce-app-dl/
Message Edited by vander on 11-07-2006 09:31 AM
Regards,
Mike