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 RCS configuration file (provisioner.openicf.connectorinfoprovider.json) to match your network setup.

   The following example indicates that the Java RCS 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 RCS.

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 RCS to use, and refers to the name property you specified in the provisioner.openicf.connectorinfoprovider.json file.

   • The bundleVersion : "[1.5.1.4,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 RCS is running.

3. Start IDM:

   /path/to/openidm/startup.sh

4. Verify that IDM can reach the RCS, 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 RCS 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

   Important

   Connectors continue to be released outside the IDM release. For the latest documentation, refer to the ICF documentation.

   
   
   

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.