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.

...