SQL Loader, examples for provisioning, enable/disable, update?

Hi! I was wondering if there was any sample code or documentation that would provide insight into leveraging the SQL loader for writing to a DIFFERENT text file than is being used for aggregation. Need to perform the following actions

Create
Enable
Disable
Update

1 Like

Let me look into this and circle back for you @jalexander.

Thanks Michael. I reviewed the connector guide but there is minimal information in regards to what I am looking for.

1 Like

The SQLLoader Connector uses JDBCProvisioning type rules, and treats delimited files as database tables. The Rule assumes that the “database table” in your insert/update SQL query matches an existing file name. For example: in your JDBCProvisioning you would execute the following SQL statement: UPDATE Users SET FirstName = “Test” WHERE USERID=“Test.User”. This means there must be a file named Users.csv. You can provision to a different file by changing the SQL statement. You can use the sample JDBCProvisioning Rules that are available in the /WEB-INF/config/examplerules.xml of your deployed IdentityIQ Web Application

2 Likes