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 - Paolo F Cantoni

Pages: [1] 2 3 ... 394
General Board / Re: View indexes script
« on: January 18, 2018, 05:41:38 pm »
I don't know what "materialized views" are, but here's an example on how to create indexed views in SQL server.

Thanks, Geert,

It looks like a SQL Server "Indexed View" is functionally equivalent to an Oracle "Materialized View" and consequently is a dynamic table in all but name.  Like Trump's Media Spokesperson calling a non-fact an "alternative fact".  It's either an objective fact or it isn't.  These kinds of objects are tables whose contents are maintained by means of triggers in other tables that respond to the "query specification".  They are VERY USEFUL but are just tables - dynamically maintained by the RDBMS.

The problem appears to be that EA doesn't recognise them as "tables" and, consequently, doesn't reverse engineer their indexes.


So I changed the ODBC driver to SQL Server Native Client 11.0 and things started to improve.  But I've just noticed that Reflexive (that is back to the same table) FK associations aren't being imported.  They are present in the DB and will show up under the SQL Diagramming section.  They are present on the imported table as stereotyped FKs, but associations are nowhere to be found.

Anyone confirm or deny this?


General Board / Re: How to become and Enterprise Architect.
« on: January 18, 2018, 11:23:09 am »

Generally those titled Enterprise Architect are very entitled leading to poor engagement with the business and other architects :-)
To paraphrase Descartes:
"In titulo, ergo sum" - I am thus entitled, therefore I must be...


In response to Paolo's question, the instructions provided to us were to run up MS Access and Open the EAP file, which converts the  EAP to a .aacdb file, so my use of the term 'export' was misleading.

Geert (Sherlock) thx for your efforts, but the suggested change doesn't produce the missing items. What I intend to do next is compare the output columns for the original query and the new query and identify the EAP elements that it isn't finding and deduce why the select statement isn't finding these 13 items.
We use MS Access with Linked Tables so that the source EAP (or another repository) file doesn't need to change.  We DO use .accdb MS Access DBs but they still link to the repositories via Linked Tables.

If the intent was to transfer the repository from a .eap to a .accdb repository, then the Transfer Project functionality should have been used.


General Board / Re: View indexes script
« on: January 18, 2018, 10:40:30 am »
As I read the whole set of responses, my original assertion stands.  (If you accept that "materialised views" are dynamic tables - as per response #5 in the link).

What is the syntax for defining an index directly on a view (that is not materialised)?


Hi there,

Some time ago an SQL query was devised to parse an exported EA DB to Microsoft Access: The query took 30 minutes to run:

(my emphasis)
Exactly what does the highlighted phrase mean?


General Board / Re: View indexes script
« on: January 17, 2018, 05:43:03 pm »
I didn't know Views had indexes.  They use indexes (in the underlying tables), but don't have any themselves.  Even "Materialized" Views aren't Views, per se, but dynamic tables.


To verify a stereotype definition -> once you save your profile, you can import it in your Resources Window -> UML Profile, this will allow you to drag and drop your stereotypes into a diagram and verify your results.

FWIW - I've noticed that The color of your extended stereotype goes to the native color is due to the order of stereotype (in the stereotypeex field), When we remove the Archimate stereotype and reapply the color will be usually corrected.  But this isn't always a reliable solution.

(my emphasis)
Which is (one of the reasons) why we stopped using multiple stereotypes getting on for a decade ago.  Each element has only ONE stereotype (used to define the metatype).  All other uses of "stereotypes" are catered for by using various properties (including tagged values).


General Board / Re: Diagram Details hide when publishing
« on: January 17, 2018, 10:47:59 am »

Is there an option or setting where I can show Diagram Details in Enterprise Architect but when I copy to clipboard or publish that I can hide the details?

Eamonn J.
Hi Eamonn,

We have forsaken the Diagram Details feature for the use of the Diagram Note Element.  We make it non-selectable and so it WON'T appear in the clipboard (unless we want it to by making it selectable).

It's been SO long since I use the Diagram Details that at first, I wasn't sure what you were talking about.   ::)


General Board / Re: Hyperlink as an element in Project Browser
« on: January 11, 2018, 10:45:05 am »
We would like to make a list of hyperlinks, and refer to these hyperlinks from multiple diagrams, like other elements. Is this possible?
You can collect the hyperlinks you want to share into one or more diagrams and then get your users to copy and paste into the relevant diagrams.  As qwerty says, you can't "see" them directly in the browser, but this can be the next best thing.


General Board / Re: SQL to find mult connectors between to elements
« on: January 11, 2018, 10:40:11 am »
That will output all elements with more than one connector. I guess the OP is after a list of connectors for two distinct element?

No it won't, see the grouping.
It will output all element/connector details for all elements that have 2 or more of the same kind of connector to the same element (which makes them a candidate for duplicate connectors, although there might be valid exceptions)

Candidacy is relatively easy.  Actually determining whether two connectors are semantically the same (and perhaps consolidating properties that are not semantically significant) is non-trivial.  We have a version which we are testing as part of our element consolidation process.


General Board / Re: Running script from an specific Element
« on: January 10, 2018, 06:03:33 pm »
Hello Paolo,

We can use context item event to get the script from an element.

We can execute the script using Script Control Class (there are certain limitations)


Thanks, Nabil,

so it's not via the UI directly.


General Board / Re: Running script from an specific Element
« on: January 10, 2018, 05:32:48 pm »
As geert mentioned scripts are stored in model.

but if necessary, you can store scripts in a tagged value of that element.

Best Regards,
Interesting!  How do they get executed?


I guess in the latter case I did not provide a name for the action, so it just has a type.
Have you tried deleting the name in the former case?  Now that you've observed the latter behaviour?  If it's consistent good, else maybe another EAUI?


Hi Geert,

Now I have found the reason of my problem. When I am using the "distinct" in my query, it returns only 255 characters of the Note file of the Object. This looks strange to me.
But now I have to modify my query in order it returns a single row for one object.

Thanks a lot for your support
Hi Andreas,

Not so strange...  I believe what is going on is that when you use "DISTINCT" it needs a key mechanism in order to determine uniqueness (distinctiveness).  You can't have a normal key on a Notes field (Memo etc) so it creates a transient key - which can't be longer than 255 characters (since it's a string field, not memo).  It returns the key value, NOT the Notes value.


Pages: [1] 2 3 ... 394