2022
The status component essentially is the feedback loop of the ETL (Extract, Transform, Load) process that was discussed in the introduction component of the wiki.
"Trigger" is a mechanism to activate/extract information from the source system to use in the target system.
Trigger facilitates information to be read from the source system through a mechanism called Query Builder.
There are advanced versions of the query builder 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.
Trigger section is as shown below:
Panel |
---|
Query Builder |
DBSync offers a very convenient way of building queries - ranging from simple to very complex queries.
Panel |
---|
Advanced Query Builder |
The advanced query builder lets the user build complex queries and contains three sections: