Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

ADFQuery generation from BI Server

Typically, Oracle BI Server generates the physical database SQL to fetch the data from the source database.

When the database is a ADF source.  It generates ADFQuery, instead of the database SQL.

An ADFQuery is a query request to get the data from ADF engine via the BI Broker.

It is protocol designed by Oracle BI platform to communicate the request between the BI server and the BI broker on the ADF server side.

ADFQuery is not a technology from ADF.  It is a BI technology.

We can see the generated ADFQuery in the NQ Query Log.  It is in the format of XML.

It starts with the <ADFQuery> and ends with </ADFQuery>

The information included in the ADFQuery block is just regular SQL

  • The column projection
  • The VO instances you would like to query the data from
  • The View Links to be uses to join the VO instances.
  • The filters to be applied

This is one of the technologies used in BI platform to enable the support of OTBI.

 

Advertisements

One Response to “ADFQuery generation from BI Server”

  1. […] 3. ADFQuery generation from BI Server […]

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s