The DataHouse©
system is an add-on to the Stiletto©
Mediation system that provides integration of the Stiletto system with
a Postgres Database. Two new Stiletto nodes give the user the
ability to insert and select data from any table. The Data
Warehouse node utilzes the existing DataParser©
infratructure to quickly and
easily set up jobs to load data into any standard databse table.
The SQL Collector node allows for any custom SQL command to be used
collect data from a database table. In addition to these
Stiletto nodes, the DataHouse© system also provides a standalone
Database
Inquiry system. This inquiry system provides a freeform method
of creating, executing, and saving the reults of complex inquires on
any database table.