SDDC is a Windows desktop application that can very rapidly create a Data Dictionary or Field Map based on objects you select from your Salesforce.com org. It is primarily designed to be useful for administrators, developers, and consultants, who may be working on a Salesforce.com configuration, application, data migration, or integration.
The three step wizard is fast and intuitive, allowing you to save your export settings at each step along the way, and switch between object sets and configuraitons easily. After generating the export you want, subsequent exports can occur in just 3 clicks (< 20 seconds).
There are two primary export styles: the Data Dictionary is geared towards administrators and developers; and the Field Map adds additional formatting and formulas to aid data migration and integration resources. For either export option, you may also choose to condense all objects into a single Schema tab.
Please note, for the Field Map style export screenshot, columns J, K, L, and N are blank when the export is created. This screenshot shows an exmaple of what a field map might look like while being actively worked on: mapped fields on top, unmapped fields on bottom, clear divider in the middle with room for from / join / where clauses; field mappings added to columns J and K; mapping instructions in column L; and raw SQL code in column N.
Field filters allow you to exclude fields from export, matching by field name for all objects, or field + object name, or based on read/write status against standard, custom, or managed fields. Various other tabs give you an excellent view of the data model, including a tab showing a high level object summary, as well as a tab displaying all record types and picklist values.
Many other automation features increase the speed at which you can export a field map or data dictionary, including type-search for objects (to find and select objects more quickly), saving credentials for auto-login (salted AES encryption), and saving object sets (useful for switching between multiple orgs or projects).
There are many enhancements that I plan on adding that should make SDDC even more useful. The current priority list looks something like this:
If there is something that you wish SDDC could do that isn't on this list, please let me know on the About page! We may be able to squeeze it in, just for you!
Latest version: 1.03
Portable installation. Extract all files to a directory (eg, c:\Program Files\SDDC) and create a shortcut to the exe on your desktop.
SDDC currently only works in a Windows environment. It can be run without a license, but will not be able to export any spreadsheets.
Full version history and program notes can be found in the about.txt file.