Query Builder

To read or filter data from data source, you have to specify a query statement. You can manually enter the query or use the Query Builder tool to generate the query. Using the built-in query builder, you can build queries on tables in databases without having to write complex SQL queries.

1. The Query builder will fetch all the tables from the data source based on the details given and will appear as shown below:
2. Select the tables from which the data should be read and click Next
3. You can specify multiple JOIN conditions to merge tables/views from the list of tables selected. Select tables names and column names from the dropdown given. You can select the type of JOIN from the list of options given,
  • Inner Join
  • Left Join
  • Right Join
  After the JOIN conditions are specified, query builder will appear as shown below, Click Next to proceed.
4. Specify filter conditions if needed, based on the column name and column value. Click Next to proceed.
5. Select the columns which should be included in the query. External Data Connector will fetch values only from the selected columns. By default, all column values will be fetched from data source.
6. To retrieve aggregated results from multiple tables, you can specify aggregate condtions, for the selected columns like shown below. This is an optional step, skip if not required.
7. Aggregate functions often need an added GROUP BY statement. The GROUP BY statement is used in conjunction with the aggregate functions to group the result-set by one or more columns.
8. You can also specify ORDER BY conditions to sort the result-set by one or more columns. Click Next to proceed.
9. The Summary step shows all the condtions specified so far. Click Next to generate query for the specified condtions, or click Back to edit the conditions.
10. The Final Query step displays the generated query from the specified conditions. Click Close to use the generated query for integration, or click Back to edit the conditions.