+ Start a Discussion

Using Schema Spy for extracting Entity Relationship Diagram from Salesforce Instance

Can some one help me how to use Schema spy for extracting ERD from Salesforce Org?

Many Thanks in advance:)

Many thanks for your reply.
I'm getting some errors while I'm trying to extract via ant.

The Small snippet of the error is as below:
[echo] Generating SFDC documentation
   [delete] Deleting directory C:\Users\chinnamv\Desktop\ERD\SFDCSchema
     [java] Failed to query Graphviz version information
     [java]   with: C:Graphviz\bin\dot -V
     [java]   java.io.IOException: Cannot run program "C:Graphviz\bin\dot": Crea
teProcess error=2, The system cannot find the file specified

Any help in resoliving this is highly appreciaed.Let me know in case you need any further information
Holger Buchner 8Holger Buchner 8
You need to add the Graphvix to the local PATH
for Windows it looks like follows: SET PATH = "C:\Program Files\Graphviz 2.8.6\bin";%PATH%
After applying this, schemaspy should be able to find DOT.exe
Niza KhungerNiza Khunger
Unable to get ERD even after using this command on CMD:

java -cp schemaSpy_5.0.0.jar;force-metadata-jdbc-driver-2.2.jar net.sourceforge.schemaspy.Main -t force -u "your username" -p "your password" -charset utf8 -font Arial -fontsize 8 -hq -norows -noads -nologo -db force -o "C:\Users\UserName\Desktop\SchemaSpy" -connprops "includes\=standard\=true;custom\=true;url\=https://login.salesforce.com/services/Soap/u/21.0" -desc "Extracted from Salesforce.com" -gv "C:\Program Files\graphviz-2.38\release\bin"