Thursday, February 5, 2009

Dataloader connection to external database(SQL Server, ect), Made Easy

Hi all:
I wanted to share my experience in connecting to an external database from command line prompt using Salesforce.com Dataloader...

So Lets Get started:
I always wonder why companies would pay outside companies to do data migration between Salesforce.com and external Database. Salesforce.com provides everything for you. All you need to do is a little bit of work. Once you get one thing running then everything else is real easy.

What you save?
Well, if you want to be ahead in your company and impress your boss then you can save them money and do the migration yourself.
Also, if they ask about could this process run nightly. Say "YES".
(If you get a raise out of this then Share it... LOL)

What you need?

  1. Most Recent Apex Dataloader. <== its free
  2. Command Prompt <== Free
  3. an Outside Database (SQL Server, Oracle, Access, etc.) <== Not free but I am thinking since you on my blog you probably have this already
  4. Notepad <== free
  5. a salesforce username and password <== Free if you are developer edition
  6. jtds. jar file <== Free as well
Wow, so the only thing you need to spend money on is the database part but everything else is free.
Thanks
Check out my Other Blogs:
VisualForce Made Easy 
Salesforce Made Easy