Enterprise Architect version 13

download
purchase

English Chinese (Simplified) Czech Dutch French German Italian Korean Polish Portuguese Russian Slovak Spanish Swedish

My Profile

Social Media Channels

facebook google plus twitter youtube linkedin

2015vsm RCA medal bronze 200x263Enterprise Architect has recently been given the Bronze award in the Visual Studio Magazine 2015 Reader's Choice Awards.

The Sparx Systems design and build platform was recognised as an outstanding solution in the 'Software Design, Frameworks, and Modeling Tools' category.

In a recent Press Release (attached), Editor in Chief of Visual Studio Magazine stated that "The Visual Studio Magazine Reader’s Choice Awards offers a chance for readers to participate in giving public praise to those companies deserving of the recognition.”

More than 400 products across 31 categories were included in an online ballot run by Visual Studio Magazine, with hundreds of magazine subscribers responding over a 3 week period in late September.

Published in News
Find Real Orphans

Enterprise Architect comes standard with an Find Orphans search, which is supposed to give you a list of all elements that are no longer used in the model, and thus better be removed from the model altogether.

Find Orphans

The problem with this search is that it will only report elements that are not shown on a diagram; which should not be the only criterion to determine if an element is an orphan or not. Not being on a diagram is just fine. I have lots of elements in my model that are not on a diagram, that doesn’t mean they are not used anymore.

If you are going to delete all elements reported in the standard orphans search you might do serious damage to your model.

