Data Models

Use the Data Model Designer screen to configure database schema configurations.

Open

Creating a New Data Model

1. Access the Vision Main Menu.

2. Click the Tools / Settings  drop-down.
   
   
   

3. Select the Manage Data Models / Connections option.
   
   
   

4.  Click New Data Model.
   
   
   

5.  Specify a Name of the Data Model. For example: Aeros ERP

6. Optional: Specify a Description of the Data Model.
   
   
   

7. Specify a Connection option. View Connections to create a new Connection.
   
   
   

8.  Select a Type option. For example: XML

9. Optional: If using an XML type and connecting to an Aeros ERP database, check the Include Extended checkbox. This will add the Item Extended Information fields to your Data Model if desired.
   
   
   

10. Specify a Source/Command value.
    
    

    1. If the type is XML, specify the path of your pre-configured XML-based Data Model.

    2. If the type is View, specify the name of the View. For example: vwVMyCustomView

    3. If the type is Stored Procedure, specify the name of the Stored Procedure with it's required parameters. For example: spMyProcedure '01/01/2016'

11. Click Retrieve. The system will attempt to load the XML/View/Stored Procedure text into the Model Text field.
    
    
    

12. Do NOT modify the Model Text field. This is generated by clicking the Retrieve button. Overriding this text required advanced knowledge of system workings.
    
    
    

13. Click Save & Close. 

Download a New ERP Data Model - Option #1

Use this option first to ensure that the Data Model Source/Command is correct.
Once you know it is set correctly, you can being using Option #2 below in the future. 

1. Access the Vision Main Menu.
    

2. Click the Tools / Settings  drop-down.
   
   
   

3. Select the Manage Data Models / Connections option.
   
   
   

4.  Locate the Default ERP (or Aeros ERP) Data Model and click the pencil icon.
   
   
   

5. Make sure the Source/Command path is set to:
   
   

   https://getaeros.atlassian.net/wiki/download/attachments/34711475/ERP.xml
    

6. Click Retrieve.
   
   
   

7. Click Save & Close.
   
   
   

8. Click Close. 

Download a New ERP Data Model - Option #2

1. Access the Vision Main Menu.
    

2. Click the Tools / Settings  drop-down.
   
   
   

3. Select the Manage Data Models / Connections option.
   
   
   

4.  Locate the Default ERP (or Aeros ERP) Data Model and click the download icon.
   This will download the Data Model from the Source/Command path specified within its configuration.
   
   
   

5.  Click OK on the "Data Model Refreshed" message.
   
   
   

6. Click Close.