Comprehensive solution for crafting and managing sophisticated digital experiences
Build engaging websites with intuitive web content management
Leverage a complete UI toolbox for web, mobile and desktop development
Build, protect and deploy apps across any platform and mobile device
Build mobile apps for iOS, Android and Windows Phone
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
Automate UI, load and performance testing for web, desktop and mobile
Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud
Optimize data integration with high-performance connectivity
Automate decision processes with a no-code business rules engine
Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation.
Globally scale websites with innovative content management and infrastructure approaches
Content-focused web and mobile solution for empowering marketers
Faster, tailored mobile experiences for any device and data source
UX and app modernization to powerfully navigate today's digital landscape
Fuel agility with ever-ready applications, built in the cloud
Five steps to simplify Salesforce ER diagram extraction using the Visio Reverse Engineer function and the DataDirect driver.
Though it may not be its sexiest feature, Salesforce has a powerful Schema Builder tool that can be used to format complex entity-relationship (ER) diagrams. Unfortunately, accessing these diagrams from outside of Salesforce—in a program like Visio, for example—can be a major struggle. The status quo for this sort of operation involves numerous tedious and inefficient steps that lead to frustration and wasted time.
Fortunately, there is another way. The process of ER diagram extraction is greatly simplified with our Progress® DataDirect® Salesforce driver in conjunction with the Visio Reverse Engineer function. NOTE: This ONLY applies to Visio 2010 since Microsoft deprecated their Reverse Engineering function with Visio 2013.
I recently demoed this solution to some customers of ours. I thought the information was too good not to share, so this week I’m walking you through the simple, 5-step process.
Before you begin, download and install the DataDirect for ODBC Salesforce Driver. Make sure the version of the driver you use matches your version of Visio—for example, a 32-bit Visio installation requires the 32-bit DataDirect driver. After the driver is installed, open the ODBC Administrator tool and establish your connection to Salesforce.
Now, just open up Visio and follow these steps!
Select "Software and Database" from the template category options.
Next, select "Database Model Diagram"
Select the "Reverse Engineer" tool from the "Database" tab.
Options will match those created in the DataDirect ODBC Administrator Tool
Select all relevant object types.
Select all tables needed.
When prompted, choose to add shapes now.
Check final selections for accuracy.
A complete ER diagram, successfully imported from Salesforce.
And just like that, the ER diagram from the Salesforce Schema Builder has been imported to Visio, ready to be worked with. As you can see, the DataDirect for Salesforce ODBC driver does ALL of the work for you!
Let me know how this works out for you. And, of course, we’re here for any questions you may have. Just leave a comment below or contact sales now. And when you’re ready to start leveraging the full power of Salesforce and DataDirect, download a free trial and get started today!
Idaliz is a Sales Engineer with Progress. After receiving her undergraduate degree from Duke University in Civil and Environmental Engineering, Idaliz Baez spent a year at NASA Goddard Space Flight Center gaining on-the-job experience before returning to Duke in pursuit of her Masters of Engineering Management degree.
Copyright © 2016, Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.