Execution of a database notification–based invocation is carried out in the following steps:
- Start the Gravity.exe application.
- Create a project (option PROJECTS). If you are passing data through a notification (PostgreSQL), the project should include a parameter, or the
INPUT DATA operator, to receive the transmitted data.
- Create a database notification at the database server level.
- Add a Database-type trigger (option TRIGGERS) and choose the database connection.
- Start the GravityTriggersRunner.exe server application or restart the gravity.integration service.
Refer to the configuration guidelines for specific database servers:
Notification Configuration for SQL Server
Notification Configuration for PostgreSQLNotification Configuration for Oracle Database - TODO
Because different database servers implement notification mechanisms differently, notifications are handled in various ways depending on the database type of the selected connection. For this reason, GRAVITY configuration also varies depending on the database system.
The project will be started when the database event monitored by the defined trigger occurs.