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.

Advertisements

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.


Data source name: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID=orcl)))