Features
Java application tool for handling data loading of what and who id fields for example,either a contact or a lead can be the parent of a Task and Event object.In other words, the WhoId field of a task or event can contain the ID of either a contact or a lead.
Java Application tool configure directly to any Database to upload data into salesforce org.
Entire Data loading process is automated by java application tool.
Help
If you experience any problems mapping relationships for polymorphic fields like What/who id , please let me know! I'm glad to help.
If you want to reach me, my email is priyadhiraj@gmail.com.
Thanks!
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!
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!
Subscribe to:
Posts (Atom)