Furthering the company's commitment to solving enterprise data management problems through the use of model-driven technology, Embarcadero Technologies, Inc., a provider of data life cycle management solutions, announced the availability of ER/Studio 6.5 and ER/Studio Repository 3.0.  This major release of the product line provides a new and progressive feature set focused on enterprise metadata and dimensional modeling analysis, design and management.  With ER/Studio 6.5 and ER/Studio Repository 3.0, companies can optimize investments made in their IT infrastructures, improve staff productivity, and through advanced metadata exchange capabilities, leverage models for data integration, business intelligence and reporting applications."With the explosion of corporate data and its ever-increasing complexity, ensuring data consistency and reuse in the design phase is paramount in formulating a standardized enterprise data management practice," said Stu Carty, founder and principal, Gavilan Research Associates. "Embarcadero's emphasis on solving data management problems through effective model-driven approaches allows organizations to reduce the time between conception and implementation of their enterprise applications."

Embarcadero ER/Studio and its collaborative server ER/Studio Repository provide data architects, database administrators and developers a powerful, multi-level data modeling application for logical enterprise data analysis and physical database design and construction. Over 50 powerful new and unique features have been built into ER/Studio 6.5 and ER/Studio Repository 3.0. These features support three key advances in the product offering:

  • Comprehensive business intelligence/dimensional modeling support
  •  Simplified enterprise meta data analysis and management support
  •  Significant model-driven database performance tuning assistance

"ER/Studio makes it easier to understand the current state of data throughout our organization," said John Prout, senior Oracle DBA, Ambassadors, a leading provider of event portfolio management solutions. "ER/Studio 6.5 represents a significant value-add in how we see and leverage our data models by giving us much greater interplay between our business intelligence applications, meta data repositories and other major ETL environments."
"Survey any of the nearly 11,000 companies that use our products and they'll tell you the problem isn't data collection, it's the ability - or inability - to harness its growth to make their data work for them," said Greg Keller, director of enterprise modeling solutions, Embarcadero Technologies. "ER/Studio 6.5 helps our customers simplify the documentation and communication of the baseline state of their data to leverage it for critical application development, integration, and reporting needs. More importantly, it enables them to look down the road for what their corporate data 'should be' across the data life cycle to ensure it is more effectively managed and utilized as their business grows."

Highlighted new product features and capabilities include:

  • With bidirectional import and export interfaces to environments such as Business Objects, IBM DB2 Cube Views and others, metadata importation, visualization, standardization and exportation are now simplified through ER/Studio's "MetaWizard."
  • Identification and traceability of data used across disparate systems in the enterprise is simplified through ER/Studio's unique "Where Used" implementation. 
  • Dimensional modeling design and communication used in the creation and population of OLAP systems, data warehouses and data marts is simplified with ER/Studio's new Dimensional Modeling environment.
  • Database performance tuning, through an array of denormalization assistance wizards, now make the chore of optimizing database design simplified and efficient while ensuring these changes do not lose their critical ties to business data entities.

ER/Studio Repository introduces new project management and collaboration tools to ensure the simplified creation of Repository-based diagrams and team-based collaboration projects to ensure all are using the same set of re-useable components.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access