Within 800xA History RU2 can DataDirect be used only in CS or can it also be used within History Server?
We have 800xA History RU2 installed on a History Server. According to the manual 2PAA107563-200_B_en_System_800xA_History_2.0_Administration_and_Configuration on page 103 to 107 we can use DataDirect for retrieval and visualizing the numeric and
event data. This is a quick and easy way not only to view the history data, but also to
generate reports for meaningful insight into the plant data. This includes trend
displays, shift, daily, or weekly reports, alarm analysis etc.
In the Figures we can see 800xA structures which we think implies that DataDirect is being used within 800xA. But our question is whether it is able to use datadirect within History Server itself without a client/server connection to the 800xA System. We would like to create reports with data within the History Server inside History Server itself.
Answers
Please read my previous answers and comments on your first thread.
DataDirect functions can be split in two parts; one set of functions that ONLY work on computers that are part of the 800xA Node Administation Structure (i.e. clients or servers with FULL install of all 800xA software). No license, no login, just use the ABBGetOPCDA or ABBGetOPCHDA functions with proper path as argument to retrieve any datapoint in the system's address space.
Another set of functions are available for use in DataDirect when running in non-xA nodes (which I suspect the 800xA History server itself to be). In this case, a Display Services Server session MUST be established first (username and password required). The login also requires an EXCEL_DA license to be available in the Central Licensing Server.
As far as I know, the Display Services Server software kit can only be hosted on an IM Server node.
Why not run the reporting on an xA node? The Data Collector Nodes for example? The data stored in the 800xA History server is (seamlessly) available over the History Collector Link between the xA system and the historian server.
Maybe you can use another reporting package than DataDirect?
- Smart Client?
- Something from within the 800xA History suite itself?
- Decathlon?
I am writing my own little program that reads data from a history server (OPCHDA) and writes it to a Sql Server database.
From the database you can import it to excel or another reporting tool.
If you are into C# and Sql Server, I can give you the code.
Add new comment