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 »
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 »
EARecordset is a Script Library I’ve created to let me more easily work with Recordsets (XML structures) returned by Sparx EA queries. One of the key features of Sparx EA is the ability to directly query the repository using SQL to pull information for reports and to export. Sparx EA’s… Read more »
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 »
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 »
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 »