Anchor
__RefHeading__120302_661304196 __RefHeading__120302_661304196

Anchor
_Toc523144944 _Toc523144944

Creating a DB Data Source

...

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.
   Image Removed
   Image Added
   The Create New Data Source page appears.
   Image Removed
   Image Added
   
   The input parameters for stored procedure can be passed during the configuration of the base report in Canvas Studio and the values can be altered in Sigma screen as well.

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

4. Click the Object Name field and select the table, view, or stored procedure name from which you need to fetch the data.

   Note
   Stored procedures are yet to be enabled in App Designer.

   Image RemovedImage Added

5. Click the Column IDs field and select the columns to be fetched.
   
   

   Tip
   To quickly select all the columns for the report, click the Select All (Image Modified) icon. To remove all the selected columns, click the Remove All (Image Modified) icon. To select specific columns, select the checkbox adjacent to the column names as shown in the following screen shot: Image RemovedImage Added

   
   

6. Optional: Enter the condition for filtering the data in the Where Clause field. For example, the where condition, Price > (select avg(Price) from Products) can be given in the Where Clause field.

   Info

   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: Code Block language sql select * from Products where Product_ID = 'P001' Here, Product_ID = 'P001' can be given in the Where Clause field. Consider another example as follows: Code Block language sql 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.

   
   

7. Optional: Enter the column names by which you want to sort the data in ascending or descending order in the Order By field.
   Image Removed
   Image Added
8. Click Save.
   The following confirmation message appears: