Connect OAC with ADW

To connect OAC with ADW requires two configurations. One connection for use with DV and one for use with OAC Answers & Dashboards.

To create both connections, first download the Security Wallet from ADW and create the Admin Password (if not already done).

Prepare configuration of ADW

Download Wallet:

1) Go to ADW instance and click DB Connection Button

image

3) click Download Wallet

image

which stores the .zip file to you local drive:

image

This .zip file can already be extracted, since the tnsnames.ora and the cwallet.sso file are needed for later steps:

image

Set Admin Password

If not already done navigate to the ADB Service Console

image

and click Administration and set the Admin password:

image

Configure Connection for ADW of OAC (Answers & Dashboards)

To configure the connection to ADW for Answers and Dashboards of OAC navigate to the OAC Service with a similar URL like below:

https://***tenant.name***.analytics.ocp.oraclecloud.com/dv/ui?pageid=home

and click on Console:

image

click on Connections under Configuration and Administration

image

click on Upload wallet on the right Burger Menu:

image

This allows to upload the previously downloaded wallet from the hard drive (you may need to acknowledge a virus scan warning before):

image

After uploading the Wallet successfully a success message will be displayed:

image

After click the Burger Menu on the right again the button will now display “Replace Wallet” instead of “Upload Wallet”:

image

After the Wallet has been uploaded, the connection can be defined using the Create Button on the right. Within this Menu its important to select “Host, Port and Service Name” from the Connect Using dropdown Menu and enable SSL.

image

The Host, Port and Service name can be retrieved from the extracted tnsnames.ora file of the Wallet. This file can be opened in any editor to check the values:

image

The Connection will be displayed in the list:

image

A new metadata model can now be created and uploaded to OAC using this connection.

Configure Connection for ADW of DV (Data Visualisation)

On the Homepage of OAC click Data and select Connection:

image

click ADW from the available connection types:

image

specify the connection details and upload the extracted sso credential files from the wallet (cwallet.sso):

image

The connection will be displayed in the list of connections:

image

After the connection is established, a Data Set can be created using this Connection to ADW.

Oracle BI EE 12c: Configuring first Oracle Database connectivity with TNS Names after installation

In case the oracle Database should be used by Oracle BI, the database connectivity must be configured after the installation using the Oracle Database driver and TNS Names configuration.

For the server machine

On the Server (where Oracle BI EE 12 is installed), the Installation routine of Oracle BI automatically ship’s a Instant Client Version of the Oracle Database Client (Database driver).
The files of the driver are located within the following directory:
/u01/apps/obi12c/product/Oracle_Home/instantclient

On Linux/Unix On Windows Description
libclntsh.so.10.1 oci.dll Client code library
libociei.so oraociei10.dll OCI Instant Client data shared library
libnnz10.so orannzsbb10.dll Security library

The TNS Names configuration that should be used by the Oracle BI Server has to be specified by the sqlnet.ora and tnsnames.ora which need to be placed within the following directory:

/opt/biee/user_projects/domains/bi/config/fmwconfig/bienv/core

image
The following shows a example of the sqlnet.ora file:
image

And the following shows a example of the tnsnames.ora fiile:
image

Using above files the Oracle BI server should be able to connect to the database specified within the TNS Names file.

For the developer machine

The Oracle BI 12c Administration Tool (BI Developer Studio) requires the above (example) configuration files for sqlnet.ora and tnsnames.ora to be placed within the following directory of the client developer machine:
C:\Oracle\BIAdmin\domains\bi\config\fmwconfig\bienv\core

The TNS Name specified within the tnsnames.ora may then be used within the Connection Pool definition of the Oracle BI Metadata either by using the defined name or by using the fully qualified TNS Names entry. When refreshing the count of a database object such as a Table, the Oracle BI Server should then be able to retrieve the row count and display the row count within the Oracle BI Administration Tool:

image

In case of bug fixing, the log of the Oracle BI Administration Tool is located within the following path:
C:\Oracle\OracleBIClient\domains\bi\servers\obis1\logs

image