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
3) click Download Wallet
which stores the .zip file to you local drive:
This .zip file can already be extracted, since the tnsnames.ora and the cwallet.sso file are needed for later steps:
Set Admin Password
If not already done navigate to the ADB Service Console
and click Administration and set the Admin password:
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:
click on Connections under Configuration and Administration
click on Upload wallet on the right Burger Menu:
This allows to upload the previously downloaded wallet from the hard drive (you may need to acknowledge a virus scan warning before):
After uploading the Wallet successfully a success message will be displayed:
After click the Burger Menu on the right again the button will now display “Replace Wallet” instead of “Upload Wallet”:
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.
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:
The Connection will be displayed in the list:
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:
click ADW from the available connection types:
specify the connection details and upload the extracted sso credential files from the wallet (cwallet.sso):
The connection will be displayed in the list of connections:
After the connection is established, a Data Set can be created using this Connection to ADW.