Database Capture Point
The integrated Database Capture Point provides the ability to capture interactions from databases, and also provides compatibility with the iWD Database Capture Adapter. The Database Capture Point provides the ability to create interactions based on a database query, and to update database records to propagate changes in interaction states or parameters.
The integrated Database Capture Point picks up updates for the interactions in the source database and applies these updates to the corresponding interactions. All relevant queries for selection and updates in the source database are configurable in the integrated Database Capture Point application settings.
Outline of Deployment
- Configure the Capture Point
- Install and configure the required ODBC driver.
- Read about the Configurable Queries available with this Capture Point.
- Read about the Query Language.
- Read about Error Handling.
The set of possible configurable queries in Database Capture Point includes the queries of iWD 8.0 Database Capture Adapter and introduces a number of new queries, corresponding to existing interaction events. iWD compatibility is achieved by configuring corresponding iWD-related queries and parameters.
The queries are written in SQL language, observing the semantics of the DBMS that you are using. When performing select queries, the columns should be named as standard interaction properties or user data keys (both case-sensitive). In update queries (using the interaction parameters or special keys) the interaction parameters and user data are case-sensitive as well.
When using parameters (such as "externalid=<external id of the interaction>"), write a question mark followed by the name of the parameter known to the interaction server in single quotes (such as " externalid=?'ExternalId' "). The question mark must be followed by the parameter name in single quotes, with no spaces. Do not use the curly apostrophe/single quote symbol ( ’ ); use the straight single quote (').
- Inbound Queries
- Notification Queries
- Source Update Queries
- There is also the following query that does not fit in the three previous categories:
startupQuerySql This optional query runs once, upon the Database Capture Point point establishing a connection to the database. It cannot take any parameters from Interaction Server.
The Database Capture Point uses a particular query language, for which a reference listing is provided.
In situations where a capture or update query results in an error and cannot be executed, the values ErrorCode and ErrorDescription are provided to the corresponding error queries.
A returned ErrorCode can be equal to 0 for different ErrorDescriptions. This means that the error is not a protocol error and might not have a separate error code.
If an inbound (or source update) query results in an ODBC exception, the exception is reported in the logs, and the inbound (or source update) cycle pauses for the duration of the inbound-exception-sleep-interval parameter (for inbound queries) or the updates-exception-sleep-interval parameter (for source update queries). Both of these parameters are configuration options for the Database Capture Point.