Introduction

With the CoreOne CSV Connector you can provision (CRUD) identities to a comma separated values files. The users, their attributes and properties are handled as any other identity within the CoreOne Suite. You simply create a provisioning configuration with the attributes of your choice. Those attributes are then represented as a new column within the configured CSV file.

System Identity Types

The following system identity types are supported:

Identity Type	Description

Identity Type	Description
`CSV User`	A user representing a row in the CSV file.

CSV User

The following user attributes can be manged by default:

Attribute	Description

Attribute	Description
`Id`	Uniquely identifies the user in the file
`firstName`	The first name of the user
`lastName`	The last name of the user
`birthDate`	The birth date of the user

Note you can add as many new attributes as you like using the Admin User Interface

System Resource Types

The following system resource types are supported:

Identity Type	Description

Identity Type	Description
`CSV Group`	A virtual resource used to initiate the creation of the user.

Target System Parameters

Whenever you connect a SAP system to the CoreOne Suite you will need to specify the following parameters.

Parameter	Mandatory	Example	Description

Parameter	Example	Description
`Delimeter`	,	The delimeter to be used
`Multi Value Delimiter`	;	The delimiter to be used to seperate multiple values for the same attribute
`Storage Location`	\\networkdrive\exports\demoappusers\	Where to store the maintained CSV file
`Filename`	userlist.csv	The filename of the CSV to be maintained
`Encoding`	utf-8	The encoding of file
`Configuration File Name`	config.json	Json file with configuration for Ressource Assignments, needs to be manually added in `Storage Location`

Example config.json file:

[
  {
    "ResourceTypeId": "16",
    "FilePath": "\\\\networkdrive\\Folder\\",
    "FileName": "resource_type_16.csv",
    "ResourceParametersFileName": "resource_parameters_type_16.csv",
    "Delimiter": ";",
    "MultiDelimiter": "|",
    "Encoding": "utf-8"
  },
  {
    "ResourceTypeId": "17",
    "FilePath": "\\\\networkdrive\\Folder\\",
    "FileName": "resource_type_17.csv",
    "ResourceParametersFileName": "resource_parameters_type_17.csv",
    "Delimiter": ";",
    "MultiDelimiter": "|",
    "Encoding": "utf-8"
  },
  {
    "ResourceTypeId": "18",
    "FilePath": "\\\\networkdrive\\Folder\\",
    "FileName": "resource_type_17.csv",
    "ResourceParametersFileName": "resource_parameters_type_18.csv",
    "Delimiter": ";",
    "MultiDelimiter": "|",
    "Encoding": "utf-8"
  }
]

Additional Information:

There will be automatically created file identity_to_resource.json, it’s needed so don’t delete it unless you have problems with generating ressource assignments files and need to remove them and regenrate, then you need to remove that file as well.

Identity features

The following identity functions are supported:

System Connector task features	Supported
Create/delete identities
Provisioning identities
Update identities
Provisioning identity updates
Deprovision identities
Cleanup of inactive identities active	-
Check password changed active	-

Resources features

The following resource functions are supported:

System Connector task features	Supported
Create/delete resources
Provision resources
Update resources
Provisioning resource changes
Deprovisioning resources
Provisioning resource allocations
Deprovisioning resource allocations
Provisioning resources-resource allocations	-
Deprovisioning resource resource allocations	-

Cleanup features

The following cleanup functions are supported:

System Connector task features	Supported
In the should-actual Log available
Should be - Actually is - cleanup	-
Read back account properties	-
Resource identity member target system clean up	-
Resource resource member target system clean up	-