Using Dataloader for simple data integrations

Setting up data integrations in Salesforce shouldn’t be hard to do…

sfdataloaderHere’s a winning trio that solves the challenge:, the Apex Data Loader and CLIq!

Salesforce administrators often need to import information from other sources or systems. If it is a simple import, you could get away with the Import wizard in Salesforce or you could use the Apex DataLoader wizard interface. But if you want to implement a repeating migration (aka an integration) you will need a more sophisticated method. There are tools in the AppExchange that cost money, but you can also use what is called the Command Line Interface of the free Apex DataLoader.

In stark contrast to the ease of using the Data Loader wizard, the command line interface is much more difficult to setup. Unless you are a fairly technical person you will likely need someone in your IT department to help you with it. Of course they are not always available on your schedule. This is where the free CLIq comes in to help. This tool creates a wizard like approach to setting up the files needed for the Data Loader Command Line interface to work. You simply install the Apex Data Loader on you PC. Then you download and unzip the CLIq tool. After a little bit of reading (or watching the video) you will be creating automatic integrations from CS files as well as SQL and ORACLE databases.

As you will see here, the ratings for this add-on are very good. When you are ready to get started, just visit the Google Code share page for the CLIq tool here.


One thought on “Using Dataloader for simple data integrations

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s