17.6 Understanding and Configuring JDBC Templates

Identity Governance provides the following templates for JDBC:

  • JDBC Identity

  • JDBC Account

  • JDBC Permission

    The identity, account, and permission templates are divided are organized by database:

    • DB2

    • Generic

    • MySQL

    • Non-specific

    • Oracle

    • PostgreSQL

    • SQLServer

    • Sybase

  • JDBC Generic DB Fulfillment

  • JDBC Oracle Fulfillment

  • JDBC PostgreSQL Fulfillment

  • JDBC SQL Server Fulfillment

For additional information about configuring JDBC templates, see the following sections:

17.6.1 About JDBC Collectors

To collect data from a JDBC source, Identity Governance needs the appropriate third-party connector libraries to be installed on the Identity Governance server. For more information on required third-party libraries, see Identity Governance Server System Requirements in the Identity Governance 4.2 Installation and Configuration Guide.

17.6.2 About JDBC Fulfillment

Identity Governance uses the JDBC, Oracle, SQL Server, and PostgreSQL fulfillment templates to automatically fulfill change requests. Identity Governance uses the generic fulfillment template for all other databases, such as MySQL or SyBase. The appropriate third-party connector libraries must be installed on the Identity Governance server before you can use the JDBC generic fulfillment template. The generic template allows you to edit the transform script that builds the required payload to successfully process change requests.

The JDBC fulfillment template supports all change requests. The JDBC fulfillment is certified with the following database versions:

JDBC fulfillment type

Supported version

JDBC Oracle

Oracle 19c

JDBC PostgreSQL

PostgreSQL 14

JDBC SQL Server

MS SQL 2019

JDBC Generic DB

MySQL 8.0.x