Security Software

I need to run a sql query against the OIM DB from a schedule task and I am having a hard time running the query. I could not find the api docs for com.thortech.xl.dataaccess.tcDataProvider to understand which methods are used to run the sql query and how to get the data from the resultset.

My other option would be create an external jdbc connection and retrieve the data, which I'd like to avoid.

If anyone has done that and can list it here that would be helpful.

Thanks in advance