Status
Stable. Works well.
Description
Generic SQL connector.
The connector can be described as a "wrapper" for scripts (e.g. Groovy) where the actual implementation of the operations (Create, Update, Delete etc.) is provided.
Protocol | JDBC |
|---|---|
Framework | ConnId 1.5.0.0 or later |
Bundle name | com.evolveum.polygon.connector-scripted-sql |
Connector name | com.evolveum.polygon.connector.scripted.sql.ScriptedSQLConnector |
Capabilities and Features
Provisioning | YES | |
|---|---|---|
Live Synchronization | YES | |
Password | YES | |
Activation | YES | |
Filtering changes | ||
Paging support | NO | |
| Native attribute names | YES |
History
This is an Scripted SQL connector heavily updated during 2018. Scripts used with ScriptedSQL Connector (deprecated) have to be modified.
Connector history continues in the spring of 2019, when additional fixes were provided and connector architecture changed to PoolableConnector. Poolable connector let midPoint decide over the connection objects life cycle rather than relying on depricated tomcat7 connection pool (which was replaced). As a consequence of this change, parameters from previous connector version are not compatible with new poolable connector as connection data source changed. However migration is fairly easy, just make sure at least following resource parameters are set (on top of providing usual script file names for groovy part of the connector):
| Parameter | Example value |
|---|---|
| jdbcDriver | com.microsoft.sqlserver.jdbc.SQLServerDriver |
| jdbcUrlTemplate | jdbc:sqlserver://localhost\\DBInterface:1433 |
| user | midpoint |
| password | ***** |
Connection Validation Query parameter was dropped since checkAlive method uses less costly methods to validate connection pulled from the pool.
Versions
Version | Origin | Binary | Sources | Build Date | Framework Version | Bundled with midPoint | Description |
|---|---|---|---|---|---|---|---|
| 2.0 | Polygon | download jar | GitHub (v2.0 tag) | N/A | 1.5.0.0 | No | 1.4.2.14 |
| 2.1-SNAPSHOT | Polygon | GitHub (master) | N/A | 1.5.0.0 | No | Fixes: Binary attribute support Improvements: Poolable connector, relative changes update. Resource settings not compatible with previous version, see History section. |
Logging
Use implicit log variable in your resource script as follows:
log.info("Entering " + operation + " Script")
Turn on midPoint logging for specific script file name. For instance for SearchScript.groovy use:
Documentation
- TODO