Tag Archives: SQL

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 »

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 »