Skip to content

CSV File Connector

Valera V Harseko edited this page Jun 14, 2024 · 2 revisions

The CSV file connector is useful when importing users, either for initial provisioning or for ongoing updates. When used continuously in production, a CSV file serves as a change log, often containing only user records that have changed.

Configuring the CSV File Connector

A sample CSV file connector configuration is provided in samples/provisioners/provisioner.openicf-csv.json.

OpenIDM provides a sample CSV File Connector configuration at Getting Started

The following example shows an excerpt of the provisioner configuration. The connectorHostRef property is optional and must be provided only if the connector runs remotely.

"connectorRef" : {
        "connectorHostRef": "#LOCAL",
        "bundleName"    : "org.openidentityplatform.openicf.connectors.csvfile-connector",
        "bundleVersion" : "[1.5.1.4,2)",
        "connectorName" : "org.forgerock.openicf.csvfile.CSVFileConnector"
}

The following excerpt shows the required configuration properties:

"configurationProperties" : {
    "csvFile" : "&{launcher.project.location}/data/hr.csv",
    "headerUid" : "uid" 
}

csvFile

The path to the CSV file that is the data source for this connector.

headerUid

The CSV header that maps to the uid (or name) for each row. Default: uid

The CSV file connector also supports following optional configuration properties:

encoding

Default: utf-8

headerPassword

The CSV header that maps to the password for each row. Use this property when password-based authentication is required.

fieldDelimiter

The character in the CSV file that is used to separate field values. Default: ,

quoteCharacter

The character in the CSV file that is used to encapsulate strings. Default: "

newlineString

The character string in the CSV file that is used to terminate each line. Default: \n

syncFileRetentionCount

The number of historical copies of the CSV file to retain when performing synchronization operations. Default: 3

OpenICF Interfaces Implemented by the CSV File Connector

The CSV File Connector implements the following OpenICF interfaces.

Authenticate

Provides simple authentication with two parameters, presumed to be a user name and password.

Batch

Execute a series of operations in a single request.

Create

Creates an object and its uid.

Delete

Deletes an object, referenced by its uid.

Resolve Username

Resolves an object by its username and returns the uid of the object.

Schema

Describes the object types, operations, and options that the connector supports.

Script on Connector

Enables an application to run a script in the context of the connector. Any script that runs on the connector has the following characteristics:

  • The script runs in the same execution environment as the connector and has access to all the classes to which the connector has access.
  • The script has access to a connector variable that is equivalent to an initialized instance of the connector. At a minimum, the script can access the connector configuration.
  • The script has access to any script-arguments passed in by the application.

Search

Searches the target resource for all objects that match the specified object class and filter.

Sync

Polls the target resource for synchronization events, that is, native changes to objects on the target resource.

Test

Tests the connector configuration. Testing a configuration checks all elements of the environment that are referred to by the configuration are available. For example, the connector might make a physical connection to a host that is specified in the configuration to verify that it exists and that the credentials that are specified in the configuration are valid.

This operation might need to connect to a resource, and, as such, might take some time. Do not invoke this operation too often, such as before every provisioning operation. The test operation is not intended to check that the connector is alive (that is, that its physical connection to the resource has not timed out).

You can invoke the test operation before a connector configuration has been validated.

Update

Updates (modifies or replaces) objects on a target resource.

CSV File Connector Configuration

Property Description Type Default Encrypted Required
csvFile Full path to the CSV file File null Yes
headerUid Name of the uid column as found in the CSV file String uid No
quoteCharacter Character used to quote fields String " No
headerPassword Name of the password column as found in the CSV file String password No
fieldDelimiter Character used to delimit columnar fields String , No
syncFileRetentionCount Number of sync history files to retain int 3 No
newlineString Character(s) used to terminate a line in the CSV file String \n No