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.


Topics - BCGoitcwoodard

Pages: [1]
1
General Board / Joining t_connector with t_object, etc.
« on: October 30, 2024, 06:30:12 am »
I am writing a repository query to obtain "data element lineage".  I have one model in XML and another imported from Oracle.  I have mapped the source/target relationships in Sparx using connector_type = 'Information Flow' as the base class and a custom stereotype = 'ETLMapping'.
We have mapped the source XSDelement(s) to the destination database columns.

(An oversimplification) It seems like when I select the connector_id, the XSDelement name (as an attribute of the XSDelement), and the database column as an attribute of the table), I am getting too many rows returned.

I have seen that an attribute object_id is equal to the object_id of the parent, and that the start_object_id and End_Object_id of the connectors are equal to the source and destination object_id(s).

Am I missing something?

Thanks in advance.
CCW

Continuing...

Here's the query as I described.

Code: [Select]
[size=8pt]
With cte_workday_etl_package_diagram as
(select
p.Package_ID
,p.Name Package_Name
,d.Diagram_ID
,d.Name Diagram_Name
from t_diagram    d
inner join t_package p on (d.Package_ID = p.Package_ID )
where p.Name = 'Workday ETL Mapping'
) --returns 4 rows

, cte_workday_etl_diagramobject as
(select distinct
do.Object_ID
,etldo.Object_Type
,etldo.Stereotype
from t_diagramobjects do
inner join t_object etldo on (etldo.Object_ID = do.Object_ID)
where do.Diagram_ID in
(select pd.Diagram_ID
from cte_workday_etl_package_diagram pd
)
and
(etldo.Object_Type = 'Class'
and etldo.Stereotype in ('XSDComplexType', 'Table')
)
) --13 rows, source and destination containers intermingled.

, cte_workday_ETLMapping_connector as
( select distinct
conn.Connector_ID
, conn.Start_Object_ID
, conn.End_Object_ID
from t_connector   conn
where
conn.Start_Object_ID in
(select Object_ID
from cte_workday_etl_diagramobject)
and
conn.End_Object_ID  in
(select Object_ID
from cte_workday_etl_diagramobject)

and conn.Connector_Type = 'InformationFlow'
                and conn.Stereotype = 'ETLMapping'
) --70 rows- sounds okay

select * from cte_workday_ETLMapping_connector etlconn2
inner join t_object so on (so.Object_ID = etlconn2.Start_Object_ID)
inner join t_object eo on (eo.Object_ID = etlconn2.End_Object_ID)
-- -- -- -- -- -- -- -- TESTED OK ABOVE HERE -- -- -- -- -- -- -- -- -- --
        -- -- -- -- -- -- -- -- -- 70 rows returned. -- -- -- -- -- -- -- -- -- -- -- --

--inner join t_attribute sattr on (sattr.Object_ID = so.Object_ID )
--inner join t_attribute eattr on (eattr.Object_ID = eo.Object_ID )
;


When the last two commented lines are added back into the query, the result set goes from 70 rows to 127598 rows.


2
Trying to create a matrix mapping database view columns to database table columns.
How does the EA repository represent a view column?  What is the join condition for navigating from the view column to the parent view object? 

I see that I have created connectors from table columns to XSDElements, but I'm stuck trying to connect table columns to view columns.

Thank you,
CCW

3
I retrieve object properties like column length, etc., and especially Notes from SQL Server repository for a user walkthrough. The Notes contain the definitions obtained from the users.  But I get things like this "<font color="#424242">The medication given to the patient</font>."
How can I set/reset all fonts (typeface, size, color, etc.) for all objects in the entire model? It's a bit tedious to manually change these for every "offending" piece of text in the thousands of columns in the model!

I feel like I've tried all of the options in the EA UI.

Thank you in advance,
CCW

4
General Board / EA - SQL to show hierarchy of packages?
« on: April 06, 2024, 02:29:11 am »
Hi -  Can someone share a SQL (SQL Server) query to show the hierarchy of packages in a "project"?  A query to run against the Sparx repository.
Thank you,
CCW

5
We have been using Sparx EA for a few years - ver 15.1 currently.  Some users have EA installed on their local workstations.  Other users run EA that is installed on a shared Citrix machine.
I am having a problem where a project model created on a Citrix box and using the EA-JSON add-in cannot be opened on a non-Citrix user's workstation running EA.
Trying to import an MDG technology (resource), I do not have a folder/URL containing the xml for EA-JSON.  I believe our access to the registered users' section of your site has expired.
Thank you,
CCW

6
General Board / Where to find NOTES for an object in the repository?
« on: September 15, 2021, 05:08:58 am »
Not in t_object?

Also, Can we find documentation of the usage of PDATA1..PDATA5columns of t_object?

Thank you,
  CCW

7
An invalid character was found in text content.

How do I attach a screenshot?

8
General Board / How to convert class objects into attribute objects?
« on: September 21, 2020, 09:44:20 pm »
I have a package with many DataElement objects.  I captured them during requirements gathering.  I believe that this is a stereotype of Class.  Now I would like to treat these objects as Attributes, e.g. columns in tables.
How can I convert these objects from “class instances” to “attribute instances” which could be moved into other classes like entities or tables?

I did a lot of csv imports to establish values of important tags on the DataElements.  I would not like to lose this work.
Alternatively, can I copy the tagged values of class objects like DataElements over to become tagged values of Attributes like database columns?
Thank you,
CCW

9
Can Diagram Links as navigation cells refer to target diagrams in different projects than the host diagram?
Thank you.

10
General Board / Using EA for an Enterprise Repository
« on: May 08, 2020, 03:33:31 pm »
Greetings!  I am the Data Architect for Baltimore County, Maryland, USA.  In launching a Data Architecture program, I first surveyed the market for a tool to use as a metadata repository.
We purchased licenses for Sparx EA Unified Edition.

I have a number of questions as I learn the tool..  and how to apply it in various situations.  I am running on several tracks at the same time...  which actually causes me to explore different EA perspectives, element types, etc.

I have created a number of projects and models, both locally and in an EA repository in Oracle.

My first question:  What is the recommended approach for managing enterprise models and project-specific (not necessarily EA projects) models?  Do you establish one central repository of all models, both an enterprise (i.e., integrated/concolidated) model of each type and the set of project models in progress, and then perform integration merges from project models into the enterprise models - all within the central repository?

  (From the EA documentation, it seems that "project" and "model" are used interchangeably.  I think I can see that multiple models can be contained within a single project. This would be the case with the implementation I describe above.  Is there a size issue or other issue with this implementation?)

I have not been able to get up to speed on model management and version control yet.  :-\

Any comments or helpful links would be appreciated.

Thank you,
CCW

Pages: [1]