This wiki page shows all the steps needed to configure an external Database Table resource identified by the following connection parameters:
Panel |
---|
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.
- Download JDBC driver (MySQL JDBC driver in this case) and include it into your JEE container classpath.
- Install ConnId Database Table connector bundle.
- Configure Database Table connector instance.
- Configure Database Table resource.
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.
- 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.
Panel |
---|
borderColor | #ccc |
---|
bgColor | #fff |
---|
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 | | |
|