improve agility and collaboration with er/studio xe7

EMBARCADERO TECHNOLOGIESEMBARCADERO TECHNOLOGIES

ER/Studio XE7 Overview

Improve Agility and Collaboration in

Your Data Architecture

EMBARCADERO TECHNOLOGIES

Embarcadero Technologies

• Founded 1993

• 3.2 Million Customers - 97% of Fortune 2000

• 35+ Product Awards – Consistent Innovation

• 500+ Employees in 29 Countries

2


Keeping pace with the rapid growth of data, change and compliance

Evolving Database

EcosystemsVolume, Velocity,

Variety

Agile Development

CyclesMaximizing IT

InfrastructureComplianceLimited

Resources

Data-Driven Organizations Need the Right Tools

3


Business-Driven Data Architecture

• Improve visibility and collaboration with ER/Studio

• Enable more efficient and automated data modeling

• Share models and metadata across the organization

• Establish business glossaries with consistent terms and definitions

• Build a solid foundation for compliance, data governance, and master data management

4


ER/Studio Enterprise Team Edition

5


Introducing ER/Studio XE7

• Innovation– Agile Change Management

Tasks and UI

• Team Server Enhancements– Glossary Hierarchies with

Inheritance– Improved Advanced Search – Detailed Audit Trail for

Glossaries and Terms– Improved CSV Import

• Increased ER/Studio Platform Interoperability– Glossary Integration to Data

Architect– Data Source Mapping and

Impact Analysis

• Usability improvements – Data Architect Welcome Page – Automated Naming Standards– Multi-version Licenses

6


ER/Studio XE7 Features

New ER/Studio XE7 FeaturesData

ArchitectData

Arch ProEnterprise

Team

Agile change management

Agile change management, including tasks and version history, enables modelers to keep data models relevant with fast-changing databases and applications

Automated naming standards

Automated application of naming standards between logical and physical models

Usability improvements

New ‘Start Here’ welcome page with dynamic content (such as how-to videos) improves the user experience and shortens learning ramp-up time

Data source mapping

Identify and analyze data source impacts resulting from model changes

7


ER/Studio XE7 Features, cont.

New ER/Studio XE7 FeaturesData

ArchitectData

Arch ProEnterprise

TeamGlossary enhancements

• Changes to glossaries and terms can be tracked with detailed audit trail histories

• Glossary hierarchies with inheritance allow creation of child glossaries that can inherit a subset of terms from one or more glossaries, to create tiered structures that correlate to organizational configurations

• Integration with the ER/Studio Data Architect data dictionary allows modelers to see glossary terms and definitions in real-time for consistency

• Ability to make mass updates to a subset of glossaries and terms (instead of all at once or one at a time) using CSV modifications

Advanced Search updates

Enhanced browse and search capabilities are now available for glossaries, terms, data sources, and data objects

8


Multi-Version Licenses

• Users will no longer need to obtain version-specific licenses

• These XE7 license credentials can be used to register both this version and upcoming versions

– Licenses must have a current maintenance contract in order to enable this licensing feature

9


Welcome Page

10


Automated Naming Standards

Real-time update while typing

11


Data Source Mapping

12


Agile Change Management

• Enable “Agile Data Modeler”

– Incremental rather than waterfall

• Need more granularity than named versions of a model or submodel

• Change numbers assigned at Repository check-in (or check-out)

– Can be associated to user stories, tasks

13


Agile – Task Editor

14


Checkout

15


Check-in Dialog

16


Change Management Center

17


Change Record Detail

18


Glossary Inheritance

• Similar to ER/Studio submodels• Child glossaries inherit a subset

of parent terms• May have one or more

parent glossaries• No limit to hierarchy level

19


Glossary Integration

• Associate ER/Studio Data Architect objects to Team Server glossary terms– Model, submodel

– Entity, Table

– Attribute, Column

– Domain

– View

• Push terms to glossary

20


Glossary Integration – Business Term Editor

21


Additional Glossary Enhancements

• Change history / audit trail

• Export/Import

– To/from workbooks

• Advanced Search

22


Advanced Search

• Available in Team Server / Enterprise Team Edition• Improved search criteria for data objects, data sources, glossaries,

and terms

22


Safyr – Technology Partnership

24


Safyr

ERX

25


ER/Studio XE7 Demo

26


Thank you for your interest!• Learn more about the ER/Studio product family: http://www.embarcadero.com/data-

modeling

• Trial Downloads: http://www.embarcadero.com/downloads

• To arrange a demo, please contact Embarcadero Sales:

– North America: [email protected] +1 (888) 233-2224

– EMEA/UK: [email protected] +44 1628 684400

– EMEA/Germany: [email protected] +49 6103 3866-100

– APAC/Australia: [email protected] +61 2 8098 8800

– Brazil, Argentina, Chile: [email protected] +1 (831) 431-5234

– Mexico, Central America, Colombia, Peru, Caribbean: [email protected] +1 (512) 226-8401

27

http://www.embarcadero.com/data-modeling

http://www.embarcadero.com/downloads

mailto:[email protected]




