Database protocols

The Database protocol supports VRL messages in addition to the current database schema format. The Database Outbound protocol can query data from the database and return the data as a reply message. The Inbound (Outbound) SQL Statement Configurator dialog box supports all tables in the database. The Table Configuration tool supports calling stored procedures.

The Database protocol also supports custom statements once the database connection is made. Windows Authentication is supported natively when connecting to SQL Server.

Additional support is provided for:

  • Multiple tables in the same SQL schema.
  • Role assignment to connections after connection.
  • Auto trim for white space in fields.
  • BLOB and CLOB

    See BLOB and CLOB.

For error handling, meaningful error messages are logged in the engine log file. Meaningful, human, and machine readable errors are returned to the user for action by UPoC scripts or other means.

All configurations are stored at the site level.

This table describes the different database protocol functions:

Function Description
Database Outbound Protocol: VRL

The Database Outbound protocol supports the use of VRLs as the outbound staging message format.

You can modify the VRL structure after it has been created.

Database Outbound Protocol: Select statement support

The Database Outbound protocol supports using the outbound staging message to query the database. The query result set is returned as a reply message.

SQL Configuration: All database table support

All tables in the database are supported for select, insert, delete, and update statements.

Lookup Table: Stored Procedure support

Dynamically stored procedures are supported in the Lookup Table Configurator. You can edit the stored procedures to assign input and output variables. Return values and result sets are mapped for use by the engine.

Database Configuration: Connect Success

You can define SQL statements that are run upon a successful database connection.

Connect Success action

Double quotes around the SQL Connection Success action (connect_success_action) are not required.

Connect Success Action does not support these DML/DQL:

  • create
  • drop
  • insert
  • update
  • delete
  • select
Note: Doctrine Query Language (DQL) is an Object Query Language created for helping users in complex object retrieval. A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database.