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

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,

Message Edited by msimonds on 11-07-2006 07:44 AM

Message Edited by msimonds on 11-07-2006 07:51 AM

Hi Mike -

It is indeed possible to schedule the AppExchange Dataloader (including the Linux version) to move data between 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:


one additional resource...  the open source version of the dataloader:

Message Edited by vander on 11-07-2006 09:31 AM

Thank you so much Vander, I truly appreciate it