Prepare the ACM Server to Export Data to AVEVA Measurement Advisor

Create a History Output Object to prepare your data to be exported to AVEVA Measurement Advisor.

To create and configure a history output object in ACM

1. In the ACM Configuration tool, on the main ACM panel, right-click and from the context-sensitive menu that appears, select Add > History Output > AutoSol EFM Database. (If required, update the default name of the EFM database.)

   

2. Under the Configuration tab's General subtab, enter a Description.

   Under the Database subtab, enter your Provider String to be used to connect to the database.

   This can be generated using the ACM Database Provider String Builder.

   To do so, do the following:

   1. Open the ACM Database Provider String Builder.

   2. Select Browse Providers, then navigate to the Connection tab.

   3. In the Select or enter a server name, type the Microsoft SQL Server name.

   4. Select Use Windows NT Integrated security.

   5. In the Select the database on the server dropdown menu, choose AutosolCM.

   6. Use the Test Connection button to verify your settings.

   7. Select OK.

      The Provider String Builder will produce the provider string, which you will paste in the Provider String field on the Database tab.

3. Finish your database configuration, leaving the default values selected.

4. Select the SQL subtab. Enter the information required.

   Note: These values can be changed. If you do change them, you will need to update the settings in the ACMDataMapping.json file.

   

5. Select the Records subtab. Enter the information required.