Access SQL in portal

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi Phani Kumar,

Thanks for the reply. As i said earlier i am able to see the stored procedure which i created but i dont see any data when i try to preview it.

[Former Member]

I changed the property as dbo.spname.@result and it worked.

Thanks.