IT can start an automatic process from a trigger SQL SERVER? - OpenEdge BPM - Forum

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

OpenEdge BPM - Forum

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