Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Configuring BI Publisher Reporting Tool >

Configuring BI Publisher for XMLP Server

You configure BI Publisher while running an instance of Oracle BI as an administrator, in the BI Publisher Admin screen.

NOTE:  This section lists only those configuration settings that refer to Oracle BI Publisher. See the Oracle Business Intelligence Publisher User's Guide for further details of XMLP server configuration. See the Oracle Database Administrator Guide for complete details of database deployment.

To configure the XMLP Server in Oracle BI Publisher

1. Open your browser to the login page. For example:

   http://localhost:9704/xmlpserver

2. Log in using the user name and password Administrator.
3. In the Admin tab, review the following sections and links, and perform or verify the necessary configurations as necessary, as shown in the following table.

   Admin Tab Section	Links to Configuration Screens
   Data Sources	JDBC Connection JNDI Connection File
   Security Center	Security Configuration Roles and Permissions NOTE:  Create users, including the Oracle BI Administrator user, here.
   Delivery	Delivery Configuration Printer Fax Email WebDAV FTP CUPS Server
   System Maintenance	Server Configuration Scheduler Configuration NOTE:  The scheduler referenced for the Database component is not the Oracle Business Intelligence Scheduler. It is the scheduler used only by BI Publisher. Refresh Metadata
   Runtime Configuration	Properties Font Mappings
   Integration	Oracle BI Presentation Services NOTE:  The Admin Username and Admin Password entered in this screen are the administrator credentials for Oracle Business Intelligence, not for BI Publisher.

4. If necessary, change the default configuration of Oracle BI as a data source.
   • In the Oracle BI Publisher screen, click the Admin tab.
   • Select JDBC > Update Data Source.
   • Change the fields as shown in the following example:

     Data Source Name	Oracle BI EE
     JDBC Connection String	jdbc:oraclebi://BIServer_machine.domain:9703 ; NOTE:  The default connection string is jdbc:oraclebi://host:port/. The port number is set by the parameter RPC_SERVICE_OR_PORT in the NQSConfig.INI file. Modify the connection string for the JDBC data source named Oracle BI EE to point to the target Oracle BI Server.
     Username/Password	NOTE:  This is the administrator credential for Oracle BI.
     Database Driver Class	oracle.bi.jdbc.AnaJdbcDriver
     Use Proxy Authentication	No
     Allowed Roles	XMLP users

     NOTE:  The JDBC connection string example shows Oracle BI deployed without clustering or SSL. For a clustered or more secure deployment of Oracle BI using SSL, see the Oracle Business Intelligence Enterprise Edition Deployment Guide.

5. Make modifications in the Integration > Oracle BI Presentation Services section of the BI Publisher screen's Admin Tab:
   • Make sure that the Admin Username and Admin Password are the administrator credentials for Oracle Business Intelligence.
   • Make sure that the Server and Port fields point to Oracle BI.
   • The XMLP URL suffix is set to analytics/saw.dll during installation. When you enable Single Sign-on, change this URL to the application you define. For example: analyticsSOAP/saw.dll. For details, see the Oracle Business Intelligence Enterprise Edition Deployment Guide.
6. Click Apply to save your changes.
7. Restart the BI Publisher server as described in Starting and Stopping BI Publisher.