Introduction

This wiki page shows all the steps needed to configure an external Database Table resource identified by the following connection parameters:

...

Please, take a look at all configurable parameters at LDAP Database Table Connector Configuration and use this page as reference to provide your configuration.
Image Removed Image Removed
Image Removed

1. Open your browser and access to the Syncope administration console (http://host:port/syncope-console^{Image Removed}).
2. Log into the interface by providing the following credentials:
   :
   1. Login: admin
   :
   1. Password: password
   1. Click on the Resources tab.
   2. Click on the Connectors sub-tab.
   3. Click on Create new Connector button (configuration modal page appears).
      Image Added
   4. Click on tab General.
      :
      1. Provide Display name (e.g. 'Db Table Demo') and the correct Bundle name (org.connid.bundles.db.${version}).
      1. Click on tab Configurations and provide connector instance configuration.
         User: root
         Password: password
         Host: localhost
         TCP Port: 3306
         JDBC Connection URL: jdbc:mysql://localhost:3306/demo
         JDBC Driver: com.mysql.jdbc.Driver
         Database: demo
         Table: test
         Key Column: id
         Image Added
      2. Click on tab Capabilities.
         Image Added
      3. Check needed capabilities as shown at Connector instance configuration.
      4. Click on Save button.

      Configure Database Table resource

      Image Removed
      Image Removed
      Image Removed

      1. Click on the Resources tab.
      2. Click on the Resources sub-tab.
      3. Click on Create new Resource button (configuration modal page appears).
         Image Added
      4. Click on Resource Details tab.
      5. Choose from the list the correct Connector instance name.
      6. Provide the following information
         :
         1. Name: DbTable-Demo
         :
         1. Connector: Demo Db Table
         1. Click on Schema Mappings tab.
            Image Added
         2. Click on Add button to insert attributes mapping.
         3. Click on Save button.
            Image Added

         Panel
         borderColor #ccc bgColor #fff borderStyle dashed title Schema mapping borderStyle dashed
         Internal mapping types Internal mapping External Attributes Mandatory condition Account Id Password Username     true X   Password     true   X UserSchema surname surname true     UserSchema firstname firstname false     UserSchema email email false