SQLLoader Connector Provisioning Not Updating SFTP File

Hello everyone,

I’ve set up a source using the SQLLoaderr that is my SFTP Server. When I request an entitlement and assign it to an account, it shows as provisioned in ISC, but nothing actually changes on the SFTP server file.

Could you please help me understand what I might be missing?


Example CSV file data:

Column 1 Column 2
Test User 1 HR
Test User 2 Network
Test User 3 Dev

Some configuration:

Result after requesting and assigning the entitlement:
(screenshot)


But when I check the file on the SFTP server, it still looks the same — no changes to the entitlements:

Column 1 Column 2
Test User 1 HR
Test User 2 Network
Test User 3 Dev

What I want to achieve:
:white_check_mark: After provisioning, I expect the file to be updated with the new entitlement assignment.

Thank you in advance for your help!

hi using Delimited Based Connector it cannot provision the access and update your file preset on SFTP server. In general this is the process that will happen for disconnected based applications. When request is raised and approved in ISC SailPoint can use ServiceNow Service Desk and create a ticket in SNOW to the application team
Then application team will take the action in the target and update your SFTP file.
If there is no ServiceNow Service Desk config then SailPoint will create a Manual WorkItem you can check them in UI by navigating to Admin > DashBoard > To Do Activity.
Here also you need to close the workitem and update the file manually and run the aggregation back to SailPoint.
Either way you have to manually update the file unless you have implemented some customization outside to update the file.

Hi @udayputta,

If I want to do it manually, I still can’t, because I don’t see it in the To Do list either.

Maybe I didn’t give enough information earlier, which could have caused some misunderstanding. I’m using SQL-Loader for both the source and the target. I connected to the SFTP server and successfully retrieved the information. Then, I assigned the entitlement, but it still doesn’t provision back to the target

Oh you are using SQL-Loader connector that makes sence. Can you let me know which connection type you are using Direct Connection or Flat File. Can you also share the JDBC rule that you have attached to validate if there is anything wrong

Hi @udayputta,

I using the SQLLoader in a Direct Connection mode

This is my SQL Query

If something wrong with this or you need more information don’t hesitate to tell me, I will provide you more information.

can you share additional query settings screenshot as well.

Hi @udayputta, this is more information

This looks fine @fewthiraphat you have to create a rule and attach it.
See the sample rule below.

You can also find a sample query in the doc

1 Like

After I read this, I think this should be work, Thank you @udayputta :grinning_face:

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.