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

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