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.

jefflhansenAsked:
Who is Participating?
 
bochgochCommented:
See:Oracle Business Intelligence Discoverer Configuration Guide
http://download-uk.oracle.com/docs/cd/B14099_06/bi.1012/b13918/index.htm
...you'll need to register with OTN (which is free)...

To quote from Oracle documentation:

http://<host.domain>:<port>/discoverer/plus? is the Discoverer Viewer URL.

Add the parameter: cn=<value> to specify the connection ID of a Discoverer connection.
For more information about finding out connection IDs, see:
http://download-uk.oracle.com/docs/cd/B14099_06/bi.1012/b13918/urlstart.htm#i1016101

Other parameters:
opendbid=<value> specifies the workbook ID of a Discoverer scheduled workbook.
sheetid=<value> specifies the worksheet ID of a Discoverer scheduled worksheet.
workbooksource=Scheduled identifies the workbook as scheduled.

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

bg
0
 
bochgochCommented:
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,
0
 
bochgochCommented:
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.

0
 
DrSQLCommented:
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
0
 
bochgochCommented:
My first example allows connection without placing the password in the URL...simply replace *plus* in the URL with *viewer*.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.