So you have Denodo, and you got the “Unsupported ResultSet type.” error, you’re in the right place.
Denodo’s JDBC Driver implementation does a validation check to make sure the ResultSet type is set to TYPE_FORWARD_ONLY (1003). By default, SailPoint’s connector bundle JDBC implementation sets the type to TYPE_SCROLL_INSENSITIVE (1004).
How do you fix it?
Edit the SPConfig of the source in question and add a property to the connectorAttributes section:
“resultSetType”: “TYPE_FORWARD_ONLY”
After importing the updated SPConfig, you should be in business.
This is most likely also applicable to IdentityIQ.