2

We have a data management group who need to review data structure since they are usually tasked with any historical data conversion/cleanup for any apps that move to Salesforce.

They asked for access to Schema Builder to easily see the structure and relationships after they had heard about this tool.

Apparently you have to grant "Customize Application" to enable Schema Builder for their account, this is kinda crazy due to the privileges they receive. So, I'm really not wanting to do that.

I noticed there is a "Idea" out there around this, but has fairly low votes, so an official change is probably years away..

My question is what alternatives has anyone in the same boat used to allow the same easy visual access to the object structure? Without giving them the keys to the kingdom, ideally.

1

If the use case is to view the schema (As I understand from your question), you can install one of the many apps from AppExchange and provide the team access for that.

The one app I can find is ERD TOOL. It gives schema builder type UI.

I am not affiliated with this tool and I am not the developer for this tool. I recommend this as it is recommended by SFDC product management.

Idea Exchange

| improve this answer | |
1

Not sure about what profile settings are required to run this as I usually use an SA account, but it basically uses describe calls to pull out the information thand then uses SchemaSpy to format the information. See SchemaSpy Org ERD for links.

| improve this answer | |
  • 1
    It required API User privileges. I tried it on a behind proxy corporate network. It also requires graphwiz and Apache ant and JDBC driver. It's somewhat difficult to setup for someone who had never used ant and command line and is behind a proxy. However it's a really good tool and gives detailed information. – manjit5190 Oct 3 '15 at 4:52
0

There are some third party tools that might help. Safyr from Silwood Technology uses the SFDC Metadata API to access the Objects in an Org and can then present the objects in Data Model form in a number of different formats.

I believe Grandite Silverun also has some kind of capability that gives data models

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.