2022
"Trigger" is a mechanism to activate/Extract information from the source system for the use in the Target system. In DBSync, the Trigger section is as shown below, Trigger facilitates information to be read from the source system through a mechanism called Query Builder.
There are advanced versions of query building mechanism, where complex queries - involving across multiple objects - can be created. The result set can be viewed at run-time, making it convenient for users to change a query as and when needed.
DBSync offers a very convenient way of building queries - ranging from simple to very complex queries. The query builder can be used to build simple query, mostly based on a single object.
The below table demonstrates the operators supported and meaning of each operation.
S.No | Operator Name | Operator Description |
---|---|---|
1 | equals | |
2 | not equals to | |
3 | greater than | |
4 | greater than equals | |
5 | less | |
6 | less than equals | |
7 | like |
The advanced query builder lets the user build complex queries and contains three sections: