Oracle^® Business Intelligence Enterprise Edition Deployment Guide > Implementing Single Sign-On Products With Oracle Business Intelligence > Sample Configuration Files >

Using J2EE integration

<?xml version="1.0"?>

<WebConfig>
<ServerInstance>
<!-- other settings ... -->
<Listener>
<Firewall>
<Allow address="127.0.0.1"/>
<Allow address="192.168.1.100/>
<Allow address="192.168.1.101/>
</Firewall>
<!-- other settings ... -->
</Listener>
<!-- other settings ... -->
<CredentialStore>
<CredentialStorage type="file" path="<OracleBIData>/web/config/credentialstore.xml" passphrase="another_secret"/>
<!-- other settings ... -->
</CredentialStore>
<!-- other settings ... -->
<Auth>
<SSO enabled="true">
<ParamList>
<!--IMPERSONATE param is used to get the authenticated user's username and is required -->
<Param name="IMPERSONATE"
source="serverVariable"
nameInSource="REMOTE_USER"/>
<!--Optional, NQ_SESSION.LOCALE sets up the user's locale as determined by SSO system -->
<Param name="NQ_SESSION.LOCALE"
source="cookie"
nameInSource="SSO_LOCALE"/>
</ParamList>
<!--Optional. Replace the URLs with actual logoff/logon URL-->
<LogoffUrl>http://hostname:port/sso/logoff</LogoffUrl>
<LogonUrl>http://hostname:port/logon</LogonUrl>
</SSO>
</Auth>
<!-- other settings ... -->
</ServerInstance>
</WebConfig>

This results in a connection string that takes on the following form:

UID=Impersonator;PWD=secret;IMPERSONATE=testuser;NQ_SESSION.LOCALE=en-US;