Forum Post: Re: It Can Start An Automatic Process From A Trigger Sql Server?

  • Thread starter Thread starter Praveena Ampaty
  • Start date Start date
Status
Not open for further replies.
P

Praveena Ampaty

Guest
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

Continue reading...
 
Status
Not open for further replies.
Back
Top