Status
| Functionality | Stable |
|---|---|
| Support status | Supported |
| Support provided by | Evolveum |
| Origin | Identity Connector Framework (Sun), many improvements by Evolveum |
| Target systems | Generic database table (JDBC) |
Description
Generic connector for simple database tables.
Protocol | Database-specific. Connector is using JDBC. |
|---|---|
Framework | ConnId 1.4.x |
Bundle name | com.evolveum.polygon.connector-databasetable |
Connector name | org.identityconnectors.databasetable.DatabaseTableConnector |
Additional requirements | Requires correct JDBC driver to be present on classpath |
Capabilities and Features
| Schema | YES | |
|---|---|---|
Provisioning | YES | |
Live Synchronization | YES | Using last modification timestamps |
Password | YES | |
Activation | SIMULATED | Configured capability |
| Scripting | NO |
History
This is almost entirely the original version from Sun ICF.
Versions
Version | Origin | Binary | Sources | Build Date | Framework version | Description |
|---|---|---|---|---|---|---|
1.1.0.e6296 | OpenICF trunk version, built and tested by Evolveum | OpenICF: trunk, revision 6296 | Jan 2013 | Well tested (now obsolete) | ||
| 1.4.0.49 | Evolveum | download jar | Evolveum OpenICF git repository (tag connector-databasetable-v1.4.0.49) | 16 Jan 2015 | Bundled with midPoint. | |
| 1.4.2.0 | Evolveum | download jar | Evolveum OpenICF git repository (tag connector-databasetable-v1.4.2.0) | June 2016 | 1.4.2.0 | Current version. Bundled with midPoint 3.4. |
| 1.4.3.0 | Evolveum | download jar | Evolveum OpenICF git repository (tag connector-databasetable-v1.4.3.0) | October 2018 | 1.4.2.0 | Current version. Bundled with midPoint 3.9. |
| 1.4.4.0 | Evolveum | download jar | Evolveum OpenICF git repository (tag connector-databasetable-v1.4.4.0) | July 2020 | 1.4.2.0 | Exception handling for creating new connection |
Interoperability
This connector is supposed to work with all relational databases that follow the SQL standard and that provide a JDBC driver. The driver is not part of the connector distribution (except for PostgreSQL driver, which is distributed with midPoint). The deployer is responsible for using correct JDBC driver.
Support
Only standard SQL behavior is supported. This means standard SQL operations and standard database schemas. Non-standard database operations and vendor-specific behavior is not supported.
Problems originating in JDBC driver, problem that are caused by non-compliance to SQL standard or vendor-specific behavior are not covered by the support.
The bundled support does not include support for any specific database server. Support for specific database servers needs to be explicitly negotiated in the support contract.
Documentation
Unfortunately, there is no comprehensive documentation for this connector.
Resource Examples
Notes
DatabaseTable connector now assumes that UID is the same as NAME. See https://jira.evolveum.com/browse/MID-1127.
The following two configuration properties were reported to resolve problems with Oracle DATE attribute
<icfsdbt:nativeTimestamps>true</icfsdbt:nativeTimestamps> <icfsdbt:allNative>true</icfsdbt:allNative>
For PostgreSQL TIMESTAMP or TIMESTAMPTZ attribute only allNative configuration property is needed
<icfsdbt:allNative>true</icfsdbt:allNative>
In addition, the DATE, TIMESTAMP or TIMESTAMPTZ column must be provisioned as string with correct formatting, e.g.: return new Date().format("yyyy-MM-dd HH:mm:ss"), otherwise "ORA-01861: literal does not match format string" occurs (or similar exception in PostreSQL).
TIMESTAMPTZ is stored including the timezone. DatabaseTable connector doesn't work with timezone directly, but the value is automatically converted to midPoint local timezone. Therefore, you always work with local timezone in mappings and it will be automatically stored correctly in the database.