Document toolboxDocument toolbox

Set up data pool in Identity Manager

This article includes updates for Smart ID 23.04.


This article describes how to create or edit a data pool in Identity Manager Admin

User data in Smart ID Identity Manager is obtained from data sources that are connected to Identity Manager through data pool objects. Data pools are used regardless of data source and storage technology, independent if the data source is the internal Identity Manager database or an external SQL database or LDAP directory. 

 Prerequisites
  • Installed Identity Manager

See more prerequisites for the specific data sources below.

Add or edit data pool

 Log in to Identity Manager Admin
  1. Log in to the Identity Manager Admin as an admin user.
 Add or edit data pool
  1. Go to Home > Data pool.
  2. To add a new data pool, click +New. Enter a Name, for example DatapoolEmployee, and a Description. Click Save+Edit.
  3. To edit an existing data pool, double-click the data pool name.
 Create data pool fields

The data fields in the Field List tab represent the data in the internal or external data source. For data pools connected to an internal database or lookup table, the data fields are taken directly from the database.

Passwords vs. Encrypted fields

Passwords are hashed automatically before they are stored. They can never be restored. It's only possible to decide whether another provided input has the same hash code. Then it can be considered as equal to the original password.

Encrypted fields get decrypted and are stored separately. It is guaranteed that they can only be restored by an authorized user.


For external data sources, follow the steps below to create fields:

  1. Go to the Field List tab.
  2. To add a new field, click +.
  3. To edit a field, select the field in the list.
  4. In Field Details, enter the Field Name, Data Type, Field Size, and optionally a Description.
  5. If Binary Data is selected as Data Type, select Binary Data Definition, either Photo or Signature.
  6. To delete a field, click Delete.
  7. Use the arrow keys to change the order of the fields. This has no effect on the data pool function, with the exception of .csv sources without a header row.
  8. Click Save to save your settings.

Connect data source

In the Data sources tab, select one of the data sources listed below, and follow the steps to connect it to the data pool:

 Connect to internal database

Prerequisites: None

To connect to the CSV file:

  1. In Type, select Internal Table (DAO)
  2. Optionally, edit the Name and enter a Description.
  3. In DAO Bean Name, select the database table, for example personDAO.
  4. Click Field Selection. Check the fields to be assigned to the data pool, and then click Save. The selected fields will show up in the Field List tab.
  5. Save your settings by clicking on Save.
 Connect to .csv file

Prerequisites: An available CSV file, on a known location.

To connect to the CSV file:

  1. In Type, select CSV File
  2. Optionally, edit the Name and enter a Description.
  3. In File Name, enter the absolute path and file name.
  4. If the .csv file contains a header row with the field name, tick the Contains Header Row checkbox. During data accesses the values are then assigned automatically to the fields of the same name of the data object. Otherwise, the Field List must define the data fields in the same order as they exist in the .csv file.

    Limited to read operations

    Only read operations from CSV files are supported in the current product version. That means the imported CSV files can not be edited.

  5. Save your settings by clicking on Save.

 Connect to lookup table

Prerequisites: None

To connect to a lookup table:

  1. In Type, select Lookup Table
  2. Optionally, edit the Name and enter a Description.
  3. In DAO Bean Name, select the database table, for example personDAO.
  4. Click Field Selection. Check the fields to be assigned to the data pool, and then click Save. The selected fields will show up in the Field List tab.
  5. Save your settings by clicking on Save.
 Connect to LDAP directory

Prerequisites: A working LDAP service, with known connection information to it, such as URL, and the required permission to connect to the service and fetch data from it.

To connect to an LDAP directory service:

  1. In Type, select LDAP
  2. Optionally, edit the Name and enter a Description.
  3. In Connection string, enter the URL of the LDAP server and base address in the directory service.

    Example: 
    ldap://localhost:389/ou=NexusEmployees,dc=nexus,dc=local

    where
    ou = organizationalUnitName
    dc = domainComponent

    For more information on LDAP string attributes, see RFC 2253, LDAP (v3): UTF-8 String Representation of Distinguished Names.

  4. In Username and Password, enter the Active Directory domain user name and password. 
  5. In Initial Search Filter, enter a filter.
    The Initial Search Filter is used to locate the LDAP data objects (nodes) which carry the user data of the data pool by searching in the directory. The scope of the search (base-, one-level subnode, or subtree), the object class (class) sought and other search parameters can be indicated.

    Example:
     (objectclass=person)

     Dates/datetimes need to be stored in the GeneralizedTime format. Read more here: https://ldapwiki.com/wiki/GeneralizedTime.


    For more information on search filters, see RFC 2254, The String Representation of LDAP Search Filters.

  6. Click on Test Connection to test the connection and entry address. If a scheme description is stored in the directory, the available LDAP attributes are shown in the list underneath. Drag-and-drop the selected LDAP attributes that are to be assigned to the data pool fields. 

  7. Save your settings by clicking on Save.

    Limited to read operations

    Only read operations from LDAP directories are supported in the current product version. That means the imported CSV files can not be edited.
 Connect to JDBC database

