DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 15

changes.mady.by.user Anil Bhimineni

Saved on

compared with

New Version Current

changes.mady.by.user Tushar Singh

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
Definition

"Trigger" is the a mechanism to activate/ Extract extract information from the source system for to use in Target the target system. In DBSync the Trigger section is as shown below, Trigger facilitates the

Trigger facilitates information to be read from the source system through a mechanism called Query Builder.

There are a advanced version versions of the query building builder mechanism, where complex queries - involving across multiple objects are created , - can be created. The result set can also be viewed at run-time, making it convenient for the user users to change the 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 ones to very complex queries. The query builder can be used to build simple query ,mostly basing on a single object.

...

  1. On the Workflow page, select the data source and the object on which the query is to be built.
  2. He/She can add Add N number of condition conditions for the query being built by clicking on -  "Add New Condition".
  3. For adding a condition, a user has to select the a field, select the an operator and, then enter the value with in ' 'Basing within.
  4. Based on the number of conditions added, the filter logic is auto populated and by chance if he/she wishes to -populated. However, a user can change the logic they can do by entering the value Clicking on the preview button adjacent to filter logic will show the manually entering a value. 
  5. "Preview" - Shows the result set in the Query Result section.

The below table demonstrates the operators supported and meanings of each operations  

S.No

Operation Name

Operation Description

1

equals to

 

2

not equals to

 

3

greater than

 

4

greater than equals

 

5

less than

 

6

less than equals

 

7

like

 


Panel

Advanced Query Builder 

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

  1. Schema - Loads up the whole of the source schema with the table. It can be expanded to show the columns with respective data types. 
  2. Query Builder - Queries are pre-loaded for Templates loaded from the 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.