Modify the SQL Connection String

Wonderware Historian uses a SQL database as a means to interact with data on the Historian. Because of this, the connector must make a connection to that SQL server. The connector does this by specifying a set of connection string parameters. More than 50 parameters are provided to specify the connection to the SQL server. For details and usage information specific to connection string parameters, refer to the official Microsoft .NET SQL Connection String documentation online.

Follow the procedure detailed below to modify the connection string that the connector uses to connect to the SQL server.

1. On the Overview section of the PI Connector for Wonderware Historian site, click Stop connector.

2. From the Windows start menu, open the Services application. Locate the service for PI Connector for Wonderware Historian, Stop the service.

3. Navigate to %PIHOME64%Connectors\WonderwareHistorian\Configuration and open the Datsource.config.json file.

4. Locate the configuration settings for the datasource that you wish to modify. For each datasource from which the connector collects data, the file includes an entry with the datasource name and the Wonderware server from which data is collected. For example:

   

   The datasource named 'MyDatasource' is collecting data from a Wonderware Historian that resides on a server named 'MyHistorian'.

5. Within the same 'ConfigObject' brackets there is a field named ConnectionString. The default value for this field is:

   “server=tcp:${ServerName},${DBPort};Trusted_Connection=no;database=RUNTIME;connection timeout=120"

6. The default parameters are required. However, all fields may be modified, and additional parameters may be added by appending to the existing, semi-colon delimited list.