Versions Compared

Key

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

Perform the following steps to create a datasource using stored procedure:

  1. In Canvas Sigma Studio, click Connections on the left pane. The existing connections are listed on the Connections tab.

...


  1. Image Added

  2. Right-click a an existing connection and select Create Data Source.

...


  1. Image Added

    The Create New Data Source page appears.

...


  1. Image Added

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

...


  1. Image Added

  2. Click Object Name field and select the stored procedure name from which you need to fetch the data. In this example, proceduresummary_summary procedure is selected.

...


  1. Image Added

    The parameter details of the selected stored procedure appears

...

  1. .

...


  1. Image Added

  2. Click Save. Save to save the stored procedure data source.

    Image Added

    The following confirmation message appears:

...


  1. Image Added

  2. Click Ok.