IT can start an automatic process from a trigger SQL SERVER?

Posted by Fernando.Ferreira on 09-Dec-2015 12:26

I have a process that should start every time a new record as created  in a trigger SQLSERVER, this process has basically four worksteps:

1 - In SQL SERVER is created an information on a Trigger in SQLSERVER, this  trigger must start a process in BPM

2 - The SQL information received will be transferred to a workstep to call a OpenEdge AppServer

3 - The AppServer return an information to the SQL SERVER

4 - End of process.

Many Thanks

Fernando

Posted by Praveena Ampaty on 10-Dec-2015 03:16

Hi Fernando,
 
1. To connect and instantiate BPM Process from  SQL Server triggers you can use web Services (You can find web services from the endpoint http://servername:18793/sbm/services) from BPM end.
 
2. In order to receive data from SQL server, you need to have DB Adapter with SQL server connection details in your process and an  OEAdapter to send data to appserver. Using dataslots you can pass the data to and fro from DB Adapter to OEAdapter.
 
3. OEAdapter will be retrieving appserver information and sending it to other dbadapter which will be updating in database.
 
Your designed process look like the below image for the 2,3 & 4 steps.
 
Hope this helps,
 
Thanks,
Praveena
 

All Replies

Posted by Praveena Ampaty on 10-Dec-2015 03:16

Hi Fernando,
 
1. To connect and instantiate BPM Process from  SQL Server triggers you can use web Services (You can find web services from the endpoint http://servername:18793/sbm/services) from BPM end.
 
2. In order to receive data from SQL server, you need to have DB Adapter with SQL server connection details in your process and an  OEAdapter to send data to appserver. Using dataslots you can pass the data to and fro from DB Adapter to OEAdapter.
 
3. OEAdapter will be retrieving appserver information and sending it to other dbadapter which will be updating in database.
 
Your designed process look like the below image for the 2,3 & 4 steps.
 
Hope this helps,
 
Thanks,
Praveena
 

Posted by Fernando.Ferreira on 22-Dec-2015 14:45

Thank you

This thread is closed