This article contains a code sample for doing data access in Integration Manager. The source of the code is the IM script library, but there are bugs in that code and it also does not allow you do select a specific database.
The connection string includes a hard coded sa password, and the sql is 'pass through SQL', both techniques that we don't recommend. They're in this sample because they're the quickest thing to do.
Enjoy