Monthly Archives: December 2018

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 »

Business Analyst vs. other project roles

      No Comments on Business Analyst vs. other project roles

A RACI table I created earlier this year as part of the Business Analysis team’s Service Level Agreement.   The purpose of the RACI and the SLA is to ensure that the other project team members know what the BA team will deliver for them and why, and what their responsibilities… Read more »

Modeling Policies and Directives for Reuse

      No Comments on Modeling Policies and Directives for Reuse

Recently I started a new job and have had more time to look at how to create architecture catalogues of elements and diagrams for reuse across projects, and realized that a lot of what I’m doing could also be reused by other Government of Canada and related organizations. I’m going… Read more »