asked on

I want to invoke Discoverer from a URL specifying the sso and the Connection to use WITHOUT the Discoverer Connection Page appearing.

First things first:

Oracle Application Server 10g (9.0.4)
Oracle Discoverer Viewer 9.0.4.43.18

I am using Discoverer using SSO.

The url to discoverer viewer/plus with ssoconn specified works great, but it brings up the discoverer connection screen. The user then selects a connection to proceed into discoverer.

I would like to be able to specify the connection to be used on the url. With the connection specified, the discoverer connection screen should not appear.

ASKER CERTIFIED SOLUTION

bochgoch

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bochgoch

s/b:
Let me know if you need further help...I'll post more information when I'm at work in the morning if necessary,

bochgoch

For Discoverer Viewer, with the username and password in the URL use:

http://server:7778/discoverer/viewer?us=<db_user>&pw=<db_password>&db=<db>&wbk=<workbook>&fm=htm&pg=1
...change fm (format), pg (page) as required.

DrSQL - Scott Anderson

jeffhansen,
You might also want to look at the docs on OTN:

http://www.oracle.com/technology/products/discoverer/htdocs/hints/index.htm#viewer

It requires a free registration. This may address the SSO & connection issue without requiring a userid and password on the URL.

Good luck!
DrSQL

bochgoch

My first example allows connection without placing the password in the URL...simply replace *plus* in the URL with *viewer*.