Page tree
Skip to end of metadata
Go to start of metadata

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 namesYES

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):

ParameterExample value
jdbcDrivercom.microsoft.sqlserver.jdbc.SQLServerDriver
jdbcUrlTemplatejdbc:sqlserver://localhost\\DBInterface:1433
usermidpoint
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 VersionBundled with midPoint

Description

2.0Polygondownload jarGitHub (v2.0 tag)N/A1.5.0.0No1.4.2.14
2.1-SNAPSHOTPolygon
GitHub (master)N/A1.5.0.0NoFixes: 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

Resource Examples


  • No labels