Team Modeling Resources for Enterprise Architect

This page provides resources for users who intend to deploy Enterprise Architect in a shared, team environment.

Team based modeling can involve usage of a DBMS server for shared model repositories, role-based security to help govern editor permissions and performance optimization for remote repository connections (for example when editing a model via VPN).

Resources for each of these needs are listed below:

• DBMS setup scripts: For server-based model repositories
• WAN Optimizer: For enhanced network connectivity with remote DBMS repositories
• User Security Key: For enabling role-based security

Please note: Either the Trial Edition or the Registered Edition of Enterprise Architect is required to use the resources listed below.

Setting Up DBMS Repositories

The Corporate and Suite Editions of Enterprise Architect support a variety of DBMS's to host the model repository. To use a DBMS repository you first need to execute scripts that create the required database tables. You can download these scripts below for each supported DBMS. Instructions for using the scripts are listed next to each DBMS. Also listed with each DBMS are update scripts, designed to improve performance on model repositories which were created using scripts downloaded prior to February 10, 2010. The update scripts add indexes to the database schema. Note: To apply the update scripts, open the existing repository model. From the Tools menu select Run Patch. MySql (instructions)
	MySQL_MyISAM_EASchema.sql (51 KB)
	MySQL_InnoDB_EASchema.sql (51 KB)
	MySQLScriptUpdatePatch.xml (7 KB) Update
SQL Server 2000/2005/2008/2012, Express 2005/2008/2012 and MSDE (instructions)
	SQLServer_EASchema.sql (88 KB) Microsoft SQL Server 2000, or later
	MSSQLScriptUpdatePatch_2005-8.xml (11 KB) Update (Please Note: This update script is not applicable for SQL Server 2000)
Oracle 9i, 10g and 11g (instructions)
	Oracle_EASchema.sql (105 KB)
	OracleScriptUpdatePatch.xml (6 KB) Update
PostgreSQL (instructions)
	PostgreSQL_EASchema.sql (52 KB)
	PostgresScriptUpdatePatch.xml (7 KB) Update
Adaptive Server Anywhere 8 and 9, SQL Anywhere 10 and 11 (instructions)
	ASA_EASchema.sql (57 KB)
	ASAScriptUpdatePatch.xml (8 KB) Update
Progress OpenEdge 10.1C (instructions)
	OpenEdge_EASchema.sql (54 KB)
	OpenEdgeScriptUpdatePatch.xml (4 KB) Update

WAN Optimizer

The Sparx Systems' Wide Area Network (WAN) Optimizer is a server side process for enhancing performance when connecting to remote model repositories. This process reduces the amount of data transmitted and, in turn, the level of network traffic between the Enterprise Architect client and the remote repository.

Download the WAN Optimizer service and client application:

wanoptimizer.exe (1.1 MB)

User (Role-Based) Security

User security is included in the Corporate, Business and Software Engineering, Systems Engineering and Ultimate editions. Trial users can enable user security on a project, by entering the following key: {C27378C8-6CD8-4efa-92F8-4E0E4F1A8B65}

A separate key is available for Registered users from the registered site.