Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sachin10Sachin10 

Using Schema Spy for extracting Entity Relationship Diagram from Salesforce Instance

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

Many Thanks in advance:)



OnpursuitOnpursuit
http://developer.force.com/codeshare/apex/ProjectPage?id=a0630000006KXemAAG
Sachin10Sachin10
@Onpursuit,
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"