com.ergotech.vib.historical.DatabaseRawTableLookup

This server is used with a Database Connection Manager to generate a Two Dimensional Value Object from a database table using a SQL Statement. The DatabaseRawTableLookup Bean is included in the Reporting module of MIStudio and TransSECS (see Reporting and Historical Servers).

This Bean has a single input (Trigger) which executes the SQL Statement. The SQL Statement should be a SELECT which returns one or more rows and columns from the table. There are two outputs: Result and Status Message. The TwoDimensionalValueObject of the SQL lookup will be sent to the Result output, and the Status Message can be used to monitor for errors.

Connection Name: Select the Database Connection Manager to use for this Bean

SQL Statement: The SQL Statement to execute when this Bean is triggered