Skip to content

Integrating SailPoint with Generic Flat File

This document is designed to give specific information about the requirements and field definitions needed to get a working instance of a Generic Flat File source in SailPoint. This is an integration between a Flat File source and SailPoint that reads data from a file. The file contains all the relevant information about the accounts.

The Generic Flat File connector is a general-purpose tool used to load user account information from CSV files. It supports some account provisioning operations and Access Certifications (certification of entitlements connected to accounts), but only if those features are activated for your site. Generally, this connector is used as a read-only connector.

Note

You also have the option to use Delimited File Source Configuration Reference Guide.

Supported Features

The Generic Flat File source supports the following features:

Note

Before you can use any item marked with an asterisk (*), SailPoint must activate the feature for your site.

  • Load and *Provision Accounts
  • *Access Certifications (certification of entitlements connected to accounts)

For more information on SailPoint features, refer to Source Features.

Prerequisites

CSV File Requirements

  • The flat file you import must use the column headings included in the Flat File Template.

    Caution

    This can be impacted by schema changes on any flat file source. You should always use the most current Flat File Template when loading data.

  • If you remove a row from your flat file and import it, that account data will also be removed from SailPoint.

  • All accounts and entitlements must be sorted by the account name. For example, joe.smith's entitlements must all appear together in the file.
  • To import sources with large numbers of accounts and entitlements, SailPoint recommends breaking up the flat file source into separate CSV files of 400,000 lines or fewer. Each CSV file shows as a source in SailPoint.

SailPoint File Upload Utility

The SailPoint File Upload Utility provides a way for SailPoint customers to upload files to the cloud automatically.

You may use the SailPoint File Upload Utility with the Generic Flat File source. For more information about downloading and using the SailPoint File Upload Utility, refer to SailPoint File Upload Utility.

Documentation Feedback

Feedback is provided as an informational resource only and does not form part of SailPoint’s official product documentation. SailPoint does not warrant or make any guarantees about the feedback (including without limitation as to its accuracy, relevance, or reliability). All feedback is subject to the terms set forth at https://developer.sailpoint.com/discuss/tos.