1. Connecting Oracle Analytics Cloud to Your Data
  2. Connecting Oracle Analytics Cloud to Your Data
  3. Connect to Data for Pixel-Perfect Reports
  4. About Proxy Authentication

About Proxy Authentication

Oracle BI Publisher supports proxy authentication for connections to various data sources

Supported data sources include:

  • Oracle 10g database

  • Oracle 11g database

  • Oracle BI Server

For direct data source connections through JDBC and connections through a JNDI connection pool, Oracle BI Publisher enables you to select "Use Proxy Authentication". When you select Use Proxy Authentication, Oracle BI Publisher passes the user name of the individual user (as logged into Oracle BI Publisher) to the data source and thus preserves the client identity and privileges when the Oracle BI Publisher server connects to the data source.

Enabling this feature requires additional setup on the database. The database must have Virtual Private Database (VPD) enabled for row-level security.

For connections to the Oracle BI Server, Proxy Authentication is required. In this case, proxy authentication is handled by the Oracle BI Server, therefore the underlying database can be any database supported by the Oracle BI Server.