JDBC Workflow Activity - Make database calls via workflow. You know you wanna.

[Christopher_Mal]

Look, there are life rules I live by
- buy low, sell high
- learning is a life long process
- play nice with others
- if you ever find yourself the opportunity to work with John Andersen you DO IT! The guy is brilliant. Seriously, I can't say enough about him. He was my mentor here at ServiceNow and the person who brought me on.

Anyhow - I recently had a customer that needed to make JDBC queries within a workflow, so I started working on a solution I could reuse for them and others. I mentioned my great idea to the one and only John Andersen and sure enough he was working on the same problem. I suggested instead of duplicating effort we work together. He agreed and I want to make available the combination of our efforts. I almost feel guilty saying that, because in reality his approach and code was better overall, so we went with his jdbc probe approach.

The attachment is on this page and includes only one new workflow activity.

I am posting this to the community so you will try it out and help us shake out any bugs. I still have on my todo list the following items:
1. Get attachment support in the on complete handler (in case our result is an attachment).
2. Data Source support (so you can configure a data source and just select which data source you want in the workflow activity)
3. Testing with the variety of databases we offer.

Please follow this forum for any updates we make to it (hopefully we can get our development to eventually add this activity to our product down the road). Your feedback is necessary (else you can't use our code). 🙂 Thanks all and stay tuned more to come.

JDBC Activity.zip