GaRoMultiEvalDataProvider - Integrate external data sources into the OGEMA evaluation framework

Last modified by David Nestle on 2019/06/19 14:16

Introduction

Timeseries data from external data bases such as SQL databases, but also cloud services or time series databases like InfluxDB, Graphite or Emoncms can be integrated into OGEMA evaluations without copying and converting all the data into the OGEMA database. To allow for this the respective time series have to be provided by a DataProvider, for GaRo-evaluations by a GaRoMultiEvalDataProvider.

Links

New GaRoMultiEvalDataProvider tutorial

  • First you shoudl define whether your data provider supports multiple gateways and whether it supports different rooms or just provides time series on gateway level. Next you have to define how to obtain information on gateways and rooms as well as the time series themselves from your data source. This could be done via a configuration resource such as SmartEffTimeSeries for the SmartEffGaRoProviderTS of SmartrEfficiency or via information from the data source as documented in GaRoMultiEvalDataProviderCSV1 .
  • There are a number of standard GaRo types documented in GaRoEvalHelper and GaRoDataType .
    If your DataProvider provides such default data types it can be most easily processed by the standard GaRo evaluation via GaRoMultiEvaluationInput#itemSelector() . This just requires that the id of the terminal GaRoSelectionItem (which is the GaRoSelectionItem on the TS_LEVEL) must be suitable to identify a GaRoDataType via GaRoEvalHelper.getDataType . As documented in SmartEffTimeSeries#dataTypeId() currently other data types are only supported by the standard GaRo evaluation via JSON reading, not via DataProviders. If your data type is of general relevance you should add your additional requried types as standard types, otherwise your data provider should override provideMultiEvaluationInput as documented in GaRoMultiEvalDataProviderCSV1.
Tags:
Created by David Nestle on 2019/02/18 14:10