Creating Database Polling Activity
- Gunjan Tulwani (Unlicensed)
- Saurabh Gupta (Unlicensed)
The Database Polling Service activity is used to check any changes in the data stored in a database table.
This feature is available in:
Enterprise | Premier | Professional | Express |
|---|---|---|---|
√ | √ | √ |
|
Prerequisites
Database Info activity must be created before creating Database Polling Service activity.
Steps to create a Database Polling activity
On the Adeptia Suite homepage, click the Develop tab.
Go to Services > Polling and then click Database.
The Manage Database Polling Service screen is displayed.
Click the Create New link. The Create Database Polling Service screen is displayed.
Type the name and description of the new Database Polling Service in the textboxes Name and Description text boxes respectively.
Select the Database Info Id activity from the dropdown list Database Info Id.
You can create the database event definition by entering an SQL Query or a database trigger command. By default, SQL Query option is selected. Enter the query in the SQL Query field. Select the operator for the query from the dropdown list Operator. Enter the value to be compared in the query in the Value field. The query should return only one record. If the query returns multiple records, then only the first record is accepted. If the query returns one record, then it will compare the value of the first field with the value specified in the Value field.
Alternately, enter the database trigger command in the SQL Trigger field.
Enter the name of Trigger in the SQL Trigger Name field.
Enter the time interval for Polling in the Polling Frequency field. Enter the digit in the Frequency field and select the unit of time i.e. seconds, minutes or hours etc. from the Duration dropdown list.
Enter the expiry time in the Expiry Time field. After expiry time process flow does not poll for data.
Click Save.
