Example: Use the CSV Connector to Reconcile Users in a Remote CSV Data Store

Before you start, copy the following files to your /path/to/openidm/conf directory:

1. Edit the remote connector server configuration file (provisioner.openicf.connectorinfoprovider.json) to match your network setup.

   The following example indicates that the Java connector server is running on the host remote-host, listening on the default port, and configured with a secret key of Passw0rd:

   {
       "remoteConnectorServers" : [
           {
               "name" : "csv",
               "host" : "remote-host",
               "port" : 8759,
               "useSSL" : false,
               "key" : "Passw0rd"
           }
       ]
   }

   The name that you set in this file will be referenced in the connectorHostRef property of the connector configuration, in the next step.

   The key that you specify here must match the password that you set when you installed the Java connector server.

2. Edit the CSV connector configuration file (provisioner.openicf-csvfile.json) as follows:

   {
       "connectorRef" : {
           "connectorHostRef" : "csv",
           "bundleName" : "org.forgerock.openicf.connectors.csvfile-connector",
           "bundleVersion" : "[1.5.0.0,1.6.0.0)",
           "connectorName" : "org.forgerock.openicf.csvfile.CSVFileConnector"
       },
       ...
       "configurationProperties" : {
           "csvFile" : "/home/testuser/csv-sample/data/hr.csv"
       }
   }

   • The connectorHostRef property sets the remote connector server to use, and refers to the name property you specified in the provisioner.openicf.connectorinfoprovider.json file.

   • The bundleVersion : "[1.5.0.0,1.6.0.0)", must either be exactly the same as the version of the CSV connector that you are using or, if you specify a range, the CSV connector version must be included in this range.

   • The csvFile property must specify the absolute path to the CSV data file that you copied to the remote host on which the Java Connector Server is running.

3. Start IDM:

   /path/to/openidm/startup.sh

4. Verify that IDM can reach the remote connector server and that the CSV connector has been configured correctly:

   curl \
    --header "X-OpenIDM-Username: openidm-admin" \
    --header "X-OpenIDM-Password: openidm-admin" \
    --header "Accept-API-Version: resource=1.0" \
    --request POST \
    "http://localhost:8080/openidm/system?_action=test"
   [
     {
       "name": "csv",
       "enabled": true,
       "config": "config/provisioner.openicf/csv",
       "objectTypes": [
         "__ALL__",
         "account"
       ],
       "connectorRef": {
         "bundleName": "org.forgerock.openicf.connectors.csvfile-connector",
         "connectorName": "org.forgerock.openicf.csvfile.CSVFileConnector",
         "bundleVersion": "[1.5.0.0,1.6.0.0)"
       },
       "displayName": "CSV File Connector",
       "ok": true
     }
   ]

   The connector must return "ok": true.

   Alternatively, use the Admin UI to verify that IDM can reach the remote connector server and that the CSV connector is active. Log in to the Admin UI (https://localhost:8443/openidm/admin) and select Configure > Connectors. The CSV connector should be listed on the Connectors page, and its status should be Active.

   Connectors Tab Showing an Active CSV Connector

   
   
   

5. To test that the connector has been configured correctly, run a reconciliation operation as follows:

   1. Select Configure > Mappings and click the systemCsvAccounts_managedUser mapping.

   2. Click Reconcile.

   If the reconciliation is successful, the three users from the remote CSV file should have been added to the managed user repository.

   To check this, select Manage > User.