Sailpoint IdentityIQ – Configure Delimited File (CSV) Connector
Using a CSV connector is a common activity among any identity management solution, on this post you will configure the Delimited File connector within Sailpoint IdentityIQ.
We will use the following sample file to import into IdentityIQ and create identities.
- Go to Applications > Application Definition > Click Add New Application.
- IdentityIQ display the Edit Application form. From the Application Type select DelimitedFile
3. On the screen populate the name, owner and select Authorization Application.
4. Click Configuration tab and select file transport, file path, parsing type and delimiter.
5. Click Schema tab and scroll-down. From there click the Discovery Schema Attributes. That will load the csv file schema into the IdentityIQ.
6. Scroll-up and complete the configuration adding the Identity Attribute and Display Attribute.
7. At this point you can scroll-down and click the Preview button. This will display some sample of the data matching the defined schema. Click the Save button and now the connector is ready to import data.
8. Now you configure an account aggregation for the Employees delimited file previously defined. Run it and you will see the accounts being aggregated into IdentityIQ. The screenshot below shows the file we used to configured with only 2 accounts.
9. Go to Identities > Identity Warehouse and you will see the 2 users from the CSV file now with an identity created.
10. Click on any of those users and additional information is displayed.
11. Click the Application Accounts for the selected user and you will see the Employees application created and all the attributes from the csv file listed.
Keep visiting us for quick reviews about Sailpoint IdentityIQ.
Gabriel Magarino
Gabriel Magarino – Senior Security Manager | IAM Evangelist - Experienced leader with over 20 years in the IT and cybersecurity industry, specializing in Identity & Access Management. Expert in Okta, One Identity, SailPoint (IdentityIQ & IdentityNow), OneLogin, Delinea, and CyberArk. Passionate about exploring IAM and emerging technologies, coaching, and training IAM teams. Holds a Master’s in Computer Science and multiple certifications, including Okta Professional & Administration, One Identity Architect & Instructor, SailPoint Identity Now, ITIL, Scrum Master, among others. Currently pursuing a PhD with a focus on Computer Science and Artificial Intelligence.