Excel, Oracle and Sparx EA Part 2 of 5: Maintaining Hierarchy

In my previous post I described how I’ve started pulling data from a Sparx EA repository hosted on an Oracle Database.   The next step was to determine how to maintain the hierarchy for the Packages and Elements so they would appear in the same order in Excel as they appear in my Project Browser in […]

Continue reading


Excel, Oracle and Sparx EA Part 1 of 5: Retrieving Data

The organization I work for has adopted Sparx EA as our Business Analysis modeling tool of choice and decided to use an existing Oracle repository for all our projects.  We simplified new installations by creating an installation package that automates the install of both the Oracle client and Sparx EA on to each user’s system. […]

Continue reading


Why your project should have a BA

I work for a very small business analysis team in a very large organization, and was recently asked by a project sponsor to support their request for having a Business Analyst as part of their project. Here’s what I wrote (generalized a bit to anonymize it) Simple answer is time and experience. A Business Analyst […]

Continue reading


Importing and tracing from a Source Document using Sparx EA

*** Currently there is a Bug in Sparx EA 12.0.1215 that prevents you from using the features in 3.1 and 3.2 *** http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1438024703/0#0 As a Business Analyst I often reference existing documentation as a source of statements that describe people, processes, requirements, rules etc, included in my analysis.   Early on I discovered that Sparx EA […]

Continue reading


Keeping diagrams “syncronized” in Sparx EA

As a Business Analyst I’m finding it very useful to have multiple viewpoints of the same diagram whether to show the evolution of an Architecture from the AS-IS through multiple Transitional Stages to the TO-BE, or to focus on a particular path through a Business Process to discuss how a Business Scenario will be handled. […]

Continue reading