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 - DavidM

Pages: [1] 2 3 4
General Board / Re: Logical Data Modelling in SPARX
« on: Today at 05:06:24 am »
Hi Guys,
Thanks for all the responses.

To answer your questions - so I don't want to develop a technology as we have a ground of about 8 Data Architects charged with the  task or creating an Enterprise wide Data model, abstract from systems, much of the data entities are spread over 10-15 systems  each, with different technologies (ranging from Oracle to mySQL to a flattened Parquet files system in HDFS). All we want to map at this point in time are the data assets, not their technology associations.

Class diagram industry standard - I'm not convinced with that statement, maybe users in Sparx, but certainly not in more data centric applications like ERWIN etc.

I have no issue using Class diagrams, but I need to have a primary key of 2-3 fields, and I need another entity to have these 2-3 fields that are logically the primary and foreign keys, and therefore need associations between all fields, I am struggling how to do this in UML.

Also how do you define what is a primary key and foreign key in a methodology put together for application collections with a single key?

There is a lot of pressure to disregard Enterprise Architect as a data modelling tool and evaluate others, but I am keep to keep it going as I want to tie it with systems and business capabilities (I've defined a MDG to accommodate all this), the easy part, I thought, would be the data modelling.

Thanks guys,

General Board / Logical Data Modelling in SPARX
« on: October 19, 2018, 01:31:03 pm »
Hi I have just joined an organisation that uses Sparx for all modelling including Data.

From what I can see the suggestion (not sure why) seems to be UML class diagrams for logical, and something resembling true data modelling called uml extended->Data modelling for physical diagrams.

I would much prefer to use the Data modelling option for Logical data model, but it is very technology specific , and the whole point of a logical model is that it is abstract from any technology.

Is there
a) Any way you can use Data modelling without a specific dbms type or
b) Using clunky uml class notations can you identify which are primary and foreign keys in the entity, and create relationships between multiple attributes?

I am sure it is obvious for such simple a task, but I cannot seem to figure it out.

Manky thanks,

I think this is quite a pragmatic question. Often I have been in the same situation where you have a large data model, where entities are miles apart, but you want to connect them, it would be easier to have a clone of one element (with an indicator if needed for the pure at heart) to create a cleaner diagram.

Same for UML class diagrams, same for ANY diagram come to mention it.

There is but it is not perfect

General Board / Re: MDG on V12+++
« on: May 25, 2018, 02:38:23 pm »

We found it at last - 3 hours 40 mins totaled time (obviously x 3)
Under Configure-Manage - No instructions found anywhere, came across it by having to go through every single menu option

General Board / MDG on V12+++
« on: May 25, 2018, 02:07:50 pm »
Hi Everyone,
I have tried to stay away from V12 Sparx for as long as I can. I have had v9 installed up until last week where we had to do  an upgrade.

I find it so much more difficult to use than the older versions, as do some of my younger colleagues who have also tried to stay on 9.
Anyway, in the old one, to view the currently installed MDGs and version was a very simple exercise. How on earth do you do it with the new versions? 3 of us have spent all afternoon trying to figure this out - combing the web etc.

Also - there used to be a search type feature I could type in something like "import mdg"and it would take me to the menu whet it was located, so I wouldn't have to remember the complex taxonomy only that is used for functionality.

Can anyone remind me how to get this back please as it has disappeared off my ribbon.

Thank you,

General Board / Adding Memos as a MDG
« on: May 01, 2017, 02:51:01 pm »
We have been using  an MDG script that I developed a couple of years ago to generate our own symbology for our own framework.

We have a large demand however for a Notes field in the element, similar to the one that comes up when you double-click any element, but for non-formal technical comments that we don't want to publish in the document generator.

Does anyone know if there is a way to do this in the MDG? it could be a tag for example that when you click on it, provides a memo object.
many thanks,

General Board / Re: MDG connector stereo types
« on: March 07, 2017, 07:17:49 am »
Hi Guys,
Thanks for the responses.
I didn't mention that I am not using UML - this is a custom build MDG to represent our high level architecture.
I could also change the stereo type manually, I guess what I was looking at was trying to make an automatic way.


General Board / MDG connector stereo types
« on: March 06, 2017, 05:59:27 pm »
Hello Sparx professionals
I have created a custom connector using MDG.
I would like to have the stereo type display what is in a tag value. Is there any way to do this?

e.g Tagx =  " Batch"
Connector stereotype = " <Batch> "
change Tagx to "Real time"
Connector stereotype" <Real time>"


General Board / Re: Attributes csv import
« on: December 01, 2016, 03:14:48 pm »
if not, can you direct me to Geert's csv importer please?

General Board / Re: Attributes csv import
« on: December 01, 2016, 03:02:47 pm »
Hi Thanks for the reply.
I do (I think) have simple cases.

table1                  field1
table1                  field2
table1                  field3

and so on. Can that be done "out of the box"?

General Board / Attributes csv import
« on: November 30, 2016, 08:15:17 pm »
I would like to import a class with attributes from a CV file. I see references to this a couple of years ago and talk about using external tools and scripts etc. I just wonder if there is anything out of the  box"  now with Sparx

General Board / Roadmap Options
« on: October 07, 2016, 09:44:37 am »
We are using the Roadmap options of the Sparx 12 quite a lot, and I was wondering if there is anyway to set up a diagram to be in "Roadmap mode" through MDG?

Hi Geert
If you mean sarcasim about the data model - far from it.
I'm bring genuine. I had my first look after years away from it a week or so ago.

I found it very easy to follow.  I guess I might gave been spoil by traversing comolex models like SAP etc. but this one is a delight.

Suggestions and Requests / Enumerated tag based on sql
« on: September 16, 2016, 07:48:43 pm »
It would be great if we could define a tag list based on sql. Either for the sparx database or another database.

Quite often enumerators are dynamic not static or could be a long list.

Also I think this would be a good method of identifying realised elements for a logical component so it could be displayed on the element via a shape script.

It would save having to rebuild and redistribute models everyone you added a new tag enumerator.

Yes I totally agree, as an architect I like to present say the logical layer, separate from the physical realization layer, but still be able to add information in a compartment in summary so it can be all conjoined.

The related element is not flexible enough as you cannot use it in custom shapes etc. and even if you use it in standard native shapes, like UML component, it does have positioning etc. so when you display a db schema component within a dbms component, it overlaps the writing

Maybe Sparx staff - could we make tag drops downs dynamic retrieved from SQL?
I don't think that would be too difficult, and that way it will solve many of my problems including this one.

i.e. DBMS element component, tagged drop down list returning list of DBMS technology e..g Oracle, SQL Server etc.

User selects it and we simply display it on the element in a compartment in a user defined shape. Dynamic so if a new technology is added, next time selecting from tags it is selectable.

Please please please implement by next Tuesday.
One thing about the Sparx data model, it is incredibly intuitive.

Pages: [1] 2 3 4