The Historian Query Configurator
When connecting to
Wonderware Historian Server, the Historian query is configured using the graphical user interface described below.
Connect to Wonderware Historian Server or use Sample Data
You can choose if you want to connect to a
Wonderware Historian Server or if you want to test the connector using
Sample Data by clicking on the radio button shown below
You don’t need to have
Wonderware Historianinstalled when you set
To connect to a
Wonderware Historian Server the following fields need to be fill:
- Host : please enter the IP address of the server
- Username: The Username used in the SQL Server Database configured with Wonderware Historian.
- Password: The Password used with that account.
Historian Connectorcan connect to any server regardless if it is a local server or not, you need to specify a
SQL Server account typeto connect to the
If in the current session you have already connected to a Historian server, you can select it in the combobox below to auto-fill the Host Input
when all fields are filled, please click on the
Connect to Historian Button below.
Once connected, the browsing panel will be available. You can choose to connect to a Wonderware Historian Server or local Sample Data mode.
If you connect to a fresh install of
Wonderware HistorianServer, you will have to use first
Trendsoftware once, otherwise tags won’t be available for browsing
You can select the tags by clicking on the browser panel on Private Groups for example like the next screen.
When you connect to a
Wonderware Historian Serveryou can select all tags by clicking on the
All Analog TagsNode
you can select pour preferred Group Tag by rolling down the list and select the group you want.
Then, The TagNames appears right left pane like below.
Search for a Tagname
You can search for a tagname by entering the Tagname on the search text box below.
The search result is immediately shown like below
There is an optional parameter:
Exact Match. By default, it is not checked, but if you check it will perform an Exact Match search.
Then after clicking to the apply button or return key button, the result appears in the list if any matched Tag were found.
You can clear the search filter by clicking on Clear Button like below.
To select a Tag, you can click on its checkbox to select it. Once a tag is selected, it appears in the
Selected Tags panel like below
You can unselect a Tag by clicking again on its
Selected check box or you can click on the cross button in the
Selected Tags panel like below.
To make a correct
Wonderware HistorianQuery you have to select one tag at least
To set all the main
Historian query options, click on the Query Tab show below
For better performance, it is advised to avoid very largebelow
Historianqueries. please see the row limimation
Before setting your query options , you can check if your desired tags appear in the Selected Tag panel like here.
You can select the Historian Query type in the following Combobox:
The following mode are supported:
- History Values (Selected by Default)
- State Statistics
In the panel below you can configure the time setting for the query.
You have the possibility to freeze the
StartDatetime or the
EndDatetime here by checking it like below the desired checkbox, otherwise the
EndDateTime value is the current datetime and the
StartDatetime is depending from the
EndDateTime and the selected interval.
then you can configure the
Datetime by clicking on the
Datetime Picker like here for example
you can set the time by typing it in the following input
You can set the
time interval here
By default, the Freeze StartDateTime and the Freeze EndDateTime parameters are not selected
If you select both, the interval option will be disabled
Retrieval area you can set the
retrieval mode, the query
row limit settings, the
cyclic attributes and
Delta Retrieval Deadband
You can change the retrieval mode by selecting it in the following combobox (Cyclic by default)
You can change the Query row limit by changing it below
you can change the Cyclic parameters in the panel shown below
The Cyclic panel control is accessible only when one of the following retrieval is selected: Cyclic, BestFit, Average, Min, Max, Integral, slope, Counter, ValueState, Roundtrip
you can change the Delta parameters in the panel below
The Delta panel control is accessible only when Delta retrieval is selected.
To display the other retrieval options click on the
Other button like below
The other option display screen appears like below
Here, you can configure the
History Version, the
Rules Settings the
State Retrieval (available depending the retrieval mode chosen) and the
The Phantom Cycle : Do not include boundary values feature is currently not supported
Now, after setting all the desired parameters you can click the
OK button , and you should see the screen below.
Now, take a look at this section here to know how to add a Data Source.
In order to limit performance issues for huge Historian queries, a limit of
10000results is set.
When a Historian query returns more than 10000 results, it returns the first
1000 for performance reason in the data preview. To indicate that data is truncated, the field
IsResultTruncated is set to 1 like below
IsResultTruncated field value is equal to 1.(value equals to 0 when not truncated)