This Confluence has been LDAP enabled, if you are an ASF Committer, please use your LDAP Credentials to login. Any problems file an INFRA jira ticket please.

Page tree

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