Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Sunshine

Pages: [1] 2 3 ... 34
General Board / Re: Repository security
« on: November 28, 2017, 01:43:40 pm »
Thanks Simon,
Had a feeling the express version might not have all the features.

General Board / Re: Repository security
« on: November 27, 2017, 01:57:14 pm »
There is actually a feature that uses row level locking on SQL Server and Oracle repositories.

It comes with pro cloud server, but I'm not sure how to use it.

Thats good to know - not using pro cloud server just yet so in a similar boat of knowing little about it. Was hoping to have time to look into it with the recent offer Free: Pro Cloud Server Express but alas other urgent things keep drawing my attention away from it.,38812.0.html

General Board / Re: Repository security
« on: November 25, 2017, 08:34:13 am »
You can create a group and lock the package with a group lock. Then assign users to the group to grant read/write access to that package. There is no mechanism to hide content from users unless you have multiple repositories and prevent users from access a repository.

General Board / Re: IS there a guide to recommended security groups
« on: November 23, 2017, 12:03:31 pm »
I've set mine security up in two dimensions
a) disciplines like business analyst, architect, etc
b) competence. i.e. beginner, intermediate, advanced, admin

where a) allows packages to be locked to certain users like business processes to BAs
and b) restricts what they can do. The beginners are very limited but advanced and admin can do just about everything.

Then allocate one or more for group a) so it restricts what package tree they can edit and one for group b) to restrict what they can do in that package tree.

Follow structure similar to TOGAF/Archimate

-Business Architecture
-Application Architecture
-Data Architecture
-Infrastructure Architecture

Hope that helps.

:) its helpful, thanks @ Sunshine
karma points welcome  ;)

I use the phase field and the filter to include one or more filters. So I might have a number of elements with phase 1.0, 2.0, 3.0 etc then create filters that include phase = '1.0', '2.0', '3.0' and enable one or more filters.
Now there are two patterns I've observed using this
a) Phased approach to implementing some system so that when the last phase is reached everything is included and all the filters enabled.
b) A phased approach to adding some components and retiring others. This requires a slightly different approach where in the phase I include the phases in which the component exists. For example if component A already exists and component B is being add lets say in phase 2 to replace it I might have 3 phases.
Phase 1.0 - component A only
Phase 2.0 - component A and B exist
Phase 3.0 - component B exists and component B has been retired.

Component A phase field = '1.0, 2.0'
Component B phase field = '2.0, 3.0'

I would use a filter that says contains rather than equals a phase value like '3.0'
Hope that helps.

There are also diagram filters that can gray out or hide elements based on selection criteria, but I have no idea if these can be made to be applied during document generation...
Enable the filter then generate the doc

Upon reflection of the suggestions from various people in previous posts I think if I had the problem I'd use fragment template with a custom script to navigate the relationships. I must admit I'd forgotten about fragment templates with scripts in my original suggestion.

Wonderful sharing ideas in the community to get a better outcomes isn't it? Thats what I love about this community - great people sharing their thoughts and ideas.

I've used phase to indicate which phase the requirements should be implemented in. You can then add a filter in the doc gen template to only include requirements, usecases etc for a particular phase. Now the trick is to use the "one of..." option on the element filter so that for phase 2 you include phase 1 as well 2. For example  "1.0,2.0" - can't remember if that is the correction format comma separated values or whether its semi-colons or something else but I think you get the idea.

As far as I know the only way to get that nesting using the built in doc gen is to structure your model that way. So a feature contained a requirement etc. If that's not how your want to structure your model the other options are;

a) To write some specialized SQL query along with some reporting. So if you are using eap files as your repository which is basically MS Access you can try writing MS Access SQL and using those in a MS Access Report. Or similarly if you are using MS SQL you can use SQL Server reporting services.  I'm sure there will be options for the other database supported too.

b) I've once seen someone do is by leveraging the built-in scripting and use jscript to create a rtf file. I think they did come a cropper when there was a cyclic set of relationships in the model and ended up  with infinite loop blowing the thing up.

General Board / Re: What is Sparx and for what purposes it should be used
« on: October 05, 2017, 01:15:58 pm »
Thank you very much for the answer. You mentioned such thing as " For enterprise architecture work I use a customised version of ArchiMate MDG. I have a meta model based on ArchiMate that describes all the elements and relationships along with a catalogue of viewpoints mapped to stakeholders. I based my catalogue of view points on the TOGAF and ArchiMate List."

