Introduction
This wiki page shows all the steps needed to configure an external Database Table resource identified by the following connection parameters:
Host: localhost
Port: 3306
User: root
User Password: password
JDBC Connection URL: jdbc:mysql://localhost:3306/demo
Database: demo
Table: test
In order to link an external Database Table resource there are pre-requisites and configuration steps to be satisfied.
Pre-Requisites
- Download JDBC driver (MySQL JDBC driver in this case) and include it into your JEE container classpath.
- Install ConnId Database Table connector bundle.
Configuration steps
Configure Database Table connector instance
Please, take a look at all configurable parameters at Database Table Connector Configuration and use this page as reference to provide your configuration.
- Open your browser and access to the Syncope administration console (http://host:port/syncope-console).
- Log into the interface by providing the following credentials:
- Login: admin
- Password: password
- Click on the Resources tab.
- Click on the Connectors sub-tab.
- Click on Create new Connector button (configuration modal page appears).
- Click on tab General.
- Provide Display name (e.g. 'Db Table Demo') and the correct Bundle name (org.connid.bundles.db.${version}).
- 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
- Click on tab Capabilities.
- Check needed capabilities as shown at Connector instance configuration.
- Click on Save button.
Configure Database Table resource
- Click on the Resources tab.
- Click on the Resources sub-tab.
- Click on Create new Resource button (configuration modal page appears).
- Click on Resource Details tab.
- Choose from the list the correct Connector instance name.
- Provide the following information
- Name: DbTable-Demo
- Connector: Demo Db Table
- Click on Schema Mappings tab.
- Click on Add button to insert attributes mapping.
- Click on Save button.
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 |
false |
|
|