Prerequisites: An active, already running database, with known connection information to it, such as URL, and the required permission to connect to the service and fetch data from it.

To connect to a JDBC database:

  1. In Type, select JDBC
  2. Optionally, edit the Name and enter a Description.
  3. In Database, either select the database type, to automatically fill in JDBC Driver Class Name and Connection String, or select Configure manually to type in the information yourself.
  4. In JDBC Driver Class Name, insert your driver class name including its package name prefix. The driver class must be available on the classpath.
  5. In Connection String, insert the URL that should be used to establish a JDBC connection to the remote database. The URL may contain a postfixed port number, for example ':1433', and driver specific attributes, for example ';AUTO_SERVER=TRUE'.
  6. Enter a valid Username and Password to establish a connection to the remote database.
  7. In Table Name, insert the table name of the remote database. The specified user must have rights for insert and update on that table.
  8. In Unique Key, insert a comma separated list of names of columns, that belong to the primary key, or a unique index of the remote table.
    This field decides whether an exported row is inserted or updated: If a unique key is specified and the target table contains a row with equal values for all unique key fields, the row is updated, otherwise it is inserted. All column names must have a mapping in the Mappings tab.
  9. Click Test Configuration to test if a connection can be established to the remote database, using the properties JDBC Driver Class Name, Connection string, Username and Password. If a connection can be established, it is also tested, whether the table specified in the Table Name property exists. If all tests succeed, a green icon is displayed at the right hand side. Otherwise a red icon shows up.

  10. Save your settings by clicking on Save.

 Connect to SCIM

The SCIM data source enables using data provided by a SCIM service.

Prerequisites: An available SCIM service, with known connection information to it, such as URL, and the required permission to connect to the service and fetch data from it.

To connect to a SCIM service:

  1. In Type, select SCIM
  2. Optionally, edit the Name and enter a Description.
  3. In Connection string, enter the URL of the SCIM server, in the following format:
    <protocol>://<host>:<port>/context.
    There is no default port.
  4. To enable transport layer security, and if https is selected as protocol, upload a Server certificate (X.509). It is mandatory to be able to test the connection or save the data source. Using an encrypted protocol is useful not only to encrypt the content of HTTP requests, but also the URL, which typically already holds information, that may be private and confidential.

    When the server certificate is uploaded, its identifier is displayed.
  5. If the service requires client authentication, upload a Client Certificate (a PKCS#12 software token), and enter the Client Certificate Password.
    The encrypted password is stored in the SecretFieldStore within Identity Manager. However, if a data pool configuration with such a password is exported, the exported configuration file will contain the unencrypted password. It will be encrypted again, when imported into another Identity Manager instance.
  6. Click Test Configuration. Identity Manager Admin then tries to reach the SCIM server and retrieves information about available resources. In case the SCIM server could be reached, a green icon will be displayed that signals a working connection and the available resources are listed in the combo box. If the SCIM server could not be reached, a red icon signals a connection problem. This might be due to an incorrect connection string or the SCIM server might be down temporarily.
  7. In Resource, either select a resource from the combo box or enter the resource name with or without leading slash '/'.
  8. For each Datapool Field, define the External Field (source field) of the specified resource. Single components of fields can be accessed using brackets, for example name[givenName].
  9. Save your settings by clicking on Save.

Set up search configuration

 Set up field mapping

For external data sources, a field mapping must be defined, in the Data Sources tab:

  1. For each Datapool field, drag-and-drop the corresponding field from the External Fields list.
 Set up search configuration for the data pool

In the Search Configuration tab, you can configure one or more search masks and hit lists adapted to the intended purpose or role. These then appear in the Search tab in Identity Manager Operator. Search dialogs can also be integrated into processes.

  1. Go to the Search Configuration tab.
  2. Enter a Name.
  3. Add search criteria to the search mask and search results. For more information, see Set up search configuration in Identity Manager.
  4. To add another search mask, click +. Configure the new search mask, according to step 3.
  5. To delete a search mask, select it in the drop-down list and click Delete.
  6. Click Save to save the data pool.
  7. Go to Home > Search Configurations. Double-click the search configuration that was just created, to edit it. Go to the Permissions tab and add permissions for the intended roles and users.

Additional information



Copyright 2024 Technology Nexus Secured Business Solutions AB. All rights reserved.
Contact Nexus | https://www.nexusgroup.com | Disclaimer | Terms & Conditions