Tag Archives: Excel

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 »