Skip to Content
author's profile photo Former Member
Former Member

Access SQL in portal

Hi,

I am a SQL guy and new to Portal. My question is how should i access the stored procedure in portal.

I tried and got the list of stored procedures on my portal but i cant able to fetch any data from it. Am i missing some thing here? Please advice.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 27, 2007 at 02:12 AM

    Hi Dhana,

    In order to access Stored procedures which are resided in SQL Server or Orcale you need to first create an System Object for it in the Portal >System Administration >System Landscape---Create a new Systesm and choose JDBC System.

    http://help.sap.com/saphelp_nw70/helpdata/en/84/d5df3df2ad685ae10000000a11405a/frameset.htm

    Secondly you have to create an JDBC iView under the Content Administration-->Create a new iview and choose JDBCstored Procedure iView

    http://help.sap.com/saphelp_nw70/helpdata/en/a2/b59589e5a942838247493b255d5981/frameset.htm

    Hope this helps for you.

    Regards

    Phani

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.