Messages

1

General Board / Re: Modelling attribute dependencies for an ETL pr

« on: May 03, 2011, 01:06:27 am »

I prefer using the "link to element feature" with the trace relationship because it shows the data flows graphically between table and databases.

Of the two solutions, that's what I like most too, because it contains the data "two ways".

But for now, I after experimenting some more, I don't manage to properly document them either in RTF or HTML

To be honest, the output format RTF/HTML is not crucial, but I need "some" way of spitting out a report to document the system

1 - RTF:
I can report on connector linked features, but I can only show the name/value/stereotype and type. And I don't see a way to override the "value" evalution to not show as "<<column>> ColumnName" but instead show the owner table.

2 - HTML:
The tags that can be used seem to be very limited.
As per the documentation (http://www.sparxsystems.com.au/downloads/resources/booklets/reporting_uml_models.pdf), the "link item" section has no tags for showing any connections with their linked elements; and neither has the "content - attributes item".

There is a way to document tagged values on the attributes (cfr. Geert's solution), but that just documents as (for example) "<<column>> ColumnName>>" (omitting the owner table) as described earlier. And again, I don't find a way to adapt the behaviour of the #TAGS# structure.

2

General Board / Re: Modelling attribute dependencies for an ETL pr

« on: April 29, 2011, 10:20:14 pm »

Thanks, I'm getting there!

I created such a structured tagged value with in the "detail" definition:

Code: [Select]

Type=RefGUID;
Values=Attribute,Operation;
Indeed I can now select select an attributes using the [...]

But when I generate HTML documentation, it now shows, in the attribute details of the table page:

[...]
public static varchar(10)
  Volgnr

Details:

<<key>>Ordered
SourceSystemDependency=«column»Volgnummer
[...]

As you can see, I lost information about the actual source table. Can I fix that? (And, by the way, I already know it's a column. Don't need that explicit stereotype, but that's a detail.

3

General Board / Re: Modelling attribute dependencies for an ETL pr

« on: April 29, 2011, 09:18:00 pm »

Another way to create relations between attributes is to use tagged values of type "RefGUID".

Geert

Thanks for the answer, but I'm afraid I lost you there.

You're saying I add tagged values to these relations? Or to the attributes? I don't see a "type" specifier. I would paste the value from "copy node GUID to clipboard" option when I right click something, but I don't manage to do this for table attributes.

4

General Board / Re: Modelling attribute dependencies for an ETL pr

« on: April 29, 2011, 09:03:02 pm »

Nice, I didn't know that could be done. It's definately better than creating another set of "objects". In the diagram that relation is indeed visualizing source/attributes involved. But this information still doesn't appear in the HTML documentation - these relations appear in the "other links" section of the table documentation, but they don't show the source/target attributes etc.

Can I adapt the HTML templates so that these (flow/dependency) relations appear for example right with the attribute detail information, in the "attributes" section of the table documentation? (The HTML template editor scares me, to be honest...  )

Thanks,
M.

5

General Board / Modelling attribute dependencies for an ETL proces

« on: April 29, 2011, 12:12:56 am »

Hi all,

I am evaluating the product to model data dependencies for an ETL process for a data warehouse. In other words, I want a way to document data "lineage" dependencies for fields in database tables.

The idea is that both data warehouse developers and source system developers would have a centralized place for inter-system impact analysis.

To do so, I reverse engineered the source database system into one model, and created my data warehouse database model in another.

Alas, I don't find a way to create "dependencies" from the table fields in my "data warehouse" db to the table fields in the "source system" (other than just typing them in the attribute notes, but I can do that in excel, don't need EA for that!)

Or I am wrong?

I also tried it another way: instead of creating attributes for my table fields, I created child "objects" which I could then connect (using dependency connectors) to the tables in the source system model, and model the source system field it is dependent on, as the connector's "name". At least I can model that, and create an RTF report on these dependencies.

However, this is still not really what I want:
- I cannot assign datatypes (etc...) to these uml objects the way I do that with table attributes
- These dependencies are not included in the HTML documents (which I prefer over the RTF stuff)

Does someone have some hints on how to approach this kind of modelling? I know, the above explanation is maybe not enough, but if someone would like to help me out, I'll send/post the EA project/screenshots to further explain

Thanks!