A
AiS400
I am trying to create a data source diagram. I have multiple tables and
views located on several platforms (iSeries, Sql Server). I am able to get
the table and view definitions onto my diagram.
On a view, I go into database properties, columns, EDIT, I select Known
column in another table or view and select the corresponding column from a
table and select OK.
How do I see that relationship in my diagram? -OR- is there a relationship
shape I can use to show Column from Table A connects to Column in View B.
To give a little more detail to what I'm doing. We have an Excel
spreadsheet being parsed to populate a database table on an iSeries. A view
is then being created over that "spreadsheet table" and some other existing
ERP tables on our system. That information from the view is being sucked up
into a SQL Server table which is being used by our web aps to gather data.
I want to show a representation of the "spreadsheet table" and of the view
and of the SQL table to show the column mapping.
views located on several platforms (iSeries, Sql Server). I am able to get
the table and view definitions onto my diagram.
On a view, I go into database properties, columns, EDIT, I select Known
column in another table or view and select the corresponding column from a
table and select OK.
How do I see that relationship in my diagram? -OR- is there a relationship
shape I can use to show Column from Table A connects to Column in View B.
To give a little more detail to what I'm doing. We have an Excel
spreadsheet being parsed to populate a database table on an iSeries. A view
is then being created over that "spreadsheet table" and some other existing
ERP tables on our system. That information from the view is being sucked up
into a SQL Server table which is being used by our web aps to gather data.
I want to show a representation of the "spreadsheet table" and of the view
and of the SQL table to show the column mapping.