Provisioning Query Settings

You can configure provisioning operations through a series of SQL queries and stored procedures.

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

Create SQL queries and stored procedures to handle provisioning in the JDBC SaaS connector.

To create provisioning operations in the connector configuration, select Configure Provisioning Operations in the Connector, then select any of the following options: