--- title: Database Table description: The Database Table application template allows you to provision users to a database table. component: pingoneaic page_id: pingoneaic:app-management:applications/database-table canonical_url: https://docs.pingidentity.com/pingoneaic/app-management/applications/database-table.html section_ids: register_the_application: Register the application configure_provisioning: Configure provisioning provision_side_tabs: Provision side tabs next_steps: Next steps --- # Database Table The Database Table application template allows you to provision users to a database table. ## Register the application 1. In the Advanced Identity Cloud admin console, go to Applications, and click [icon: grid_view, set=material, size=inline] Browse App Catalog. 2. In the Browse App Catalog modal, select an application, and click Next. 3. Review the Application Integration information, and click Next. 4. In the Application Details window, specify the name, description, application owners, and logo for the application. 5. To make the application an [Authoritative](../applications.html#target_and_authoritative_applications) source of identity data, select the Authoritative check box. This option is not available for every application. 6. Click Create Application. ## Configure provisioning 1. 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. 2. Configure the following fields: | 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`. | 3. Optionally, click Show advanced settings to set any of the following options: **Application specific settings** | 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. | **Pool configuration** | Field | Description | | --------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Max idle and active container instances | The maximum number of idle and active container instances. The default value is `10`. | | Max Idle Connector Instances | The maximum number of idle connector instances. The default value is `10`. | | Set Timeout Period | Select to enable a timeout period for the connection. After enabling, configure the following:- Timeout period (ms): The timeout period in milliseconds. | | Set Minimum Idle Time | Select to set a minimum time (in milliseconds) before an idle object is removed. After enabling, configure the following:- Min idle time (ms): The minimum idle time in milliseconds. | | Min Idle Instances | The minimum number of idle connector instances. | **Result Handler configuration** | Field | Description | | ----------------------------------------------------------------------- | --------------------------------------------------------------------------------- | | Enable for connectors with the attribute normalizer interface | Enables the attribute normalizer interface for supported connectors. | | Enable local filtering/search features | Enables local filtering and search capabilities. | | Enable case insensitive filter | Configures filters to ignore case sensitivity. | | Enable configuration of search attributes; disable for local connectors | Enables search attribute configuration. Disable this option for local connectors. | 1. In the Operation Timeouts (ms) area, select the operations to enforce timeouts on and enter the duration in milliseconds. Available operations include Create, Validate, Test, Enable a Script on the Connector, Schema, Delete, Update, Sync, Authenticate, Get, Enable a Script on the Target, and Search. 2. In the Operation Rate Limits area, select the operations to enforce rate limits on. You can enforce limits on specific operations, including Create, Validate, Test, Script on Connector, Schema, Delete, Update, Sync, Authenticate, Get, Script on Target, and Search. For each selected operation, configure the following fields: | Field | Description | | --------------- | ---------------------------------- | | Request Limit | Requests allowed over time. | | Request Period | Limit resets after this time (ms). | | Request Timeout | Time before exception thrown (ms). | 4. Click Connect. 5. 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. ![Sub-tabs under the Provisioning tab](../_images/ui-workforce-provisioning.png) | 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](../provision-an-application.html#provision_settings_for_an_application). | | Properties | View and manage properties for the selected object type. | [Manage application attributes](../provision-an-application.html#manage_application_attributes) | | Data | View data about the selected object type. | [View user access data](../provision-an-application.html#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](../provision-an-application.html#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](../provision-an-application.html#recon-sync-end-users) | | Privacy & Consent | Manage end-user data sharing and synchronization. | [Configure end-user data sharing](../provision-an-application.html#config-end-user-data-sharing) | | Rules | View and manage provisioning rules for mappings between Advanced Identity Cloud and a target application. | [Manage provisioning rules](../provision-an-application.html#manage-provisioning-rules) | | Advanced Sync | Create and manage mappings between a managed object type and an application or between applications. | [Manage advanced sync](../provision-an-application.html#manage-advanced-sync) | ## Next steps * [icon: check-square-o, set=fa][Application management](../applications.html) * [icon: check-square-o, set=fa][App catalog](../app-catalog.html) * [icon: check-square-o, set=fa][Register an application](../register-an-application.html) or [Register a custom or SSO application](../register-a-custom-application.html) * [icon: check-square-o, set=fa][Provision an application](../provision-an-application.html) * [icon: square-o, set=fa]*[Manage end users and roles](../manage-users-and-roles.html)* * [icon: square-o, set=fa][Manage application registrations](../manage-app-status.html)