What |
RdbmsExport.xml |
|---|---|
Required |
no |
Description |
Exports historical time series data to RDBMS |
schema location |
|
Entry in ModuleDescriptors |
<moduleDescriptor id="RdbmsExport"> |
Configuration
The RdbmsExport module exports historical time series data to tables in a RDBMS. These tables must exist prior to running the module. Notice that in the current version no qualifiers are supported!
The configuration of the module is setup as:
In the sections below the different elements of the configuration are described
General
jdbcDriverClass
JDBC driver class to use for connection to RDBMS.
FEWS installation contains drivers for Oracle, PostgreSQL, Firebird
An Oracle example
<jdbcDriverClass>oracle.jdbc.driver.OracleDriver</jdbcDriverClass>
jdbcConnectionString
Connection string to use by JDBC driver to connect to RDBMS
An Oracle example:
<jdbcConnectionString>jdbc:oracle:thin:@localhost:1521:xe</jdbcConnectionString>
user
Username on the (target) RDBMS.
password
Password for user on the (target) RDBMS.
Encryption of the password in the FEWS configuration is not implemented yet.
exportTimeWindow
Defines the time window for which to export data from FEWS.
For the start and end time it can be configured whether they can be overruled from the User Interface.
<exportTimeWindow unit="day" start="-600" end="0" startOverrulable="true" endOverrulable="false"/>
exportTimeZone
The time zone in which to export the data from FEWS.
<exportTimeZone>+01:00</exportTimeZone>
moduleInstanceID
Optional list of Module Instance Id's for which to export time series data.
<moduleInstance moduleInstanceID="Statistiek_Percentielen_jaar" /> <moduleInstance moduleInstanceID="Statistiek_Percentielen_seizoen" />
filter
Optional list of Filter Id's for which to export time series data.
<filter filterID="TSI_productie" /> <filter filterID="TMX_ruw" /> <filter filterID="DINO_ruw" />
RDBMS DDL/object creation scripts
Tables for storage of data in the RDBMS must be present before first execution of RDBMS Export module.
Proper priviledges must be assigned to the #user account by the database administrator to insert/update data in these tables as well as (execution) rights on the sequences and triggers in use.
Data model:
DDL scripts
