2022

Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 23 Current »


Definition

"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. 

 

Query Builder

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.

  1. Initially, when a user lands on this Workflow detail page, s/he will have to select the Data source and the object on which the query is to be built.
  2. S/he can add N number of conditions for the query being built by clicking on "Add New Condition".
  3. For adding a condition, a user has to select a field, an operator and, then enter the value with in ' '
  4. Based on the number of conditions added, the filter logic is auto populated. However, a user can change the logic by manually entering a value. 
  5. Clicking on the preview button - adjacent to the filter logic - will show the result set in Query Result section.

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


Advanced Query Builder 

The advanced query builder lets the user build complex queries and contains three sections:

  1. Schema - loads up the whole of source schema with whole table. It can be expanded to show the columns with respective data types. 
  2. Query Builder - Queries are pre loaded for Templates loaded from Template library. A user can write their own queries too.
  3. Query Result  - Shows result of relational data models and XML structures. The data is shown in a tree format.
  • No labels