Hello Community,
I need to export specific identity data from SailPoint Identity Security Cloud to a CSV file located on an SFTP server using the SQL Loader Connector.
Unfortunately, I’m struggling to get the export functionality working as expected. I would greatly appreciate your guidance or examples on how to achieve this.
What I’m Trying to Achieve
1. Export specific identity attributes (e.g., sAMAccountName, firstname, lastname, email, etc.) from SailPoint Identity Security Cloud.
2. Save the exported data as a CSV file named test.csv on my SFTP server.
The SFTP server details:
Root Directory: c:\sftp
My Current Configuration of connector:
Sure I’ve filled out the username and password, connection settings:
• Data Files URL: jdbc:csv:sftp://{hostname}/
• Driver Class: com.hxtt.sql.text.TextDriver
• Additional Connection Parameters:
_CSV_Header=true
_CSV_Separator=,
Query Settings
1. Test Connection SQL Query:
SELECT 1;
This works successfully and confirms the connection is active.
2. Account SQL Query (simplest query for testing):
SELECT firstname FROM test;
When I run the aggregation Task in SailPoint Connector Settings.
I receive this error
Log message is not clear to me. I’m unsure if my SQL query or configuration is missing something critical for exporting the data.
Thank you in advance for your help!