Creating a DB Data Source

After the database connection is created, the data sources can be created for the connection as follows:

1. In Canvas Studio, click Connections on the left pane.
   The existing connections are listed in the Connections and Data Sources on the right pane.
   
   
2. Right-click the connection and select Create Data Source.
   
   
   The Create New Data Source page appears.
   
   

3. In the Create Data Source page, enter an unique data source name in the Data Source Name field.
   
   

4. Click the Object Name field and select the object name from which you need to fetch the data.
   
   

5. Click the Column IDs field and select the columns to be fetched.
   
   
6. Optional: Enter the column names by which you want to sort the data in ascending or descending order in the Order By field.
   
   

7. Optional: Enter the condition for filtering the data in the Where Clause field. For example, in the SQL code snippet mentioned in step 4, the where condition Price > (select avg(Price) from Products) can be given in the Where Clause field.

   If suppose, you want to fetch data based on certain values, you will have to specify the exact values in the Where Clause field. For example, consider the following SQL query:

   select * from Products
   where Product_ID = 'P001'

   Here, Product_ID = 'P001' can be given in the Where Clause field.

   Consider another example as follows:

   select Product_Name, Unit, Price
   from Products, Categories
   where Products.Category_ID = Categories.Category_ID
   and Categories.Category_ID = 'C001'

   Here, Products.Category_ID = Categories.Category_ID and Categories.Category_ID = 'C001' is the where condition, which can be specified in the Where Clause field. The tables Products, Categories can be specified in the Table Names field.

8. Click Save.
   The following confirmation message appears: