If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Database Source Diagram
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. -- David Smith iSeries Consultant |
Thread Tools | |
Display Modes | |
|
|