Visual Composer JDBC System not BI ??????????????

[Former Member]

I Created a BI JDBC System, thats okay, a Can see the Tables into the VC, but I would like to create a "JDBC System" to see the procedures... from the Bank

I did it but is not working, somebody told me that I need to make other configurations on the J2EE administrator...

PLEASE HELPPPP

I Need to see the Procedures

[Former Member]

BI JDBC displays tables and views

Portal JDBC displays stored procedures.

Did you read the documentation for setting up a jdbc connection?

[Former Member]

Hi,

I have the same problem using OracleDriver but I can connect with sap one. Try this:

Connection URL: jdbc:sap:oracle://<host>:<port>;sid=<SID>

DriverClassName: com.sap.portals.jdbc.oracle.OracleDriver

Bye

[Former Member]

Yes I did , but a didin't find any documentation for Portal JDBC just for BI jdbc

[moyalynne]

hi marcus;

when configuring either type of JDBC system on the portal, did you check the <a href="http://help.sap.com/saphelp_nw04s/helpdata/en/0d/17df3d2cae445ae10000000a11405a/frameset.htm">System Landscape</a> documentation?

specifically, under Editing Systems, see:

<a href="http://help.sap.com/saphelp_nw04s/helpdata/en/84/d5df3df2ad685ae10000000a11405a/frameset.htm">Editing JDBC System Properties</a> (create this type of system to access your stored procedures in VC)

vs:

<a href="http://help.sap.com/saphelp_nw04s/helpdata/en/5e/4d48b62fe54c23a8dbef364a289d8f/frameset.htm">Editing BI JDBC System Properties</a> (create this type of system to access tables and BI functionality / Wizard / SQL Editor in VC)

hope it helps;

-m