2022
"Trigger" is the mechanism to activate/ Extract information from the source system for use in Target system . In DBSync the Trigger section is as shown below, Trigger facilitates the information to be read from the source system through a mechanism called Query Builder.
There are a advanced version of query building mechanism , where complex queries involving across multiple objects are created , result set can also be viewed at run-time making it convenient for the user to change the query as and when.
The below table demonstrates the operators supported and meanings of each operations .
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 to build complex queries , here whole schema relating to the source system is loaded up and contains three different sections