If table exists in database but does not appear in Vision Data Model
Pre-Requisites
- ERP.xml file
- Download the "ERP.xml" file from here Download Files
- ***note*** download the file that matches the data model you want to edit. (this example is for an ERP Data Model update.
Step-by-Step Guide
...
- Data Model Editor
...
- If you need to to download tool go to Z:\easy_query
...
Step-by-Step Guide
Access the Data Model Editor tool.
Click on Model menu then select Open and select the .xml file you downloaded in the Pre-requisite step above.
Aisha add a screen shot of the window where ERP.XML file is opened
Click on the Model menu then select Model settings - verify the Model name and data source in the connection string by testing the connection. If successful connection click OK.
Aisha NOTE: the Data Source should be the as follows, these settings use the current columns available as maintained by the Development Team
Data Source=CULPRNSQL08;Initial Catalog=ERP_Dev;Persist Security Info=True;User ID=ERP_AppUser;Password=Grandizergo1
Click on Table menu option and then choose add table(s) by selecting .
In the Add table(s) dialog, select the table(s) you want to add.
...
On the Tables and Links tab, click on the primary table first (Table1) then click add link and choose .
On the Link: control form for
- Table2: Choose the secondary table
Aisha add a note to choose Conditions Builder radio option
...
- Join Type: Choose the type of join (Inner, Outer, Left, Right, etc...)
...
- Join Conditions: Choose Conditions builder
choose Conditions Builder radio option
Next in In the dropdown next section (see image below) choose the Foreign Key(FK) that is the Primary Key(PK) in the secondary table
Then click add condition to complete the join Fields to Join the two tables and the Operators that associate the fields.
- Condition left part is Field from Table 1
- Condition right part is Field from Table 2
- Operator values are =, <>, >, <
Then click Add Condition button to add the fields selected - Repeat previous two steps for each join Field you need to Join
When all the joins for fields to join the two table tables are compete, click the OK button to save and close the form.
Next click on the Entities tab - Name the new entry but make sure to keep the name structure the same for this new entity as the other existing ones
...