Connector
To configure the connector, from the Project Explorer select Connect, Connectors.
Click Add
Select Emerson Automation Solutions, DeltaV Event Chronicle
Click OK
 |
Primary Database
This setting defines the SQL Server connection where the DeltaV Event Chronicle is configured to log to. Use the browse button […] to define the database connection.
By default, when browsing, the Server name is set to the local machine plus “\DELTAV_CHRONICLE”. If the Event Journal is on another machine, replace the local machine name with the other machine name but leave the rest. When browsing for the Server name, the instance name “\DELTAV_CHRONICLE” may not appear. If it does not, it will have to be manually added.
In newer versions of DeltaV the Port Number is not default and should be specified as 55114. Also, only Windows Authentication is supported. If you are connecting remotely, you must be logged on as a user that is valid on the machine where the Event Journal is running.
The Database should always be set to EJOURNAL.
Table/Column
Once the Primary Database is configured, set Table to Journal with Date Column set to Date_Time and Date includes Time checked.
Settings
The Settings button opens the Settings dialog that defines characteristics of the database that are used to retrieve data.
 |
Typically, these settings are defaulted correctly for SQL Server.
If queries timeout, increase the Client Wait Time.
The delimiter and timestamp settings are typically filled in automatically for the database and can be modified for other databases.
The Date/Time Storage settings define how timestamps are stored in the database. Using this setting the timestamps are manipulated when data is retrieved so that local timestamps are submitted in and returned.
Many databases require the Date format to be YYYY-MM-DD so that no interpretation needs to occur based on the Region settings of the Windows Operating System. It is recommended to always have this option checked.