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 ... 5
General Board / Showing notes from Inherited obects
« on: December 04, 2018, 07:38:04 pm »
Hi, Does anyone know if it is possible to show the notes from an inherited object like the attributes feature in tags?

Ideally I would like the notes either to be copied to the child via an MDG Shape script, or a way to display the parent notes and the child notes while connecting a note to a child on a diagram.

Thanks for any help.

General Board / Re: Exporting the results of a SQL query
« on: November 21, 2018, 08:19:32 pm »
Just tried it out - worked pretty well - thanks, I'm not sure how to export however, but I shall check out your website link

General Board / Re: Exporting the results of a SQL query
« on: November 21, 2018, 08:11:13 pm »
Thanks Geert,
I've never written a SQL search query before (I am assuming it is in EA?) , I shall have to investigate!
Thank you.

General Board / Exporting the results of a SQL query
« on: November 18, 2018, 03:35:18 pm »
Hi Everybody,
Have accepted that Sparx Class diagrams doesn't support logical model foreign/primary composite keys, I have had to grin and bear it.
Another question I have, still being a fairly newcomer to Sparxs, is can you output the results of a report in CSV?

I know we have an export csv function, but you cannot apply complex SQL to that (e.g. doing sub queries based upon result etc.).

I can (and am)  doing it in the report with SQL fragments, but the fields I am producing (30+) are just too big for the landscape, besides I do want it as an excel/csv anyway that can be filtered and graphically represented by data owners and stewards.

Any suggestions?
The only thing I can think of is to bolt a Reporting engine on the front of the database Hyperion, SQL Reporting Services etc.. but then that gives us 3 different and inconsistent methods of extracting meta data - reports, export CSV, and reporting.

Thanks in advance

General Board / Re: Page Orientation in a template
« on: November 16, 2018, 12:02:30 am »
How do you actually change the mode to landscape though after you insert the section?

General Board / Re: Connector thickness
« on: November 02, 2018, 07:44:21 pm »
I tried

As suggested by the Sparx team and it worked perfectly - thank you.

General Board / Re: Connector thickness
« on: November 02, 2018, 07:36:13 pm »
This seems to work ok when I make the connection between elements on the same diagram, but when I drag those same elements onto a different diagram, the connector retracts to 1 point.

Is that different diagram created with your MDG?

Yes AND out of the box diagrams also

General Board / Connector thickness
« on: November 02, 2018, 05:09:14 am »
Hi Everyone,
I recently created created a connector profile in an MDG, with a line thickness of 3 points.
This seems to work ok when I make the connection between elements on the same diagram, but when I drag those same elements onto a different diagram, the connector retracts to 1 point.

Is there a way I can do this in mdg? I have tried setting setpenwidth to 3 and tried setpen


but the connector all except the arrow head dissapears.

Thank you for any help.

General Board / Re: Logical Data Modelling in SPARX
« on: October 22, 2018, 03:22:33 pm »
Hi does anyone know how to link UML classes in sparx with composite keys?

I'm in the process of  evaluating SPARX to see if it can provide logical DATA modelling, and before we go out to market, it would be good to know if we need to put this on the list of possible solutions or not.

The Data modelling in the extended UML sort of does the job, if I accept the technology constraints, but we also have lots of data categorisation (in the airline industry) which are currently in tags, and these don't seem to work well with entity subtypes in Shape scripts.

e.g. Class flight with a relationship to flight leg, on FlightNumber,FlightDate

Thanks, any help or pointers appreciated

General Board / Re: Logical Data Modelling in SPARX
« on: October 21, 2018, 04:24:29 pm »
Yes I've had that problem many times :-)
Richard sorry I don't want you to go to a lot of trouble, if you can point me what I should use to linke multiple attributes I'm sure I can work it out.

I just cannot find anything in google.
If I know it is done in the UML class element somehow, I'll go through everything,

But  many thanks for your help, I much appreciate it.

General Board / Re: Logical Data Modelling in SPARX
« on: October 21, 2018, 02:28:06 am »
Richard - how do you represent composite keys in relationships with UML? That is the basis for what I am struggling with.
Also I know you can define a primary key in UML, but cannot figure it out in Sparx.

I have looked through a lot of the documentation, but examples are always with a single attribute/key

Spent all day on this researching, lots of hints that it exists, but no hard and fast explanation as to how it is done.

In  the end I gave up an decided to go with the technology specific physical model of data model under extenstions, but I wanted to add attributes to it with MDG, and they don't seem to support it, so am back to square one

General Board / Re: Logical Data Modelling in SPARX
« on: October 20, 2018, 04:28:37 pm »
Hi Sunshine - -exactly there is a difference between data architecture and OOA.

It looks like then that  Sparx doesen't support logical modelling outside of the OO arena where a table can have a combination of logical elements as a primary key e.g. FlightNo, Date, and the other tables would need to reference  these with foreign keys e.g. FlightNo,Date.

In the physical/OO world we can connect with a single GUID etc. but in the logical world, that is abstract from systems and technology, we have to go with business attributes, which of course is the whole point of logical modelling.

It's a shame we will have  to take our Logical Data repository out of the enterprise repository because something so basic in logical modelling is not supported, but at least I know it can't be done instead of struggling.

I don't suppose there are any MDGs out there that provide this is there?

Thanks everyone for your contributions.

General Board / Re: Logical Data Modelling in SPARX
« on: October 20, 2018, 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

Pages: [1] 2 3 ... 5