The assignment of program flow chart to connection type “transmits data to” is a nice feature. But on the second level the description of data using Cluster/Data model object and Protocol is quite insufficient. How to show for example the data format and the ETL tool? The most appropriate for the ETL tool is probably Application system type but the Display flow and System fact sheet report will be distorted and they, unfortunately, are not editable. And then the data format can’t be an attribute as it will affect all occurrences of the Cluster/Data model so it should be another object. But which one and which connection type among those allowed by the method of Program flow chart are appropriate?
The alternative object “interface” is actually a symbol of class. If this would be the way to go, what about the issues mentioned above?
Thanks!
Ivo
Rick Bosworth on
Personally, I use the Interface object to represent the actual interface. I use the "transmits data to" connection type to show data flowing into and out of Application System Type. I use the "uses" connection to the Application System Type to indicate the ETL software. The Interface object can have both input and output data elements associated with it. You can use Technical Terms (I use these at the logical level) or entities, attributes (I use these from the source and target DB data models at the physical level) or Documents. For complex transformations you can also attach a Module Type or IT Function Type to the interface object.
As for data types, if you use attributes from existing source/target DBs they should already have data types.