How to create a direct database query with OTBI?

Within Oracle Fusion OTBI go to New > Analysis and click on Create Direct Database Query:

image

specify the connection Pool information within the editor:

image

The following connection pools can be entered:

  • HCM – ”HCM_OLTP”.”Connection Pool”
  • CRM – “CRM_OLTP”.”Connection Pool”
  • FIN and PROC – “FSCM_OLTP”.”Connection Pool”

Please note: when copying&pasting the connection pool names from WordPress, there may be an issue with the double quotes(“) and you may need to re-type the double quotes (“) within OTBI.

After that, a query may be entered for direct database execution on the Oracle Fusion Cloud (bundled) Database (identified by the Connection pool supplied before):

image

For a listing of all Physical Tables please refer to (only available for HCM): https://cloudcustomerconnect.oracle.com/posts/ac54c31fcf

This contains a Excel mapping with the Physical OTBI Tables:

image

 

For a full support note, please refer to:

For a similar approach using BI Publisher please check:

To check the general TechNote for OTBI and Fusion HCM, please refer to:

1 thought on “How to create a direct database query with OTBI?

  1. When copying & pasting the Connection Pool from WordPress to BICS, the double quotes might not be correct. You may need to replace with a manual entering of the double quote ” from the keyboard..

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.