Triggering a Workflow from Azure SQL Database

  • 22 November 2019
  • 5 replies
  • 7 views

Hello, 

 

I was wondering if there was a way to trigger a workflow from a Azure SQL Database. We are connecting a UiPath robot to the database and are trying to figure out if it is possible to kickoff the workflow when the database is updated.

 

Thanks!

Jim


5 replies

Good day Jimmy11

 

May you please check the following out?

“Triggering a new workflow based on status change”: https://community.k2.com/t5/General/Triggering-a-new-workflow-based-on-status-change/m-p/108928,

“Making Document and Content Extraction Easy with K2, UiPath, and Azure AI”: https://www.k2.com/blog/document-extraction-with-k2-uipath-azure,

“K2 Cloud + UI Path”: https://community.k2.com/t5/K2-Cloud/K2-Cloud-UI-Path/m-p/113498#M383.

 

Best,

Sunrise

Badge +7

Hello  @Jimmy11 ,

 

Start workflow

https://docs.uipath.com/integrations/docs/start-workflow

 

Start workflow from SQL Server or using SSIS

https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/Start-workflow-from-SQL-Server-or-using-SSIS/td-p/96716

 

Initiate Workflow With Smartobject

https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/Initiate-Workflow-With-Smartobject/m-p/81358#M24110

Good day Jimmy11,


 


Perhaps if you could try the following:


1. Open up management.


2. Go to Integration > Service instances.


3. Click on the "Add" button and name your service instance.


4. Select your service type, Authentication mode, Database Name and click "OK".


5. Click on the Newley created service type and select the "Generate SmartObjects" button.


6. choose the table applicable and click the "OK" button.


These steps will generate a smart object and place it in a new category in your designer under "All Items".


From there you can use the smart object in designer to generate a form that will Kickstart your workflow.


 


Kind regards,


Dumisani


 

Hi Jim,

 

Another option here, using indirect methods, is to use a scheduled K2 workflow to periodically poll the Azure SQL Database and then initiate a workflow for items that match a certain pattern or condition.  This method also works for on-premise SQL environments, or really any data source.

 

For example: 
You can create a workflow schedule (K2 Management > Workflow > Schedules) that runs a specific workflow to scan the SQL table every 15 minutes and start the job for items that have been modified. 

 

This works as long as there is a field that we can use to detect that the item is relevant (ex. Status column = 'New') and something we can change it to after it runs (ex. Status column = 'Processed'). 

 

Note:  If you want to use a different interval, that can be of course be configured within the schedule itself.

 

Schedule:
The scheduling allows you to run the trigger workflow on a set interval that you can control and monitor.

Badge +9

Hi Jimmy11


 


Go through this article below, i believe it will help you to get a solution of your issue


https://help.k2.com/kb002027


 


Regards


Elvis

Reply