Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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

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



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



    The Create Data Source page appears.



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



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



    The parameter details of the selected stored procedure appear.

    To apply procedure parameters for stored procedures, refer Applying System Parameters for Stored Procedures.




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



    The following confirmation message appears.



  6. Click Ok.
  • No labels

Copyright © Intellect Design Arena Limited.

All rights reserved. These materials are confidential and proprietary to Intellect Design Arena Limited and no part of these materials should be reproduced, published in any form by any means, electronic or mechanical including photocopy or any information storage or retrieval system nor should the materials be disclosed to third parties without the express written authorization of Intellect Design Arena Limited.