Database Table

The Database Table application template allows you to provision users to a database table.

Register the application

In the Advanced Identity Cloud admin console, go to Applications, and click grid_view Browse App Catalog.
In the Browse App Catalog modal, select an application, and click Next.

Select the latest application version.
Review the Application Integration information, and click Next.
In the Application Details window, specify the name, description, application owners, and logo for the application.
To make the application an Authoritative source of identity data, select the Authoritative check box. This option is not available for every application.
Click Create Application.

Configure provisioning

In the Advanced Identity Cloud admin console, on the Provisioning tab, click Set up Provisioning:
- If setting up provisioning for the first time:
  1. If you have not configured a remote server, click New Connector Server and follow the steps to create a server.
  2. If you configured one remote server, it is automatically selected.
  3. If you configured multiple remote servers, choose a server.
- When editing existing settings in the Connection area, click Settings.

Configure the following fields:

Field Description

Field	Description
JDBC Connection Url	The URl for the JDBC database address that contains the table that you are provisioning. The format of the url depends on the type of database. For example, `jdbc:mysql://localhost:3306/contractordb?serverTimezone=UTC` or `jdbc:oracle:thin:@//localhost:3306/contractordb`. The address includes the name of the database you are connecting to.
JDBC Driver	The class name of the driver you are using to connect to a database. The name varies depending on the type of database you are using, such as `oracle.jdbc.OracleDriver` or `com.mysql.jdbc.Driver`.
Username	The username sent to the JDBC driver to establish a connection.
Password	The password sent to the JDBC driver to establish a connection.
Table	The name of the table in the JDBC database that contains the user accounts. The default is `TABLE_NAME`.
Key Column	The column value that is the unique identifier for rows in the table. The default is `KEY_COLUMN`.

JDBC Connection Url

The URl for the JDBC database address that contains the table that you are provisioning. The format of the url depends on the type of database. For example, jdbc:mysql://localhost:3306/contractordb?serverTimezone=UTC or jdbc:oracle:thin:@//localhost:3306/contractordb. The address includes the name of the database you are connecting to.

JDBC Driver

The class name of the driver you are using to connect to a database. The name varies depending on the type of database you are using, such as oracle.jdbc.OracleDriver or com.mysql.jdbc.Driver.

Username

The username sent to the JDBC driver to establish a connection.

Password

The password sent to the JDBC driver to establish a connection.

Table

The name of the table in the JDBC database that contains the user accounts. The default is TABLE_NAME.

Key Column

The column value that is the unique identifier for rows in the table. The default is KEY_COLUMN.

Optionally, click Show advanced settings to set any of the following options:

Field Description

Field	Description
Validate resources and passwords	Enable to validate resources and passwords. After enabling this option, in the Password Column field, enter the name of the column in the table that holds the password values.
Activate Sync ICF Interface	Enable to poll for synchronization events, which are native changes to target objects. After enabling this option, in the Change Log Column field, enter the change log column that stores the latest change time.
Allow empty string	Enable to allow empty strings instead of null values, except for OracleSQL.
Quote Database Column Names	Enable to place specific quote characters around column names in the SQL that is generated to access the database. After enabling this option, in the Quote Characters field, enter the characters to use for quotes.
Rethrow All SQL Exceptions	Enable to show SQL Exceptions with `code = 0`. The default value is `true`.
Native Timestamps	Enable to retrieve timestamp data.
All Native	Enable to retrieve in a database-native format.
Validate Connection	Enable to specify a SQL query used to validate connections. After enabling this option, in the Validation SQL Query (optional) field, enter the SQL query for validating connections.
Validation Interval (ms)	Enter the validation interval in milliseconds. The default value is `3000`.
Validation Connection Query Timeout (ms)	Enter the validation connection query timeout in milliseconds. The default value is `-1`.
Initial Pool size	Enter the initial pool size. The default value is `10`.
Maximum Idle	Enter the maximum idle time. The default value is `100`.
Minimum Idle	Enter the minimum idle time. The default value is `10`.
Maximum Wait (ms)	Enter the maximum wait time in milliseconds. The default value is `30000`.
Maximum Active	Enter the maximum active time. The default value is `100`.
Maximum Age (ms)	Enter the maximum age in milliseconds. The default value is `0`.
Minimum Evictable Idle Time (ms)	Enter the minimum evictable idle time in milliseconds. The default value is `60000`.
Time Between Eviction Runs(ms)	Enter the time between eviction checks in milliseconds. The default value is `5000`.
Test Connection When Idle	Enable to test the connection when idle.
Test Connection On Borrow	Enable to test the connection on borrow.
Exclude Unmodified	Select this option to synchronize only the modified properties on a target resource.

