Embarcadero Technologies Enhances ER/Studio with Expanded Data Modeling

Embarcadero Technologies, provider of database lifecycle management solutions, is enhancing its ER/Studio platform, focusing on better collaboration and communication within enterprises.

ER/Studio is a data architecture solution that combines multi-platform data modeling, design and reporting with cross-organizational team collaboration for data architectures and enterprises of all sizes. The platform features a data modeling tool to represent Business Data Objects (BDOs) in data models.

“Business Data Objects' purpose is to overcome a divide that has been in the industry for a number of years with a gap in communication,” said Ron Huizenga, product manager at Embarcadero, which was recently acquired by IDERA.  “What this allows us to do is designate the entities that comprise a business data object.”

With ER/Studio 2016, IT and business stakeholders gain increased visibility into corporate data assets through data model objects such as BDOs, centralized glossaries and terms and model image navigation, thereby improving data quality and consistency for better decision making across the enterprise. Users can define and view BDOs, assign naming standards to models and sub-models and view interactive model images in ER/Studio Team Server, improving control of complex data environments.

Other enhanced features include improved organization of model entities, extensive platform support for upgraded Teradata capabilities, such as support for derived period and temporal options and XML and JSON datatypes, Teradata 15.10, native support for Microsoft Azure SQL Database and SQL Server on Azure, and better usability with a consolidated database for ER/Studio Team Server and Repository to simplify model storage and deployment.

“We’ve now combined the Repository database and that Team Server database into one physical database and what that allows us to do is make those diagrams more available much more quickly,” Huizenga said. “Now models are available very quickly and easily by having these things combined.”

Technical teams, business stakeholders, business analysts, and more will benefit from these updates, especially with the introduction of BDO, according to Huizenga. “This really allows a better communication between data architects and the development team, such as the application architects, enterprise architects, and developers themselves,” Huizenga said.

ER/Studio supports a host of relational and NoSQL platforms, and provides native connections to Oracle, IBM DB2 (LUW and z/OS), Hadoop Hive, MongoDB, SQL Server, and SAP Sybase ASE, and others.

For more information about the update, visit