Category Archives: Sparx EA

Pages under this category describe my thoughts on Enterprise Architect by Sparx, what I like, dislike, and the experiments and the lessons of myself, my staff and my peers as we’ve used Sparx EA to capture the models and information we rely on as Business Analysts.

Version: I’m currently using Sparx EA 13.08
Manual: Sparx EA 13 Online User Guide

 

Get related Elements with a single query (Oracle)

When working with Sparx EA I often want to generate a report to discuss a set of Elements in the context of their relationship to other elements. I’ve made the following query that returns: Connected Elements: to the current element (current <- other) Connected Elements: from the current element (current… Read more »

Update multiple records with a single query (Oracle)

Warning: Be very careful using this method to directly update your Sparx EA repository. Most objects in the Sparx EA repository requires updates to multiple tables in the underlying database, unless you know what you’re doing I strongly suggest using the API to do additions and updates in your repository…. Read more »

Insert multiple records with a single query (Oracle)

Warning: I typically only use the method described in this post for TaggedValues, almost every other “add” to the Sparx EA repository requires additions to multiple tables in the underlying database, unless you know what you’re doing I strongly suggest using the API to do additions and updates in your… Read more »

Modeling Policies and Directives for Reuse

      No Comments on Modeling Policies and Directives for Reuse

Recently I started a new job and have had more time to look at how to create architecture catalogues of elements and diagrams for reuse across projects, and realized that a lot of what I’m doing could also be reused by other Government of Canada and related organizations. I’m going… Read more »

Setting the an Image Asset as an Alternate Image using Sparx’s API

I’ve also been experimenting with image assets, this is what I’ve found so far: You can use the image assets directly in diagrams, they seem to be treated as class elements…. I’ve been in contact with Sparx, and they don’t recommend using image assets directly in you diagram, the intent… Read more »

Tips and Tricks: Creating Diagrams in Sparx EA

      1 Comment on Tips and Tricks: Creating Diagrams in Sparx EA

Sparx EA offers numerous ways to create new diagrams, and then add elements and connectors to your diagrams, this blog entry summarizes these different options. Creating a new Diagram in Sparx EA by first selecting a Package or Element in the Project Browser and either: using the Ctrl+Insert Shortcut Key,… Read more »

Tips and Tricks: Diagram Layout using Keyboard Shortcuts in Sparx EA

I spend a lot of my time working on Diagrams in Sparx EA, a few years ago I set up the following keyboard shortcuts to make it quicker (for me anyway) to modify the layout of Elements in my diagrams. In addition to setting up the keyboard shortcuts to help… Read more »