You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

What

RdbmsExport.xml

Required

no

Description

Exports historical time series data to RDBMS

schema location

http://fews.wldelft.nl/schemas/version1.0/rdbmsExport.xsd

Entry in ModuleDescriptors

<moduleDescriptor id="RdbmsExport">
<description>Exports historical time series data to RDBMS</description>
<className>nl.wldelft.fews.system.plugin.rdbmsexport.RdbmsExport</className>
</moduleDescriptor>

Configuration

The RdbmsExport module exports historical time series data to tables in a RDBMS. These tables must exist prior to running the module.

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

exportTimeZone

moduleInstanceID

filter

RDBMS DDL/object creation scripts (Oracle)

  • No labels