ER/Studio 4.0 Accelerates Database Modeling

Embarcadero Technologies Inc announced the availability of ER/Studio 4.0, a major upgrade to its advanced modeling environment that offers advanced parser-based support for stored procedures and triggers and an automation interface for user-customization.

ER/Studio 4.0 introduces new interfaces for even easier database model browsing and editing, and the ability to create stored procedures and triggers. Users can create stored procedures and triggers in their native DBMS languages (including PL/SQL and Transact SQL) or they can create template versions for drag-and-drop reuse. ER/Studio 4.0 contains parser-based technology that ensures consistent and accurate stored procedure and trigger object dependency for tables, views and other procedural logic.

This new version of ER/Studio also introduces the ability to expand upon its own functionality through a new automation interface. By creating Sax BASIC commands (a VBA-like language) in ER/Studio's new macro scripting UI, users can tap directly into ER/Studio's own object model to expand existing functionality and create entirely new functionality. The Automation Interface can be used to create operations internal to ER/Studio such as automating repetitive tasks, or between ER/Studio and virtually any other database or application environment with an exposed API or like automation interface.

"ER/Studio's automation interface is the exact flexibility we've been requiring in data modeling tools," said Todd Palmer, developer at CallCenter Technology. "Our product interacts with multiple heterogeneous enterprise data sources, and we have a lot of complex requirements when designing our data models. We needed a way to automatically generate and enforce them through our modeling tool of choice. ER/Studio's Automation Interface not only provides us the interface to customize the tool for our specific needs, but completely automated the routine labor needed to enforce it. No other database modeling product enabled us to get this done as quickly and exactly the way we required it."

"Creating ER/Studio's underlying parser technology was a substantial development undertaking but it will return huge productivity dividends for our user base," said Gregory Keller, ER/Studio product manager. "ER/Studio 4.0 users can not only automatically preview the impact of suggested changes to their stored procedures and triggers, but can also rely upon ER/Studio's parsers to ensure changes are propagated to any dependent objects. This delivers enormous time savings when table or column references are located in hundreds of procedures or triggers."

ER/Studio System Requirements and Database Support

ER/Studio 4.0 runs on Windows 95/98/NT and Windows 2000. Notational and method support includes IDEF1X, James Martin's IE (crow's foot) and Filtered IE (designed to hide foreign keys). ER/Studio supports a variety of desktop and SQL databases including; Oracle 7.3, 8 and 8i, Sybase 11.x, Informix SE and online, Microsoft SQL Server 6.5 and 7.0, IBM DB2 and IBM DB2 Universal Database, SQL Anywhere 5, Watcom 4, InterBase 4.x, Access 2.0, 95, 97 and 2000, and Visual FoxPro. ER/Studio 4.0 is available immediately from Embarcadero Technologies and authorized international distributors, and is priced at $2,495. Customers on annual maintenance receive the new release free of charge.

About Embarcadero Technologies

A privately held San Francisco-based company, Embarcadero Technologies produces an innovative Database Lifecycle Management solution that assists in simplifying and automating the design, development, and administration of critical enterprise and Web-to-database applications. Thousands of major companies, including 75 percent of the Fortune 100 and half of the 10 mostvisited Web domains, rely on Embarcadero products to maximize database performance and availability. For more information, visit www.embarcadero.com.

Contact Embarcadero Technologies Sylvia Sheehan, 415-834-3131 Sylvia.Sheehan@Embarcadero.com.