Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Adding role synchronization warning

Table of Contents
styledecimal

 

Note
titleWarning

The DB Connector does not support synchronization of roles. If you also require role synchronization you should use a scripted SQL resource instead.

Introduction

This wiki page shows all the steps needed to configure an external Database Table 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. 'Db Table Demo') and the correct Bundle name (org.connid.bundles.db.${version}).
  7. 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
  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 mappingborderStyledashed

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