So in order to aid with the maintenance of a large model I wrote the following SQL Search.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
select distinct o.ea_guid as CLASSGUID,o.Object_Type as CLASSTYPE,o.Name as Name, o.Stereotype,
package.name as PackageName ,package_p1.name as PackageLevel1,package_p2.name as PackageLevel2 ,package_p3.name as PackageLevel3
from ((((((((((((((((( t_object o
left join t_diagramobjects dob on dob.[Object_ID] = o.[Object_ID])
left join t_object inst on inst.[Classifier] = o.[Object_ID])
left join t_objectproperties otv on otv.VALUE = o.[ea_guid])
left join t_connectortag ctv on ctv.VALUE = o.[ea_guid])
left join t_attributetag atv on atv.VALUE = o.[ea_guid])
left join t_operationtag optv on optv.VALUE = o.[ea_guid])
left join t_object u on u.Pdata1 = o.ea_guid)
left join t_connector cs on cs.Start_Object_ID = o.Object_ID)
left join t_connector ce on ce.End_Object_ID = o.Object_ID)
left join t_attribute att on att.Classifier like o.Object_ID)
left join t_operation op on op.Classifier like o.Object_ID)
left join t_operationparams opp on opp.Classifier like o.Object_ID)
left join t_object owned on owned.ParentID = o.Object_ID)
inner join t_package package on o.package_id = package.package_id)
left join t_package package_p1 on package_p1.package_id = package.parent_id)
left join t_package package_p2 on package_p2.package_id = package_p1.parent_id)
left join t_package package_p3 on package_p3.package_id = package_p2.parent_id)
where
o.Package_ID in (#Branch#)
and (o.name is null or o.Name like '#WC#<Search Term>#WC#')
and o.Object_Type not in ('Package')
and (o.Stereotype is null or o.Stereotype not in ('model document'))
and dob.Object_ID is null
and inst.Object_ID is null
and otv.VALUE is null
and ctv.Value is null
and atv.Value is null
and optv.Value is null
and u.Object_ID is null
and cs.Start_Object_ID is null
and ce.End_Object_ID is null
and att.Classifier is null
and op.Classifier is null
and opp.Classifier is null
and owned.Object_ID is null

This search will look for all elements that

  • Are located in the currently selected package branch
  • Are not a package or a model document  (section in a virtual document)
  • Are not used on a diagram
  • Are not used as the Classifier of an instance
  • Are not referenced by any tagged value
  • Are not used as the source or target of any relation
  • Are not used as the type of an attribute
  • Are not used as the return type of an operation
  • Are not used as the type of a parameter
  • Do not own any other elements

Elements that show up in this search are most probably real orphans that clutter your model and can be safely deleted.

Of course, before you delete anything from the model, make sure you have a backup!

Find Real OrphansIn order to use this search create a new search of type SQL and paste the above query into the query builder field.

If you find anything that should be added to this search please let me know.

Related

Published in Community Resources

Dunstan Thomas Consulting - Sparx Systems Authorised Training PartnerNew training course from Dunstan Thomas Consulting

Course design by Phil Chudley

Who Should Attend?

This course is suitable to anyone who models ArcGIS Geodatabases and wishes to create both a visual representation of the ArcGIS Geodatabase and an XML ArcGIS workspace file for input to other tools such as ArcCatalog.

What will I learn?

Upon completion of the course you will have learned the following:

  • How Sparx Systems Enterprise Architect supports ArcGIS Geodatabase Modelling
  • How to configure Sparx Systems Enterprise Architect for ArcGIS Geodatabase Modelling
  • How to structure a model repository for efficient ArcGIS Geodatabase Modelling using libraries of re-usable elements
  • The practical skills of creating and maintaining ArcGIS Geodatabase Modelling via a worked example
  • Productivity tips and tricks when using Sparx Systems Enterprise Architect
  • How to validate an ArcGIS Geodatabase Model
  • How to import and export a ArcGIS Geodatabase Modelling via XML
  • How to import a ArcGIS Geodatabase Model created in Sparx Systems Enterprise Architect into ArcCatalog

Course Content

  • Overview of Enterprise Architect and its support for ArcGIS Geodatabase Modelling
    • Practical – Configuring Enterprise Architect for ArcGIS Geodatabase modelling
  • Development of an example:
    • Design;
    • Practical use of Enterprise Architect to create an ArcGIS Geodatabase model
    • Productivity Aids when use Enterprise Architect
    • Capturing ArcGIS data within Enterprise Architect using ArcGIS tagged values
    • Dealing with relationships
  • Validation
    • Validating the model using the ArcGIS validation script
  • Implementation
    • Exporting the model to ArcGIS Workspace XML
    • Importing to the ArcGIS workspace XML to ArcCatlaog

Pre-requisites

It is assumed that all attendees for this course will be familiar with the ArcGIS Geodatabase Meta-Model. Previous knowledge of Sparx Systems Enterprise Architect is desirable but not essential.

If you would like to know more about our training & consulting services then please visit our website or This email address is being protected from spambots. You need JavaScript enabled to view it..

Published in News

As part of an EA add'in implementation, I had to import all Enterprise Architect table and column names in enumeration classes.

Having access to a database that stores a Sparx Systems Enterprise Architect project (e.g. MySQL, SQL Server, or even an EAP file via ODBC), there was a number of ways to populate enumeration classes with literal values using a small application in C# or another programming language. As Enterprise Architect 12 includes the Database Builder, an integrated tool to work on DB schemas, I took the opportunity to use it. Compared with the result of a C# application, this feature would let me capture the enumeration classes in my EA modelling project in addition to generating C# enumeration classes in my add'in solution.

This article only covers a small portion of Sparx EA Database Builder features: it illustrates how I managed to import Enterprise Architect table names as literal values in the EADBTableType enumeration class, and their column names as literal values in separate enumeration classes e.g. t_diagramColumnType, t_objectColumnType...

Import all tables in Enterprise Architect

- Open the menu Tools > Database Builder

- Right click and select New Data Model:

- Select the DBMS used, e.g. MySQL and confirm Ok

- Right click on MySQL > Load

- Right click on Connections > Add new DB connection

- Open the new DB connection and select ODBC based datatype

- Select an existing ODBC DSN (or create one) to the DB that stores the Enterprise Architect project where the schema needs to be imported

- Right click on MySQL > Import DB Schema from ODBC

- Click on Import and select all tables:

- All tables, columns, primary keys, foreign keys, indexes, etc. have been imported.

- Go back to the Database builder and open the Tables tabs: all tables are displayed. Selecting one of the tables provides access to all columns' details.

Generate the enumeration classes

The Database Builder let me achieved what I needed. Having all tables and columns stored in a single package, I wrote a simple script to perform the following:

- create an enumeration class named EADBTableType

- for each table:

    - create a literal value with the table name in EADBTableType e.g. t_object

    - create an enumeration class named after the table based on the following format: <table name>ColumnType e.g. t_attributeColumnType

    - for each column in the table:

       - create a literal value with the column name in the current table's enumeration class (e.g. Classifier in t_attributeColumnType)

Having executed this script, the following enumeration classes have been generated:

Transform enumeration classes to dotNet C# classes

The MDA model transformation can be used to generate C# enumeration classes for the above enums:

- Right click on the package that contains all enums > Advanced > Transform Package

- Select C# as the target, select the package, and click on Do Transform

- Having all C# enumeration classes created, and making sure the namespace is correct (e.g. create packages myaddin.common.enums), the code can be generated: right click on package > Code Engineering > Generate Source Code.

- The generated code can be used in Visual Studio IDE:

Published in Tutorials

 

Hippo Software’s new ‘EA for GUI Design’ course teaches delegates how to capture end user requirements and create wireframe diagrams to design the layout of user interfaces, mobile apps or websites.

http://www.hippo-software.co.uk/pages/EAforGUIDesign.htm

Published in News
Monday, 31 August 2015 03:49

Upcoming Webinars - Late 2015

Sparx Systems is pleased to announce a number of upcoming webinars covering topics including geodatabases, Cloud Services and migrating ArcGIS models in Visio.

To learn more, visit our Webinar directory:

www.sparxsystems.com/webinars

 

Modeling Techniques for Large-Scale ArcGIS Geodatabases

September 2015 Learn how to create modular schema designs to maximize reuse; define scalable design diagrams from reusable components; and leverage inheritance of abstract shape stereotypes.

Click to Register

 

Introduction to Cloud Services

October 2015 Learn how to create, manage and configure the Sparx Systems Cloud Service to provide convenient, secure model access anywhere in the world.


Click to Register

 

How to Migrate Visio ArcGIS Models to Enterprise Architect

November 2015 Learn how to migrate existing ArcGIS (CASE) Models in Visio to Enterprise Architect and leverage state-of-the-art modeling tools to update and maintain geodatabase designs.
Click to Register

Published in News

IIBA has signed a collaborative agreement with Sparx Systems Pty Ltd.

IIBA is committed to forging value-add relationships with corporations, associations and business stakeholders to create greater connections and engagements across the business analysis community. These new Memorandums of Understanding (MOUs) will provide support, products, services and connections to practitioners and their organizations, which will help them deliver a strong BA practice and achieve organizational success.

The IIBA has more information on their website.

Sparx Systems Pty Ltd.

Sparx Systems and IIBA share similar interests and commitment in expanding the value each provide to their respective stakeholders. By supporting each other’s efforts in specific areas, this new collaboration will provide greater value to IIBA Membership, Sparx Systems users and the overall business community.

Key outcomes will include:

  • The potential integration of BABOK® Guide v3 with Sparx Systems Enterprise Architect (EA)
  • Offer access to possible references, tools and extensions to increase productivity and performance on all levels of their business activity
  • Support business analysis and related practices through IIBA Chapter events, including presentations on business architecture, process modeling, and other related techniques, as well as vendor tool demos and user group discussions
  • Joint approach to access new networks and relationships with other markets
  • Develop a strategic approach to engage academic institutions through outreach and research programs

Please read the attached press release for more information.

Published in News

The next EA User Group events are scheduled for 17th September 2015 in Paris and 18th September in Brussels.

For just €75, attend either of these events and get instant access to all the presentations from both!

Our sponsors:

EAUG Sponsors

EA User Group Paris

VISEO will host the first EAUG in France on Thursday, September 17th 2015.

This first edition will introduce talks and presentations in French on a wide array of topics including Enterprise Architecture (TOGAF, ArchiMate), modelling IT and software applications, generating and validating documentation from the models, and Systems Engineering (MBSE, SysML).

Enterprise Architect add ins will be shown in a dedicated area, where users and experts will be able to share their opinions and experiences on notations, languages, methodologies around a coffee, tea or other refreshment.

You can view the agenda for the day here.

 

EA User Group Brussels

EA User Group BrusselsThe next English speaking Enterprise Architect User Group event will be in Brussels on September 18th 2015, sponsored by ACV-CSC.

This conference will provide an opportunity to discuss many aspects of Enterprise Architect and its use. We are currently appealing for speakers to make this a memorable day.

The preliminary agenda for Brussels is available here.

 

BOOK NOW

Published in Events

Sparx Systems has been recognized for it's leadership in providing quality technology in support of Service Oriented Architecture Technology related modeling.

CIOReview recently published a list of the "...20 most promising SOA Solution Providers, listing the best vendors and consultants who provide key technology solutions and services related to SOA." CIOReview is a technology magazine that talks about the enterprise solutions that can define the business goals of enterprises of tomorrow.

Enterprise Architect implements the OMG’s Service oriented architecture Modeling Language (SoaML), which provides a standards-based approach to modeling SOA solutions using the UML.

As a natural complement to SoaML, Enterprise Architect also supports the Service Oriented Modeling Framework (SOMF), which encourages a holistic view of enterprise software entities via a technology-independent notation. The SOMF modeling notation provides an intuitive approach to visualize “used-to-be”, “as-is” and “to-be” states of the enterprise service portfolio.

CIO Review's 20 Most Promising Service Oriented Architecture Technology Providers of 2015

Read the full article: http://www.sparxsystems.com/bin/cio-review-soa.pdf

Top 20 list: http://ea.cioreview.com/vendors/2015/20special1

 

 



Published in News

Sparx Systems has been regarded highly in a recent publication of CIO Review magazine, identifying the company as a benchmark vendor within the Enterprise Architecture space.

sparx systems awarded cioreview 20 most promising enterprise architecture technology providers 2015Following on from CIOReview's inclusion of Sparx Systems within the 2015 BPM Top 20 list, the review process is conducted with the support of industry experts, identifying vendors who "... have exhibited vast knowledge and in-depth expertise in delivering EA related solutions."

An active and informative Sparx Community is one of the driving forces that support Sparx Systems in being recognized in this space; a highly collaborative Community membership who share their experiences underpins the global appeal of Enterprise Architect.

CIO Review's 20 Most Promising Enterprise Architecture Technology Providers of

Read the full article:  http://www.sparxsystems.com/bin/cio-review-ea.pdf
Cover story: http://ea.cioreview.com/vendors/2015/
Top 20 list: http://ea.cioreview.com/vendors/2015/20special1

Published in News