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 ... 49
Got sent this link where Gartner evaluates Critical Capabilities for Enterprise Architecture Tools, amongst the list is Sparx Enterprise Architect.

Having used a number of the other tools in the past its not clear to me why certain tools score higher than Sparx Enterprise Architect in some categories. Unfortunately they seem to have scored Sparx EA the lowest. What do others think? A fair score or biased for some unknown reason?

I guess you should read the small print before taking advice from Gartner :)

Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

Bugs and Issues / Re: Have you tested on a DBMS MySQL 8 repository?
« on: December 16, 2018, 11:06:23 am »
Today I tested on a MySQL 5.7.23 (with the suitable checks in the 32 bits ODBC connection) and it still fails. The ODBC driver I'm using is version 8.0.
It states the following in the user guide -have you tried reading it?
A machine with MySQL version 5 or higher installed and running,
MySQL 32bit ODBC driver, between versions 5.2.4 and 5.3.6 (other versions are not recommended)

Automation Interface, Add-Ins and Tools / Re: Reverse engineer MDG
« on: December 11, 2018, 07:29:36 pm »
Yeah know how you feel at this time of year. Just about run out of steam my self.
12 sleeps to Christmas :)

Anyway here is a hack in the run up to the holidays for you to create those diagrams for enterprise risk management and security using the standard ArchiMate MDG.

Use the Alias to store the risk type and enable alias and name to be displayed in the diagram. For example
Use Goal and Add "Risk Treatment" in Alias
Use Assessment and Add "Threat" or "Vulnerability" or "Event" or "Impact" or "Risk" to alias field
Use Driver and add "Security Objective"
Get the idea?
Merry Christmas

To do transform select package and from ribbon Design > Tools > Transform > Transform Selection
Apply Transform
Select classes
Select DDL Transform
Click Do Transform button
For detailed description see
Try the search its wonderful at finding things :)

If the JavaScript is becoming too much effort then an alternative path to get a quick result of  adding PK and FK might be to do a DDL transformation. However that adds new attributes.

Automation Interface, Add-Ins and Tools / Re: Reverse engineer MDG
« on: December 10, 2018, 06:18:23 pm »
In theory you could create an XSLT file that transforms the MDG file to an XMI file which can be imported into Sparx EA. Looking at the MDG files its probably going to take someone anything upto a week to two of effort which is probably about the same amount of effort it would probably take to create an MDG that extends ArchiMate.
If its about the same amount of effort then I guess recreating the MDG from a Sparx EA model is the way to go.

General Board / Re: Are spammers the main users of this forum?
« on: December 08, 2018, 04:22:38 pm »
Bit of a silly question because clearly they're not

Suggestions and Requests / Re: Reporting Spam
« on: December 06, 2018, 11:13:09 am »
Clearly you are typing too fast  :)

Generally yes you can add attributes using tagged values. Three ways to do this add them manually one at a time.  Write a script to add them automatically. Create and MDG that extends the stereotype and adds the tagged values.

Here is a trick. When translating an object type from one to another try creating that target object type first, then retrieving those values so get to know what values you need. Write the code to put those values you've retrieved into your code to translate the object types. Saves a guess work along with a lot of time and energy.

General Board / APQC Process Model
« on: November 17, 2018, 06:51:14 am »
APQC is a process framework for the full enterprise.
APQC's Process Classification Framework (PCF)® is the most used process framework in the world. It creates a common language for organizations to communicate and define work processes comprehensively and without redundancies. Organizations are using it to support benchmarking, manage content, and perform other important performance management activities.

For those who have requested it via PM I've published APQC process model on Git hub.

It utilises a custom Enterprise Architecture MDG that is also located there so you need to copy that into a folder and reference it via the MDG dialog set up in Sparx EA to get a proper view of the diagrams.
You also need to change preferences to show both alias and name to see both the ID and name. The ID is in the alias.

To access the metrics you need to enable the metrics window and you will see them when you click on certain process elements.
Enjoy  :)

General Board / Re: How to create a "click-through" object in a diagram
« on: November 17, 2018, 05:56:48 am »
Child diagram is the thing you want.

Bugs and Issues / Re: Mysql model changed
« on: November 16, 2018, 11:52:32 am »
Kind of looks like the parent_ID or package_ID in the table t_object may have been corrupted in someway.

General Board / Re: Got stuck on Check Integrity
« on: November 15, 2018, 02:55:18 pm »
Backing up before resetting the IDs is a good move. Exporting to XMI will work to a point as it will export the model elements and their connectors along with the diagrams. But it won't include other stuff like alternative images or model defined stereotypes etc. Can you not just backup the SQL server? You should have at least a daily backup on that SQL server surely.  Alternatively a transfer to eapx or feap file would be more complete back up. You could try the reset ID on the eapx file then transfer back to SQL Server as an alternative course of action.

Didn't think Reset ID's would take that long. Pretty sure when I did it a while ago it only took about 10 min for a few hundred thousand elements.
Not sure about whether its one transaction but if something does go wrong you've got your backup.

General Board / Re: Got stuck on Check Integrity
« on: November 15, 2018, 06:55:19 am »
I change from .eap to SQL Server for more stable behavior. It turns out to be true.

However, now I got a problem that I cannot overcome:
When transfering from SQL Server to a local .eap I get "Unrecognized database format" if I try to open the .eap file. And it is true: I expect a size of ~100MByte and get 12kB as the size of the exported .eap-File.
I've gotten that error and its to do with eap and eapx where the latter is Jet V4.0 engine and the former V3.5. The older versions of Sparx used to open both even if it was named eap. However you seem to get that error now when opening a Jet 4 db when its got the extension eap. Found by renaming it to eapx it worked ok.
When doing Check Integrity/Project Integrity on the model in SQL Server I am left with one problem: Invalid Realization Stereotype. ITEM: . ACTION: Updated Applies To.

Any time I try to Recover/Clean I get a SQL Server failure Violation of PRIMARY KEY constraint 'pk_stereotypes'. Cannot insert duplicate key in object 'dbo.t_stereotypes'. The duplicate key value is (realization, realize).

What would be the next steps to solve that problem? How can I find the stereotype that caused it?
Sounds like the primary keys have gotten into a bit of tiz. Try reset IDs - the next option down from project integrity

Pages: [1] 2 3 ... 49