How to Execute ODA dataset from within script

cjnoyes

I need to execute and get results from a dataset within a scripted event handler

It's a simple query, I could code a jdbc query, but how do I get the a jdbc data source from the oda data source?

I would rather use one of the oda datasets if possible.