Hey, I can connect sure, but I'm thinking it would be helpful to put some of that info out here for other folks to benefit from as well.
We have been doing 2 things primarily: pulling data out and staging it in our SQL tables. We pull quite a bit every hour. No big issues there (knocks on wood). We use a PowerShell script to pipe it into SQL. SQL runs the scripts via Agent as a light SSIS package. We were using SSIS to pull Skyward data, this is much simpler and faster.
The other ultra cool thing we are doing is creating new records in Q. Only invoices so far: travel reimbursement and po/non-po invoices. That happens using the Workflow HTTP Web activity.
We have quite a bit more in mind, but the method should all stay pretty much the same: pull with PowerShell and write with Workflow.
I have a tight deadline to meet, so not much time to spare until Nov 1st. I'm curious to hear who else have been doing similar things in Q. Thanks!