Home : Products : Hach WIMS : Interfaces : Hach WIMS Direct Server-Side Interface to Narrow Format OLEDB Source : Documentation : Topics specific to the operation of this interface : Citect Historian Configuration using an SQL View for Narrow Format OLEDB interface (Q12160)
Q13957 - INFO: Citect Historian Configuration using an SQL View for Narrow Format OLEDB interface (Q12160)

The Narrow Format OLEDB interface (Q12160) can be used with CitectHistorian© (formally known as CitectSCADA Reports) by Schneider Electric.  In order for the interface to work you will need to create a database view for the interface. 

Versions Tested:

Citect Versions (as of May 2014):

Version Testing status
CitectHistorian 4.50 Tested - May 20, 2014 - CitectHistorian 4.5 storing data in a MS SQL 2012 database.
CitectHistorian 4.40 Unknown
CitectHistorian 4.30 Unknown
CitectHistorian 4.20 Tested - Oct 24, 2012 - CitectHistorian 4.2 storing data in a MS SQL 2005 database.
CitectSCADA Reports 4.10 Unknown
CitectSCADA Reports 4.0 Unknown

Configuration Steps:

1. Create a view using MS SQL Server Management Studio.  In this example, we create "WimsView" that joins the Tags and NumericSamples tables and converts the SampleDateTime to a DateTime field. 

VIEW definition:

SELECT     dbo.Tags.TagName, dbo.NumericSamples.TagID, dbo.NumericSamples.SampleValue, NumericSamples.SampleDateTime
FROM         dbo.NumericSamples INNER JOIN
                      dbo.Tags ON dbo.NumericSamples.TagID = dbo.Tags.ID

IF you would like to create indexes on the view (for speed purposed) you will need to make sure that Schemabinding is part of the view.
To do so Alter the view.

2. Update the Source Configuration as follows:

Note - Table is set to the view WimsView.  We set the DBMS Type to Citect so that it will covert the SampleDateTime (bigint) to a datetime string.

Note - [Date] Column Name must be set to SampleDateTime because is hardcoded into the interface and part of our view.

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 10/24/2012 8:42 AM.
Last Modified on 6/19/2015 3:17 PM.
Last Modified by Ryan Rhoten.
Article has been viewed 9125 times.
Rated 5 out of 10 based on 5 votes.
Print Article
Email Article