Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

obiee 12c how to use (import) SQL Server 2014 stored procedure as data source in RPD physical layer

Received Response
21
Views
2
Comments
User_INLWQ
User_INLWQ Rank 5 - Community Champion
edited Aug 13, 2024 5:21PM in Oracle Analytics Cloud and Server

Hi Gurus,

We are on OBIEE 12c, data source being a sql server 2014 stored procedure.

How do we model this in the physical layer of RPD ?        Creating a new table, selecting type as "Stored proc" and then leave the default button "default initialization string" checked and then giving the "EXEC [database_name].[schema_name].[procedure_name] ???

can't we instead select table type as "SELECT" and then give the entire "select from ........"  statement of stored procedure in the dialogue box ???

Please share inputs.

Thanks

Answers

  • User_INLWQ
    User_INLWQ Rank 5 - Community Champion

    Hi Gurus,

    Please share any inputs on this..

    Thanks

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    2711084 wrote:can't we instead select table type as "SELECT" and then give the entire "select from ........" statement of stored procedure in the dialogue box ???

    Well....how about you just *DO* it and let us know with an exact and detailed post if there is any issue?