Provisioning Query Settings

Provisioning can be carried out in two ways:

• Using provisioning rules. For more information, refer to Provisioning.

• Create SQL queries or stored procedures to configure provisioning operations

This topic describes how to configure provisioning operations using SQL queries or stored procedures for JDBC sources.

Prerequisites

To support this feature, be sure to enable Configure Provisioning Operations in the Connector in the source configuration pages.

Supported Functions

This feature supports the following functionality.

• Single SQL query execution

• Multiple SQL query execution

• Stored procedures

  For example:

  Call procedure_name($plan.attribute1$, $plan.attribute2$)

• Inline variables for defined queries

  Defined queries support inline variables from the provisioning plan using the $plan.fieldname.fieldtype$ variable syntax.

• Response items from priorly executed queries in the same SQL query set

  Queries can use response items from the result set of prior queries, via the $response.fieldname.fieldtype$ variable syntax.

• Type safety

  The provisioning plan and prior-query response objects may be restricted to specific data types.

  If a data type isn't defined, the field is treated as a string. Define a data type using the following entry:

  $plan.fieldname.type$

  For example:

  • $plan.firstName.string$

  • $response.id.int$

  The connector supports the following data types:

  • String – Str, Varchar

  • Integer – Int

  • Boolean – Bool

  • Date – Date

  • Double – Dbl

  • Float – Flt

  Note
  Data type definitions are case-insensitive

Configure Provisioning Operations as Part of the Connector Configuration

Create SQL queries and stored procedures to handle provisioning in the JDBC connector's configuration interface.