If table exists in database but does not appear in Vision Data Model
Pre-Requisites
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
Access the Data Model Editor tool. (If you need to to download tool go to Z:\easy_query
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 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 the table(s) you want to add.
On the Tables and Links tab, click on the primary table first then click add link and choose the secondary table
Aisha add a note to choose Conditions Builder radio option
In the join condition section, choose the type of join (Inner, Outer, Left, Right, etc...) select the type of join you want from the dropdown (see image below)
Next in the dropdown (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 - Repeat previous two steps for each join you need
When all the joins for the two table are compete, click the OK button to 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
Save the file on your computer. Then go back to the Download Files and upload you new .xml file there to replace the old
Next follow the steps found here Data Models; follow Download a New ERP Data Model - Option #1 on that page.