Ask Wendy

Ask Wendy

Ask Wendy - February 2007

  • View Your SFDC Data Schema or Entity Relationship Model

    Wendy Close Feb 2, 2007

    Recently an application support analyst from a salesforce.com customer asked for an application where one can easily view and print one’s current salesforce.com Data Schema or Entity Relationship Model.  Four solutions come to mind:

    1. Developers’ Sidekick by Upside Outcomes is a free client app that instantly displays the objects and attributes of your salesforce.com schema. Handy for developing custom apps or designing reports.

    2. Sforce Explorer is a .NET and Partner API based executable that provides a simple user interface for testing SOQL queries and browsing your salesforce.com data model. Source is included with the download. Requires .NET Framework 1.1 or later.

    3. SnapShot by Dreamfactory allows an account administrator to take a picture of the current state of the customizations in their salesforce.com org and track all changes over time, between different accounts, or between different user profiles.

    4. Simon Fell’s Soqlx (for Mac only). It also allows for export to PDF and has a nice graphical schema explorer.

        Take a look and let community know which one you like best. Have a CRM question? Askwendy@crmsuccess.com.