JDBC Enrichment Reference

JDBC Integration instance which the workflow engine actions reference by its Database Definition Name.

Type of database you want to connect to.

Database hostname.

Port to connect to the database over.

Name of the database you want to connect to.

Username to connect to the database.

Password to connect to the database.

Map of key-value pairs of properties to specify the connection properties. See the "Database Specific Information" section in ExternalDb for more information.

Whether to enable cached results.

How long to cache results for, in seconds.

Name of the table definition.

Database table name.

Path in custom_info.enrichment to store the results.

Represents the WHERE clause of the database request. You can use $property to reference alert properties. SQL syntax requires quotes around the value. For example, a query where the value for the table.name field is equal to the alert source:

name = "$source"

To reference custom info properties, use $custom_info.<path>.<key>. For example "custom_info.enrichment.environment".

To reference values from the workflow, use $$params.value1 or $$params.value2. To treat the value as a literal, prefix the property with '$' instead of '$$'. For example "$$params.value1".

Fields to query and include in results.

Properties to handle results that return multiple records, for example Applications or Business Services.

To connect to a database with properties that are not in the UI, define the properties in this field. For example, if you use advanced features of a new JDBC driver. This field overrides the properties within Database Definitions.

{
        "jar_files": ["/usr/share/moogsoft/lib/cots/sqljdbc4.jar"],
        "class_name": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
        "url": "jdbc:sqlserver://172.16.87.248:1433;databaseName=moog",
        "properties": { user: "sa", password: "password" }    
}

The overriding database type.