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

Posted on 2005-05-17
Last Modified: 2013-12-01
First things first:

Oracle Application Server 10g (9.0.4)
Oracle Discoverer Viewer

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.

Question by:jefflhansen
    LVL 13

    Accepted Solution

    See:Oracle Business Intelligence Discoverer Configuration Guide'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:

    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,

    LVL 13

    Expert Comment

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

    Expert Comment

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

    ...change fm (format), pg (page) as required.

    LVL 22

    Expert Comment

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

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

    Good luck!
    LVL 13

    Expert Comment

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

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Configure Web Service (server application) I. Configure security for Web Services methods First, we need to protect Session bean which implements the service: 1. Open EJB deployment descriptor (ejb-jar.xml) in the EJB project that contains you…
    There are numerous questions about how to setup an IBM HTTP Server to be administered from WebSphere Application Server administrative console. I do hope this article will wrap things up and become a reference for this task. You need three things…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now