Embarcadero ER/Studio Outperforms CA ERwin in Head-to-Head Product Review

Share Article

Real results achieved with ER/Studio two to three times faster than with ERwin.

application development apps IDE native code

Embarcadero Technologies

We encounter a large number of long-term ERwin users who are frustrated with their experiences.

In a comparison product review conducted by an independent party, Embarcadero ER/Studio was selected as a superior enterprise data modeling tool to CA ERwin. The evaluation found that ER/Studio’s intuitiveness, navigation capabilities and ease-of-use surpass ERwin’s, enabling key tasks to be completed two to three times faster with ER/Studio than with ERwin, and shortening the learning curve for new users.

The comparison review, which was conducted in March by DBA and industry consultant Seán Francis, evaluated ER/Studio 9.0.1 against ERwin r8 across five categories: installation & configuration, ease of use, features, performance and product support. An Oracle database backend was used for the testing. The entire review can be viewed at http://bit.ly/erstudioerwinreview.

Francis assessed the tools’ ease of use, features and performance using a set of 10 tasks commonly performed by data management professionals. ER/Studio eclipsed ERwin in seven of the 10 tasks, earning significantly higher marks for its reverse engineering, schema comparison and native object type support capabilities. The tools tied in the area of impact analysis, and were closely matched in the installation & configuration and support categories.

“We encounter a large number of long-term ERwin users who are frustrated with their experiences and looking to upgrade to ER/Studio, so this review validates what we’re hearing and seeing,” said Jason Tiret, director of modeling and architecture solutions for Embarcadero. “By delivering unique features like the enterprise data dictionary, data lineage and a web-based portal, none of which you’ll find with ERwin, we’re meeting our users’ needs for holistic data management, rather than just data modeling.”

According to Francis, on average, it took two to three times longer to achieve the same results in ERwin as it did in ER/Studio. The fundamental reason was the user interface. Because ER/Studio is intuitively easier to learn and navigate, it makes users more productive.

About the Reviewer
Seán Francis has worked in the IT industry since 1989, and has been a database administrator since 1990, specializing in Oracle. He has also worked with SQL Server, Sybase and Watcom SQL/SQL Anywhere Studio. His experience with CASE/data modeling tools dates back to Oracle’s original CASE tools. Over the years, Francis has worked extensively with Oracle Designer, as well as with LBMS Systems Engineer, CA ERwin, Quest Toad Data Modeler, Embarcadero ER/Studio and Oracle SQL Developer Data Modeler. He has consulted for many U.S.- and UK-based companies, ranging from large multi-national corporations to small companies with few IT staff. Francis holds Oracle Certified Professional DBA certifications for Oracle database versions 7.3 through 11g, and he is currently studying for MCTS and MCITP SQL Server certifications.

About ER/Studio
ER/Studio XE is a design and modeling solution for enterprise information architecture. The tool allows data management professionals to build and maintain enterprise-scale databases and data warehouses. Using its built-in facilities that automate routine modeling tasks, users can analyze and optimize database and data warehouse designs faster. With a server-side model management system and online portal, it is a highly productive way to share, document and publish data models and metadata to distributed teams.

About Embarcadero Technologies
Embarcadero Technologies, Inc. is a leading provider of award-winning tools for application developers and database professionals so they can design systems right, build them faster and run them better, regardless of their platform or programming language. Ninety of the Fortune 100 and an active community of more than three million users worldwide rely on Embarcadero products to increase productivity, reduce costs, simplify change management and compliance and accelerate innovation. Founded in 1993, Embarcadero is headquartered in San Francisco, with offices located around the world. Embarcadero is online at http://www.embarcadero.com.

Embarcadero, the Embarcadero Technologies logos and all other Embarcadero Technologies product or service names are trademarks or registered trademarks of Embarcadero Technologies, Inc. All other trademarks are property of their respective owners.

# # #

Share article on social media or email:

View article via:

Pdf Print

Contact Author

Rebecca Scanlan
Chase Communications
(303) 733-0328
Email >
Visit website