JDBC Collector Settings
JDBC Connection Settings
IdentityIQ uses the connection settings to access the activity data source.
Connection User
A valid JDBC user with access to the data source being accessed by this collector.
Connection Password
The password associated with the Connection User if a password is required.
The password is encrypted and is not displayed with the activity data source information.
Database URL
The full URL to the activity data source. For example, jdbc:mysql://localhost/db
JDBC Driver
The driver class of the activity data source. For example, com.mysql.jdbc.Driver
Query Settings
The query settings are used to control the activity information that is collected when an Activity Aggregation task is run.
SQL Statement
The SQL statement used to query activity from the database.
Condition Builder
Transforms the data mapped in the rule selected as the Position Builder into a SQL statement used by subsequent queries to determine start position.
Position Builder
Rule that converts the last row in the result set returned by the query into a configuration map that is persisted into the IdentityIQ database.
The data that is mapped in this rule is used by the condition builder to create a SQL statement used in future queries to determine the start location. This enables IdentityIQ to perform scheduled activity aggregations without having to scan entire data sets with each subsequent aggregation.