Integrating with Oracle BI Server Security

If you have installed BI Publisher as part of the Oracle Business Intelligence Enterprise Edition and you have configured Oracle BI Enterprise Edition to use legacy Oracle BI Server authentication, then follow the procedures below to configure BI Publisher to use BI Server security.

Note:

The Oracle BI Server security option is for customers who want to use legacy 10g authentication. This section does not apply to you if you have configured Oracle Fusion Middleware Security.

These procedures assume that you have performed the configuration required in the BI Server. For information on configuring legacy Oracle BI security, see Security Guide for Oracle Business Intelligence Enterprise Edition.

Configuring BI Publisher for Oracle BI Server Security

You configure BI Publisher for BI Server Security on the Administration page.

To configure BI Publisher for BI Server Security:

  1. Log in to BI Publisher with administrator credentials. Navigate to the BI Publisher Administration page. On the Administration page, click Security Configuration.

    Note:

    To log in directly to the BI Publisher server, use the login URL with the /xmlpserver suffix, for example: http://example.com:9502/xmlpserver

  2. In the Authorization region of the page, select Oracle BI Server from the Security Model list. Provide the following connection information for the Oracle BI Server:

    • JDBC Connection String — Example: jdbc:oraclebi://host:port/

      If you don’t know the connection string to the BI Server, then you can copy it from data source connection page. From the Administration page, under Data Sources, click JDBC Connection. Locate the Oracle BI EE server and copy the connection string. If this has not been configured, then see Setting Up a JDBC Connection to the Oracle BI Server.

    • Database Driver Class — Example: oracle.bi.jdbc.AnaJdbcDriver

  3. Click Apply. Restart the BI Publisher application for the security changes to take effect.

Adding Data Sources to BI Server Roles

Add data sources to BI server roles from the Administration page.

To add data sources to BI server roles:

  1. Log in to Oracle Business Intelligence as an administrator.
  2. On the global header click Administration. On the Oracle BI Administration page, click Manage BI Publisher.
  3. On the BI Publisher Administration page, click Roles and Permissions. The groups to which you assigned the BI Publisher groups are displayed as available roles.
  4. Find the group (role) to add data sources to and click Add Data Sources.

    Alternatively, you can navigate to the data source and add the roles that require access to the data source.

  5. Locate the appropriate data sources in the Available Data Sources list and use the shuttle buttons to move the sources to the Allowed Data Sources list for the role.
  6. Click Apply.
  7. Repeat the above steps for all roles that need access to report data sources.