connect Smartview to OTBI

click on Panel icon of Smart View Ribbon:


click on Private Connection


click on Create new Connection at the bottom of the panel


choose Oracle BI EE as connection provider type:


Enter the following URL (no port information needed):



This will give access to the Reports saved in My or shared Folders:


To work with the established connection, it is posssible to directly drag content of a pre-built analysis to Excel or to Load the element of the Analysis into Designer View to edit the Analysis before dragging it into Excel. The Designer View can be opened from the bottom of the Panel:


Reports can then be opend in Excel:



OAC: specifying the Connection string within rpd model

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:







After modelling the data and saving the .rpd File, the Model can be uploaded to the OAC Cloud:


Accessing data in Oracle Fusion Applications Cloud for Analytics

The following diagram shows the high-level options to access data within Oracle Fusion Applications (FA) Cloud for Analytical purposes:

Please note: that this diagram is of April 2018 and may not apply in full in future.

For more details on how to connect to Oracle Fusion Applications (FA) Cloud using Visual Analyzer (VA) and DV Desktop (DVD), please reference the previous article.

The details for connecting to FA using ODI (with BI Applications) or BI Data-sync will be described in future articles.

Using the Oracle TNS Connection String in BI Administration Tool

Ideally the BI Administration Tool should be able to use the TNS Identifier (SID) to connect to the Oracle Database. E.g. with the default ORCL

However, sometimes (probably because of Environment Variable settings) t he BI Admin Tool doesn’t Accept the Oracle TNS Identifier (SID). To have a quick workaround it is also possible to paste the complete TNS Entry into the BI Administration Tool. This allows the BI Tool to make the proper connection to the Oracle Database.