Configure the Data Access Layer (DAL)

To configure the DAL on the AVEVA Measurement Advisor and RCS_XFER servers

1. On each of the Measurement Advisor and Remote Client Service (RCS) Transfer (RCS_XFER) servers, navigate to %DNADataRoot%\Shared\config\DAL.

2. Create (or edit if they already exist) the following two files in each DAL system directory that is running the GasMeasurement service. For example,

   %DNADataRoot%\Shared\config\DAL\primarydss\remote_RCS_XFER or

   %DNADataRoot%\Shared\config\DAL\backupdss\remote_RCS_XFER

   • DALConfig_Default_remote.xml

   • DALConfig_GasMeas_XFER_remote.xml

     Note: The remote_RCS_XFER folder must start with remote_.

3. Open the DALConfig_Default_remote.xml file and add in the following configuration:

   Notes: When configuring the system to connect to a cloud endpoint, update the AllowedSystemLinkConnections to include GasMeasCloud_XFER:ESQL instead.
   
   The port number used in RCSPortNumber must be different from other remote client services if the same system is running a remote client service or multiple remote client services. For example, if the default RCSPortNumber is 53031, you can assign 53032 as RCS_XFER. The name used in the RCSHostName should be the name of the RCS_XFER service for the system DAL directory this file is located in. For example, primarydssRCS_XFER for the file in DAL\primarydss\remote_RCS_XFER or backupdssRCS_XFER for the file in DAL\backupdss\remote_RCS_XFER.

   <?xml version="1.0" encoding="UTF-8"?><DALConfig xsi:schemaLocation="http://

   www.telvent.com/DALConfig DALConfig.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchemainstance"

   xmlns="http://www.telvent.com/DALConfig">

   <DriverCredentials>

   <Credential ValidateOnShiftChange="yes" Type="Windows" Name="Default"/>

   </DriverCredentials>

   <RemoteServiceConfigurations RCSDefaultStartupAlias="Default">

   <RemoteServiceAlias RemoteName="Default">

   <RemoteServiceProperty Name="RCSInstanceName">RCSDefault</RemoteServiceProperty>

   <RemoteServiceProperty Name="RCSHostName">lssdcdssRCS_XFER</RemoteServiceProperty>

   <RemoteServiceProperty Name="RCSPortNumber">53031</RemoteServiceProperty><RemoteServiceProperty Name="RCSMaxConnections">50</RemoteServiceProperty><RemoteServiceProperty Name="RCSHeartbeatMS">120000</RemoteServiceProperty>

   <RemoteServiceProperty Name="AllowOpenConnection">no</RemoteServiceProperty>

   <RemoteServiceProperty Name="AllowedSystemLinkConnections">GasMeasCloud_XFER:ESQL</RemoteServiceProperty>

   </RemoteServiceAlias>

   </RemoteServiceConfigurations>

   </DALConfig>

4. Save the file.

5. Open the DALConfig_GasMeas_XFER_remote.xml file and proceed as follows:

   1. Add the <DriverProperty Name="ConnectionString"> tag under DriverAlias "GasMeas_XFER" and DriverType "ESQL" and "SQL" as shown below.

   2. Add the <DriverAlias Alias="GasMeasCloud_XFER"> section as shown below.

      <?xml version="1.0" encoding="UTF-8"?>

      <DALConfig xmlns="http://www.telvent.com/DALConfig"

      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

      xsi:schemaLocation="http://www.telvent.com/DALConfig DALConfig.xsd">

      <DriverCredentials>

      <Credential Name="Default" Type="Windows" ValidateOnShiftChange="yes"/>

      </DriverCredentials>

      <DriverAlias Alias="GasMeasCloud_XFER">

      <DriverType Type="ESQL">

      <TransportType>Remote</TransportType>

      <DriverProperty Name="RemoteServiceAlias">default</DriverProperty>

      <DriverProperty Name="CertificateType">SystemLink</DriverProperty>

      </DriverType>

      </DriverAlias>

      <DriverAlias Alias="GasMeas_XFER">

      <DriverType Type="ESQL">

      <TransportType>Remote</TransportType>

      <DriverProperty Name="RemoteServiceAlias">default</DriverProperty>

      <DriverProperty Name="CertificateType">SystemLink</DriverProperty>

      <DriverProperty Name="ConnectionString">Server=%RDBHost(CloudData)%,%RDBPort(CloudData)%;Trusted_Connection=yes;WSID=%ClientHostName%;Application Name=%ClientAppName%;language=English</DriverProperty>

      </DriverType>

      <DriverType Type="SQL">

      <TransportType>Remote</TransportType>

      <DriverProperty Name="RemoteServiceAlias">default</DriverProperty>

      <DriverProperty Name="CertificateType">SystemLink</DriverProperty>

      <DriverProperty Name="ConnectionString">Server=%RDBHost(CloudData)%,%RDBPort(CloudData)%;Trusted_Connection=yes;WSID=%ClientHostName%;Application Name=%ClientAppName%;language=English</DriverProperty>

      </DriverType>

      </DriverAlias>

      </DALConfig>

6. Save the file.

7. The files configured in the previous steps should be copied to each server running the RCS_XFER service in the domain where the GasMeasurement service is running.

8. Restart or start the RCS_XFER service. Check the log to verify that it starts with a SystemLink Uniform Resource Locator (URL) as shown below:

   2017-05-12 16:32:52.662 RCS_XFER.Default.56572 [TID=0xed68] - starting RCSHost net.tcp://dssRCS_XFER:53031/RCSDefault/RCSHost/SSO... {d:\Telvent\DNA\RCS\source\RCSServiceHost\RCSHost.cs:337}

   2017-05-12 16:32:52.662 RCS_XFER.Default.56572 [TID=0xed68] - starting RCSHost net.tcp://dssRCS_XFER:53031/RCSDefault/RCSHost/SystemLink... {d:\Telvent\DNA\RCS\source\RCSServiceHost\RCSHost.cs:344}

   2017-05-12 16:32:52.662 RCS_XFER.Default.56572 [TID=0xed68] - ...with certificate: OASyS_DNA_SystemLink {d:\Telvent\DNA\RCS\source\RCSServiceHost\RCSHost.cs:345}