Could you please show me some screenshots or maybe share the example of your work. It will definitely help me.. I would like to understand and to see how you have organized catalogs and mappings, viewpoints and some example of metamodel.
Sorry pretty much everything I do is for clients is usually confidential so can't share.

However, if you go to all the standards on ArchiMate meta model and view points are there. Similarly for TOGAF. Also Marc Lankhurst the main author of ArchiMate works for bizzdesign and he has a blog with some good stuff on using ArchiMate etc
Another place to check out is as they provide some posters for viewpoints and metamodel.

The extensions I've added to the ArchiMate metamodel are mainly attributes. For example an I've added to application component attributes like Annual Support Cost, Security Classification, etc to help manage the applications.

How I organise the Sparx Model for enterprise architecture is something like this. As Glassboy says its in align TOGAF. I mainly follow ArchiMate as thats the language I use in combo with UML and BPMN. There is some work going on to align the ArchiMate and TOGAF to use same metamodel.

Enterprise Architecture Model
          Application and Data
          Implementation and Migration

Document Generation
          Subject A
                    Model Doc X
                    Model Doc Y
          Subject B
                    Model Doc Z

I keep the doc gen separate from the main model so I can generate the enterprise architecture model as HTML making it available to everyone in the organisation. I keep the diagrams separate from the catalogs of objects to make sharing of the objects easier. The downside when you create new objects on a diagram they are stored in the same package as the diagram and you have to lift and shift them into the catalog package.

Like I said before the learning curve is massive for both Enterprise Architecture Discipline and the Sparx EA tool so you really need to bring in some experts. My colleagues call me an expert but I still sometimes struggle with some aspects from time to time and I've been using Sparx EA for Enterprise Architecture over a decade now.

Always good to get some fresh thoughts.
1. What do you think about adding a true crow's feet notation, where keys are underlined instead of having the key icon as stereotype
1.1 Also if it's not patented, how about adding automatic highlighting of the keys when you hover mouse over a relationship... this is something that Mysqlworkbench does and I find it useful to plan queries and joins
1 - I like the key icon can't say the underlining would get my vote.
1.1 - Yeah may be.

2. You can drag attributes (non-keys) from a table (or Class) to another in Project Explorer, but not in the diagram... it would be useful to be able to move attributes around in diagram as well
2.1 Editing attributes in the diagram by double clicking is buggy too... changes are not saved
2. - There is a feature where you can drag from project browser to element on diagram and it copies it. Not sure if I'd like that moving attributes on the diagram. Kind of feel the UI might become a little tricky to use when trying to select element vs attribute.
2.1 - I've not had this problem but may have just gotten used to the UI over the years.

3. EA (at least Professional) cannot reverse engineer SQL DDL code... I find it useful to move models around and update schemas.  MySQLWorkbench and ERWin can do this
3- Can reverse engineer DB already in corporate edition and above. I usually reverse engineer DB, edit in Sparx EA and generated DDL to create DB.
4. No CSV export for attributes is a major feature gap... I have read up on EA limitation to CSV export classifiers only and not their attributes, and I understand the difficulty in implementing this across all UML classifiers, but a table-attribute specific script should be made available by Sparx.  It's very valuable for quick editing-fine tuning-reporting when under time pressure (ERWin is excellent in this respect)
4 - MMh? I struggle to understanding this one. Do you want to make global changes to attributes or run a report? Here is a little trick on global changes; the  eap files are really ms access 97 and you can open it with MS Access and do global changes that way. Using DB skills to save time in changing the DB design - kind of poetic in some way isn't it :). BTW you can use the MS Access Jet 4 too for later versions of MS Access that don't support 97 anymore.  To run reports then look at doc generation. very comprehensive reporting built in already.

If you can't wait for that feature you can write some vbscript/jscript to create your cvs file.

Suggestions and Requests / Re: Model Search: More than one Search Term?
« on: October 03, 2017, 12:29:23 pm »
Maybe its because it is in the afternoon and I've just had a big lunch but I'm  missing something here as I thought the query builder provided multiple <search terms>.

Bugs and Issues / Re: Suppress Relationships still shows NoteLinks!
« on: October 02, 2017, 08:25:57 pm »
I've notice that too and agree.
The work around I did was to colour the relationship white so when I printed the diagram it didn't show.
The other thing I notice when disabling relationships was that certain shapes that provided the rectangle option which put the name label floating outside of the shape can't be moved when the show relationships box is unticked. For example the business actor in archimate 3 put the name underneath the shape and normally you can move it but when the relationships are not shown then can't move the name label anymore.

Pages: [1] 2 3 ... 34