Page History

The status component essentially is the feedback loop of the ETL (Extract, Transform, Load) process that was discussed in the introduction of the wiki.

In the Process Builder Canvas of DBSync, the Status action or process is located in the data flow of the "Execute" action and is located behind the Reader, Map, Writer of the data flow as shown in the screen shot below: Image Removed

To arrive at the screen shot provided above, please review section 3.1 of the wiki to add a PDL, and section 4.2 to open a process map. After opening the process map, right click on the "Execute" action on the Process Builder Canvas map and select "open dataflow". At this point you should be able to view the "Status" action and access a screen similar to the one in the screen shot presented above. Next follow the instructions given below:

1. Right-click on the Status Component and select 'Properties' to view the details. You can edit, save, delete and close the window.

2. Select the Adapter type from the drop down list. One can view and edit the properties of the specific adapters, such as the Console Adapter.

3. Click on the edit hyperlink to modify the changes of the specific properties of the xml file. The file should map to all the components, if it does not the application will display an error message.

Note: When more information is needed to complete the mapping, the application will display a message such as, “In order to do the mapping the Reader and Writer should be created and Required Adapters for Reader and Writers should be selected”"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:

Image Added

DBSync offers a very convenient way of building queries - ranging from simple to very complex queries.

1. On the Workflow page, select the data source and the object on which the query is to be built.
2. Add N number of conditions for the query being built -  "Add New Condition".
3. For adding a condition, a user has to select a field, an operator and, then enter the value within.
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. "Preview" - Shows the result set in the Query Result section.

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.