Friday, February 18, 2011

Automation Tool for Salesforce Data Loader Command Line Interface

System Overview

The Salesforce Data Loader Command Line Interface (CLI) is a powerful tool for automating business processes, and integrating Salesforce with other systems. However, writing process-conf and database-conf to configuring the CLI is daunting, especially for first-time users. Automation Tool is the solution!

Automation Tool provides a simple wizard to create directory structures and generate configuration files i.e. process-conf.xml and database-conf.xml with complete code for the Salesforce Data Loader Command Line Interface. You can spend hours or days or some time week to write process-conf and database-conf files manually, or use Automation tool and you will have a working process and database conf file in less than 5 minutes. After creating a CLI configuration file, you can reference the Data Loader documentation and make adjustments as needed.

Features

Main features of Automation Tool include:
1.Generate process-conf and database-conf files.
2.Write SOQL statements (for Insert, Update, Upsert , Delete and Exports) - no need to know how to write SOQL.
3.Write SQL statement (for to and from a relational database, such as Oracle or SQL Server, that has a standard JDBC driver)-no need to know how to write SQL.
4.Configure Data Loader to write directly to Databases.
5.Automatically configure SDL file.
6.Quickly configure scheduled exports/updates/insert/upsert for your Salesforce Org
7.Text and graphical interface
8.Handles all the tricky stuff:
a.Creates a process-conf.xml
b.Creates a database-conf.xml
c.Validates your username/password, queries, and entity names (avoids case- sensitivity issues)
d.Creates a bat file which can be scheduled on Windows using Windows Scheduler.
9.Written in Java - Tested on Windows!

Help

If you experience any problems writing process-conf and database-conf files, please let me know! I'm glad to help.

If you want to reach me, my email is priyadhiraj@gmail.com.

Thanks!