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

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

 Forum

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

This question is answered

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

Verified Answer
  • 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
  • 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
     
  • Thank you