starting a process

Q&A
1

Greetings

I have a dabase outside bonita (SQL), and i need to initiate the process automatically, when new data is added to the SQL database. I got an api to get the data, but no idea of how to start a process without human interactions.

thanks

Mauro

2

You need to investigate the database…

The database will have a TRIGGER that can execute a program…this program should then start your process thought REST API’s

You say SQL, all databases are SQL (excluding NoSQL), so I can’t be more specific than that.

Here is a PostgreSQL example of what you’re looking for

http://www.postgresql.org/docs/9.1/static/sql-createtrigger.html

regards
Seán

PS: If this reply answers your question, please mark a resolved.