...
To be able to query timeseries directly using SQL statements Delft-Fews can be set up to act as a jdbc server. This can be done using an OC configuration (which will log in and automatically syncronise date with the MC, thereby assuring all data is constantly being updated, or by running this stand-alone. In the latter case the system will only export what is in the local datastore at startup.
Fews JDBC
...
Interface
| Wiki Markup |
|---|
The JDBC Interface provides a virtual access to (virtual) FEWS tables. The JDBC server allows a client application to query the available tables. However not all SQL query statements are supported. Also the type of SQL statements allowed on a table varies per table. See the section on \[#sql\] for more details about SQL statemetns. |
The following information is available through the JDBC Server:
Locations
The locations table allows the client application to query the available FEWS locations.
Installing a FEWS JDBC Server
...
When the FEWS JDBC application runs you can test the connection using the Test button.
| Anchor | ||||
|---|---|---|---|---|
|
Example SQL queries
Miscellaneous
...