Validate resources and passwords

Enable to validate resources and passwords. After enabling this option, in the Password Column field, enter the name of the column in the table that holds the password values.

Activate Sync ICF Interface

Enable to poll for synchronization events, which are native changes to target objects. After enabling this option, in the Change Log Column field, enter the change log column that stores the latest change time.

Allow empty string

Enable to allow empty strings instead of null values, except for OracleSQL.

Quote Database Column Names

Enable to place specific quote characters around column names in the SQL that is generated to access the database. After enabling this option, in the Quote Characters field, enter the characters to use for quotes.

Rethrow All SQL Exceptions

Enable to show SQL Exceptions with code = 0. The default value is true.

Native Timestamps

Enable to retrieve timestamp data.

All Native

Enable to retrieve in a database-native format.

Validate Connection

Enable to specify a SQL query used to validate connections. After enabling this option, in the Validation SQL Query (optional) field, enter the SQL query for validating connections.

Validation Interval (ms)

Enter the validation interval in milliseconds. The default value is 3000.

Validation Connection Query Timeout (ms)

Enter the validation connection query timeout in milliseconds. The default value is -1.

Initial Pool size

Enter the initial pool size. The default value is 10.

Maximum Idle

Enter the maximum idle time. The default value is 100.

Minimum Idle

Enter the minimum idle time. The default value is 10.

Maximum Wait (ms)

Enter the maximum wait time in milliseconds. The default value is 30000.

Maximum Active

Enter the maximum active time. The default value is 100.

Maximum Age (ms)

Enter the maximum age in milliseconds. The default value is 0.

Minimum Evictable Idle Time (ms)

Enter the minimum evictable idle time in milliseconds. The default value is 60000.

Time Between Eviction Runs(ms)

Enter the time between eviction checks in milliseconds. The default value is 5000.

Test Connection When Idle

Enable to test the connection when idle.

Test Connection On Borrow

Enable to test the connection on borrow.

Exclude Unmodified

Select this option to synchronize only the modified properties on a target resource.

Click Connect.
Verify the information in the Details tab.

Provision side tabs

The object type determines the side tabs that display on the Provisioning tab. Use the object type list to select an object type, such as Group. Afterward, you can configure properties in the different sub-tabs under the Provisioning tab.

Provisioning tab	Description	Related sections
Details	View and manage an application, including name, ID, and native type.	Select the specific application from Provision settings for an application.
Properties	View and manage properties for the selected object type.	Manage application attributes
Data	View data about the selected object type.	View user access data
Mapping	View and manage mappings from the Advanced Identity Cloud admin console properties to external system properties and from external system properties to the Advanced Identity Cloud admin console properties.	Manage mappings
Reconciliation	Preview mappings on target applications between external systems and the Advanced Identity Cloud admin console, and reconcile the data between the two systems. View and manage rules for the users and groups that use your application. View and manage schedules for Full and Incremental reconciliation.	Reconcile and synchronize end-user accounts
Privacy & Consent	Manage end-user data sharing and synchronization.	Configure end-user data sharing
Rules	View and manage provisioning rules for mappings between Advanced Identity Cloud and a target application.	Manage provisioning rules
Advanced Sync	Create and manage mappings between an identity profile and an application or between applications.	Manage advanced sync

Provisioning tab

Description

Related sections

Details

View and manage an application, including name, ID, and native type.

Select the specific application from Provision settings for an application.

Properties

View and manage properties for the selected object type.

Manage application attributes

Data

View data about the selected object type.

View user access data

Mapping

View and manage mappings from the Advanced Identity Cloud admin console properties to external system properties and from external system properties to the Advanced Identity Cloud admin console properties.

Manage mappings

Reconciliation

Preview mappings on target applications between external systems and the Advanced Identity Cloud admin console, and reconcile the data between the two systems.

View and manage rules for the users and groups that use your application.

View and manage schedules for Full and Incremental reconciliation.

Reconcile and synchronize end-user accounts

Privacy & Consent

Manage end-user data sharing and synchronization.

Configure end-user data sharing

Rules

View and manage provisioning rules for mappings between Advanced Identity Cloud and a target application.

Manage provisioning rules

Advanced Sync

Create and manage mappings between an identity profile and an application or between applications.

Manage advanced sync