HistoryItems

[sesa450478_brid]

Hi everyone,

I have my own SQL database with historical data from 3rd party, and I want to have these historical data  on the Enterprise Server as Trend Log.

For that I created a program in C# and i saw/used the method "DataAdapter.HistoryItems", but i do not understand how to use that method.

Is it possible to have more information/documentation?

Thank you very much for the availability

[sesa180908_brid]

Michele,

To do what you want to do, the ES will need to be an EWS Client to a SmartConnector EWS Server.  However, the approach you are suggesting is not how you should be proceeding.  The EwsServerDataAdapter class is only used to interact with the native SmartConnector EWS data tables.

In order have your external DB supply data via EWS Serve, you will need to create a custom EWS Server Extension.  This type of data flow is described in abstract in the SmartConnector Developers Guide.pdf section 4.2.  Details on how to develop such an Extension is described in section 5.7 of the same document.  In your case you will need to provide a custom implementation of the MongooseGetHistoryProcessor instead of what is shown in the example.  The steps are the same though. 

If you have more questions feel free to post them here.

[sesa450478_brid]

OK thanks, I understand how to continue my work, but i have another question.

How and when i should use the method "DataAdapter.HistoryItems" ?

[sesa180908_brid]

The EwsServerDataAdapter class provides methods and properties to create, retrieve, update, and delete data from the local SmartConnector database for the logical EWS Server it is instantiated for.  It is also used to control how the EWS Server is provisioned.

The HistoryItems you refer to is an IQueryable<EwsHistoryItem> property which allows consumers of the class instance to execute LINQ queries to retrieve items from the database.  It will only return data from the local database and not an external source (as is the case in your situation).

The standard EWS Server controller Processors use the EwsServerDataAdapter class to serve data requested by EWS clients (such as an ES or AS).  Because your data is an an external database, you need to change this behavior by writing a custom EWS Server Extension as described previously.

Hopefully this clears things up.

[gosloto]

Read it! https://community.se.com/t5/SmartConnector-Forum/Unable-to-poll-alarms-from-Get-AlarmEvents-gosloto-in-Smart-Connector/td-p/409428/jump-to/first-message We hope you find it informative. If you get any information from this, be sure to let us know.