Integrate with Oracle BI Server Security

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

• Configure Publisher for Oracle BI Server Security

• Add Data Sources to BI Server Roles

The Oracle BI Server security option is for customers who want to use legacy 10g authentication. This information doesn't apply to you if you configured Oracle Fusion Middleware Security.

These procedures assume that you performed the configuration required in the BI Server.

Configure Publisher for Oracle BI Server Security

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

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

   Note:

   To log in directly to the 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 Analytics Server server and copy the connection string. If this has not been configured, then see Set Up a JDBC Connection to the Oracle BI Server.

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

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

Add Data Sources to BI Server Roles

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

1. Log in to Oracle Business Intelligence as an administrator.
2. On the global header click Administration. On the Oracle Business Intelligence Administration page, click Manage Publisher.
3. On the Publisher Administration page, click Roles and Permissions. The groups to which you assigned the 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.