4
Accessing Oracle Discoverer 3i Viewer From Other Web Applications

Oracle Discoverer 3i Viewer can be accessed from other Web applications by specifying a combination of arguments in the URL. Rather than having your end users log in, choose a workbook, and worksheet, you can specify a URL that starts the Oracle Discoverer 3i Viewer for them. You can explicitly specify the settings that you want; for example, you can specify which workbook and worksheet you want to open and which parameter values to use.

This means you can embed live Discoverer reports directly onto your Web site pages simply by specifying the details in a URL. When the link is clicked the database is queried and the latest data is displayed in HTML.

After you create this URL, you can give it to end users to type into their Web browser. Or you can add the URL as a link on your company's Intranet site so that end users can make a specific database query with a single click.

In addition, you can also specify an end user's Applications Responsibility in this same URL.

4.1 Using arguments in URLs

You can specify username, database, EUL, workbooks, worksheets and worksheet pages as arguments placed in the URL.

Passwords are generally not displayed in the URL for security reasons. Discoverer 3i Viewer will ask users for a password before opening a worksheet.

4.1.1 What is the format of the URL to start Discoverer 3i Viewer automatically?

The URL you create must adhere to the standard URL command line syntax as follows:

http://mywebserver.mycompany.com/servletname?arg1=value1&arg2=value2&...&argN=valueN

where:

mywebserver is the Discoverer Server instance name

mycompany.com is your company nae

servletname is the location and name of the Discoverer 3i Viewer servlet

The URL must always include the following mandatory arguments:

username
database name
workbook name
worksheet name

Note that the order of the mandatory arguments is not important, but all of the mandatory arguments must be present in the URL.

In addition to the mandatory arguments, you can also include the following optional arguments:

worksheet parameters
page numbers

4.1.2 Mandatory URL arguments

In all the examples below, the URL specifies:

video33 as the username
video33 as the database name
sales as the workbook name
ws2 as the worksheet name

4.1.2.1 Username

Format:

&us=<username>

Example:

http://mywebserver.mycompany.com/disco/disco3iv
?us=video33&db=video33&wb=sales&ws=Sheet+1

4.1.2.2 Database

Format:

&db=<databasename>

Example:

http://mywebserver.mycompany.com/disco/disco3iv
?us=video33&db=video33&wb=sales&ws=Sheet+1

4.1.2.3 Workbook

Format:

&wb=<workbookname>

Example:

http://mywebserver.mycompany.com/disco/disco3iv
?us=video33&db=video33&wb=sales&ws=Sheet+1

4.1.2.4 Worksheet

Format:

&ws=<worksheetname>

Example:

http://mywebserver.mycompany.com/disco/disco3iv
?us=video33&db=video33&wb=sales&ws=Sheet+1

4.1.3 Optional URL arguments

4.1.3.1 Worksheet parameter

Format:

&qp_<parameter_name>=<parameter_value>

Example:

http://mywebserver.mycompany.com/disco/disco3iv
?us=video33&db=video33&wb=sales&ws=ws2&qp_City=
Denver&qp_City=Los+Angeles&qp_Year=1995

In the example, the URL specifies:

video33 as the username
video33 as the database name
sales as the workbook name
ws2 as the worksheet name
Denver and Los Angeles as values for the City parameter
1995 as the value for the Year parameter

4.1.3.2 Page number

Format:

&pg=<page_number>

Example:

http://mywebserver.mycompany.com/disco/disco3iv
?us=video33&db=video33&wb=sales&ws=ws2&pg=4