How I started using Sparx EA as my Business Analysis tool of choice

In late 2009 (just before version 8 was released), I began learning how to use Sparx EA.   A different branch in the organization I work for had purchased a few licenses to evaluate using Sparx EA as a Data Modeling tool, they decided to go with a different product, but… Read more »

Excel, Oracle and Sparx EA Part 3 of 5: Tagged Values as columns

In my previous post I described how I was able to use different Oracle functions 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 Sparx EA.  The next step was to figure… Read more »

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… Read more »

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… Read more »

Importing and tracing from a Source Document using Sparx EA 12

*** 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… Read more »

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… Read more »