Can we attach Nintex Workflow with Database Table ?


Badge +1

Hi

Can we attach Nintex Workflow with Database Table ?

We have several tables on SQL database and we want to attach nintex workflow on Database table , as we see nintex is very good working with SP List/Library and we assume there should some way.

Is there any way ?

Thanks


3 replies

Badge +11

Hi Sharda,

if you wan't to query a database in a nintex workflow you can use "Execute SQL" action:

If this is not what you need, please specify what you mean by attach with database table.

Regards

Philipp

Badge +1

hi ,

Yes - we are able to fetch the SQL tables result using "Execute SQL" action .

Actually we have several business related content are saved into SQL table and we shows content into web part(not in SP List) .

So we are having requirement for attaching workflow with SQL table for example there is project list table in SQL and when any project are added into table we want to trigger workflow .

Please suggest .

Badge +11

I'm not a database expert, but maybe you could Create a Trigger on your database which calls a stored procedure. I found this tutorial about how to invoke a web service from a stored procedure. Then you could at least call the Nintex WebService and e. g. start a Workflow. Maybe that's an option for you.

May I ask how (by which application) this data is inserted into your db?

Regards

Philipp

Reply