Connections > Oracle Business Intelligence Publisher connection properties > Connect to Oracle Business Intelligence Publisher
  

Connect to Oracle Business Intelligence Publisher

Let's configure the Oracle Business Intelligence Publisher connection properties to connect to Oracle Business Intelligence Publisher.

Before you begin

Before you use an Oracle Business Intelligence Publisher V1 connection to read data from Oracle Business Intelligence Publisher, configure the output format of the reports as Data (XML) and Data (CSV). In the Oracle Business Intelligence Publisher application. Consider using Oracle Business Intelligence Publisher application for data extraction of smaller data volumes only.
The following image shows the page where you can set the value of the output format:
This image shows the page where you can set the value of the output format

Connection details

The following table describes the basic connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
Type
Oracle Business Intelligence Publisher
Use Secret Vault
Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
This property appears only if secrets manager is set up for your organization.
This property is not supported by Mass Ingestion.
When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
For information about how to configure and use a secrets manager, see Secrets manager configuration.
Runtime Environment
Name of the runtime environment where you want to run tasks.
Select Secure Agent, Hosted Agent, or serverless runtime environment.
BI Publisher URL
URL of the Oracle Business Intelligence Publisher application that you want to access.
Note: To validate the BI Publisher URL, type the following URL in the web browser:
<BI Publisher URL>/xmlpserver/services/ExternalReportWSSService?wsdl
If the URL opens a WSDL file, the Business Intelligence Publisher URL is valid.
Authentication Type
Type of user authentication to connect to the Oracle Business Intelligence Publisher application.
You can select Basic Authentication type.
Username
User name of the Oracle Business Intelligence Publisher account.
Password
Password for the Oracle Business Intelligence Publisher account.
Report Directory
The directory path where the reports are stored in the Oracle Business Intelligence Publisher application.
You can read a report from the following folders:
  • - Shared Folders
  • - My Folders
To read a report from Shared Folders, exclude Shared Folders from the directory path.
For example, if the report is in Shared Folders/Samples/Sales, specify the report directory as follows:
/Samples/Sales
To read a report from My Folders, exclude My Folders from the directory path and include ~username as the first node in the directory path.
For example, if the report is in My Folders/Samples/Sales, and the username is weblogic, specify the report directory as follows:
/~weblogic/Samples/Sales
Default value of the report directory is /Custom.

Advanced settings

The following table describes the advanced connection properties:
Property
Description
Output Directory
The directory path on the Secure Agent machine where you want to download the CSV files from Oracle Business Intelligence Publisher.
Note: This property applies only when you want to read data in the CSV data format.

Related links