Generate the Data-Tier Application Package (DACPAC)

You must have the EFM buffer database already created before generating the DACPAC.

Before you begin

Install the Tables.sql file so that the stored procedures necessary for the AVEVA Measurement Advisor Data Connector for Autosol Communication Manager (ACM) can be generated.

1. Open a PowerShell window as an Administrator.

2. Go to the following location:

   $env:DNAInstallRoot\CloudData\config\DacpacTemplate

3. Execute the command:

   sqlcmd.exe -d EFM -E -i Tables.sql -S <SQL server name>

Generate a DACPAC

4. Open a PowerShell window as an Administrator.

5. Navigate to the folder in which the AVEVA Measurement Advisor Data Connector for ACM is installed (%DNAInstallRoot%\CloudData\bin).

6. To compile the .dacpac file for AVEVA Measurement Advisor, execute the following command:

   ACMDataInterfaceGenerator.exe

   Note: When you execute ACMDataInterfaceGenerator.exe you may get the error, "Failed to get proc parameters.skip proc <proc name>. Error: The key {<GUID>} was not found in the key ring." If so, regenerate your EncryptedACMConnection setting for the buffer database in the ACMsettings.json file, see Encrypted Microsoft SQL Server Connection Strings for ACMsettings.json.

   Since the ACMDataInterfaceGenerator process is a compile (build) of the DACPAC file, the system may generate some warning messages during the build. You should not see any other error messages.

   The system generates the ACM_Connector.dacpac file to %DNADataRoot%\CloudData\config\DacpacTemplate.