November 26, 2008

Embarcadero adds visual capabilities to data modeling tool

The ER/Studio 8.0 tool features Visual Data Lineage, which addresses data-tracing, compliance initiatives, and audits and can help solve business issues around data integration

Embarcadero Technologies will unveil next week an upgrade to its ER/Studio data modeling tool, featuring visual representations of where data resides and how it has changed.

ER/Studio 8.0 offers a model-driven approach to tracing data in the enterprise from source to target, Embarcadero said. Highlighted in version 8.0 is a featured called "Visual Data Lineage," which helps architects and modelers solve business issues around data integration. Visual Data Lineage provides a visual representation of data flows and changes and offers users an automated process and richer metadata, according to Embarcadero.

The feature can accommodate data models from systems like CRM, product, and order systems, said Jason Tiret, director of modeling and design solutions at Embarcadero.

"Visual Data Lineage allows you to capture how data is linked and used across those systems," Tiret said. It also can assist with moving data from transaction systems to a data warehouse and helps with compliance initiatives and data audits, Embarcadero representatives said.

Version 8.0 offers data professionals the ability to conduct an impact analysis between data sources and targets and visually analyze and document data flow without the need to inspect code, the company said.

Other features in ER/Studio 8.0 include:

* Integration with LDAP directories, for managing user access in the Embarcadero repository via LDAP and Active Directory integration.
* Attribute-level submodeling, in which users can select specific attributes displayed in a submodel for easier management of complex models. A submodel enables a large model to be broken up into functional or subject areas.
* Expanded database support, with support for Microsoft SQL Server 2008 and Sybase IQ 12.5.

ER/Studio is part of Embarcadero's suite of modeling tools, which also includes products such as ER/Repository, which offers a server-side model repository, and the ER/Portal tool for metadata search and reporting.

ER/Studio costs $3,500 per seat, but tiered pricing is available based on specific database platforms and editions of the product.

Paul Krill is an editor at large at InfoWorld.
Close

On Twitter now

Applications

Powered by Twitter

On Twitter now

White Paper

D2D Virtual Tape Library Replication Primer

This whitepaper explains the terminology and concepts behind Data Replication technologies and establishes some sizing rules through worked examples. Learn the new paradigm in disaster tolerance—protect data anywhere.

Download now »

White Paper

An Alternative to Virtualization for Datacenter Cost Savings

Server virtualization is a popular option for dealing with mounting datacenter costs. Another equally promising approach is the use of an Application Delivery Controller. Citrix NetScaler provides a low-cost way for organizations to reduce their server count and accrue cost savings from a reduction in space, cooling, power and personnel.

Download now »

White Paper

Why Your Firewall, VPN, and IEEE 802.11i Aren't Enough to Protect Your Network

The emergence of WLANs has created a new breed of security threats to enterprise networks.

Included in HP ProCurve WLAN solutions is security technology that alleviates threats from WLANs through:
* Monitoring wireless activity inside and out of the enterprise
* Classifying WLAN transmissions into harmful and harmless
* Preventing transmissions that pose a security threat to the enterprise network
* Locating participating devices for physical remediation

Download now »

White Paper

Bringing the Edge to the Data Center

Effectively address data protection challenges, implementing solutions that help store and protect business–critical data while cutting costs and improving efficiency and reliability.

Download now »

Sign up to receive Applications Resource Alerts

Subscribe to the Today's Headlines: First Look Newsletter

Find out what will be news for the day, with our first-thing-in-the-morning briefing.

©1994-2009 Infoworld, Inc.