Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note
titleVersion Warning

The content below is for Apache Syncope <= 1.2 - for later versions the Reference Guide is available.

Table of Contents
styledecimal

Introduction

The Scripted SQL connector provides great flexibility in the interaction with a database resource. A different Groovy script can be configured for each operation.
This wiki page shows all the steps needed to configure a Scripted SQL resource identified by the following connection parameters:

...

  1. Open your browser and access to the Syncope administration console (http://host:port/syncope-console).
  2. Log into the interface by providing the following credentials:
    1. Login: admin
    2. Password: password
  3. Click on the Resources tab.
  4. Click on the Connectors sub-tab.
  5. Click on Create new Connector button (configuration modal page appears).
  6. Click on tab General.
    1. Provide Display name (e.g. 'Sql Scripted Connector').
    2. Select the correct Bundle name (org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConnector).
    3. Select the correct Bundle version (1.1.0.1).
  7. Click on tab Configurations and provide connector instance configuration.
    User: root
    Password: password
    Host: localhost
    TCP Port: 3306
    Database: HR
    JDBC Driver: com.mysql.jdbc.Driver
    JDBC Connection URL: jdbc:mysql://%h:%p/%d
    clearTextPasswordToScript: true
    reloadScriptOnExecution: true
    createScriptFileName: /opt/scriptsql/groovy/CreateScript.groovy
    updateScriptFileName: /opt/scriptsql/groovy/UpdateScript.groovy
    deleteScriptFileName: /opt/scriptsql/groovy/DeleteScript.groovy
    searchScriptFileName: /opt/scriptsql/groovy/SearchScript.groovy
    syncScriptFileName: /opt/scriptsql/groovy/SyncScript.groovy
  8. Click on tab Capabilities.
  9. Check needed capabilities as shown at Connector instance configuration.
  10. Click on Save button.

...

Panel
borderColor#ccc
bgColor#fff
borderStyledashed
titleSchema mapping
borderStyledashed

Internal mapping types

Internal mapping

External Attributes

Mandatory condition

Account Id

Password

Username

 

 

true

X

 

Password

 

 

true

 

X

UserSchema

surname

lastname

false

 

 

UserSchema

firstname

firstname

false

 

 

UserSchema

fullname

fullname

false

 

 

UserSchema

email

email

false

 

 

UserSchema

organization

organization

false