Connect Directly to Discoverer Viewer

Here you can post the Business Intelligence (BI) related queries and replies.
Post Reply
smarteng
Posts: 11
Joined: Tue Apr 28, 2009 5:24 am
Location: Egypt

Connect Directly to Discoverer Viewer

Post by smarteng »

Version R12/11i? = 11i
Instance PROD/TEST/VIS? = PROD
Module? =
OS? = Windows 2003

Hi,
The Customer's Manager asked to connect directly to discoverer viewer i.e he does not want to enter the connection details each time he wants to login.
Is it possible or not?

Thanks
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Here is a metalink note,

How To Login Automatically With Discoverer 3i/4i Viewer [ID 208367.1]
Modified 12-AUG-2004 Type BULLETIN Status PUBLISHED


Problem Description
-------------------

How to login automatically in Discoverer 3i/4i Viewer ?

Solution Description
--------------------

The following steps will make Discoverer Viewer login automatically
instead of presenting the user with a login screen.

For this method to work to work, the user's browser must have JavaScript enabled.
If this is not OK, add an <input type="submit" value="Login"/> element within the <form> element, users can then click a "Login" button instead of relying on JavaScript to submit the form automatically.

Before making changes to any of the files, take a backup of the file.

In the page_layouts.xsl file Add the following template

<xsl:template name="layout_auto_login">
<html>
<head><title>Auto Login</title></head>
<body>
<form method="post" name="autoLogin" action="{/discoverer/request/@source}">
<!-- Specify the User Name in the value field below -->
<input type="hidden" name="us" value="username"/>
<!-- Specify the Password in the value field below -->
<input type="hidden" name="pw" value="password"/>
<!-- Specify the Database in the value field below -->
<input type="hidden" name="db" value="database"/>
<!-- Specify the Language Code in the value field below (en is English) -->
<input type="hidden" name="nlsl" value="en"/>
<!-- To show a list of Database Workbooks, leave the following two value fields set to "dwb"
otherwise, set them to "swb" for Scheduled Workbooks. -->
<input type="hidden" name="in" value="dwb"/>
<input type="hidden" name="_in" value="dwb"/>
<!-- The following line requests the user is logged in using the
default method (as set in viewer_config.xml) -->
<input type="hidden" name="lc" value="false"/>
</form>
<script language="JavaScript">
document.autoLogin.submit();
</script>
</body>
</html>
</xsl:template>

Follow the comments in the template to specify the user name, password and connect string details.

In the disco3iv.xsl/disco4iv.xsl

Search for the text layout_connected and replace this text
with layout_auto_login.

ex:
replace
<xsl:call-template name="layout_connected"/>

with

<xsl:call-template name="layout_auto_login"/>

Restart Oracle HTTP server. Now running Discoverer Viewer should logon to database automatically.
smarteng
Posts: 11
Joined: Tue Apr 28, 2009 5:24 am
Location: Egypt

Post by smarteng »

But i'm using Discoverer 10g with APPs 11.5.10.2
is this configuration valid with discoverer 10g?

Many Thanks
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests