SQL Loader Connector Behavior for CSV Export (Provisioning)

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hello Team,

We are planning to use the SQL Loader connector to export data into a CSV file on an server using SFTP protocol.

So far, we’ve configured the Account (Connection Settings) and Query Settings, and we are successfully aggregating accounts using this configuration. Indicating no network error and it’s on the same network.

To export the report, we’ve implemented a JDBC Provisioning Rule. While new accounts are getting provisioned, no records are being written to the CSV file, and we are not seeing any errors in the logs.

I wanted to clarify:

  • Does the connector use the connection settings(target details) from the Query Settings to write to the target CSV file?
  • Or, do we need to explicitly define the target file details (e.g., server path, file name) within the JDBC Provisioning Rule?

Appreciate your support.

Thanks!