The following is a step-by-step guide to determine the Connection string for Oracle Analytics Cloud and Oracle Database Cloud.
When logging into your Oracle Cloud Service using your identity Domain, a similar page is being displayed:
Click on the Action Menu of the Database Cloud Service and select “Open Service Console”.
This Page shows details about your Cloud Services such as OCPUs, Storage or Memory:
click on the Database Service Name to get to the Details Page:
This reveals the Public IP of the Oracle Cloud Database and the required Service Name.
Within the Oracle BI Administration Tool, the connection string needs to be created in the Data Source Name Field:
Using the following format:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PDB1.xxx.oraclecloud.xxx)))
After modelling the data and saving the .rpd file, the Model can be uploaded to the OAC Cloud: