Use the Data Model Designer screen to configure database schema configurations.
Creating a New Data Model
- Access the Vision Main Menu.
- Click the Tools / Settings drop-down.
- Select the Manage Data Models / Connections option.
- Click New Data Model.
- Specify a Name of the Data Model. For example: Aeros ERP
- Optional: Specify a Description of the Data Model.
- Specify a Connection option. View Connections to create a new Connection.
- Select a Type option. For example: XML
- 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.
- Specify a Source/Command value.
- If the type is XML, specify the path of your pre-configured XML-based Data Model.
- If the type is View, specify the name of the View. For example: vwVMyCustomView
- If the type is Stored Procedure, specify the name of the Stored Procedure with it's required parameters. For example: spMyProcedure '01/01/2016'
- Click Retrieve. The system will attempt to load the XML/View/Stored Procedure text into the Model Text field.
- Do NOT modify the Model Text field. This is generated by clicking the Retrieve button. Overriding this text required advanced knowledge of system workings.
- 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.
- Access the Vision Main Menu.
- Click the Tools / Settings drop-down.
- Select the Manage Data Models / Connections option.
- Locate the Default ERP (or Aeros ERP) Data Model and click the pencil icon.
- Make sure the Source/Command path is set to:
https://getaeros.atlassian.net/wiki/download/attachments/34711475/ERP.xml
Click Retrieve.
Click Save & Close.
Click Close.
Download a New ERP Data Model - Option #2
- Access the Vision Main Menu.
- Click the Tools / Settings drop-down.
- Select the Manage Data Models / Connections option.
- 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. - Click OK on the "Data Model Refreshed" message.
- Click Close.