...
To allow for special behaviour of the database import, it is also possible to use the import type "databaseSingleLocationPerQuery" or "DatabaseSingleLocationSingleDayPerQuery".
The different types do:
- database: one query to the database to retrieve all available data within the relativeViewPeriod.databaseSingleLocationPerQuery: one query per wanted timeseries to the database to retrieve all available data within the relativeViewPeriod.
- databaseSingleLocationSingleDayPerQuery: one query per wanted timeseries, per day to the database to retrieve all available data within the relativeViewPeriod.
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
<general> <importType>databaseSingleLocationPerQuery<<importType>databaseSingleLocationSingleDayPerQuery</importType> <jdbcDriverClass>com.inzoom.jdbcado.Driver</jdbcDriverClass> <jdbcConnectionString>jdbc:izmado:Provider=ihOLEDB.iHistorian;Data Source=srvHistorian</jdbcConnectionString> <user>*****</user> <password>******</password> <relativeViewPeriod unit="hour" start="-24" startOverrulable="true" end="0"/> <table name="ihRawData"> <dateTimeColumn name="TimeStamp"/> <locationColumn name="Tagname"/> <flagColumn name="quality"/> <valueColumn name="Value" unit="SI"/> </table> <idMapId>IdKETEN</idMapId> <flagConversionsId>ImportKETENFlagConversions</flagConversionsId> <importTimeZone> <timeZoneOffset>+01:00</timeZoneOffset> </importTimeZone> <dataFeedId>iHistorian</dataFeedId> </general> |
...