Data Flow Using Oracle Custom SQL instead of Analysis Subject Areas

Matthew Hoerman

Content

I am trying to build a data flow in Oracle Analytics Cloud. When I connect to our Salesforce for example, the Data Flow UI shows "Enter SQL" and allows for actual custom SQL queries referencing direct database tables. But when I connect with the "Oracle Applications" connector to our OTBI /analytics/ URL I use the only option in the UI is "Enter Logical SQL" or selecting Subject Areas which does not work for my needs, I need to enter direct physical SQL not Logical SQL.

How can I connect to Oracle Financials In The Cloud in OAC Data Flows to query using custom SQL not analyses? thanks!

Version

OAC 4, Financials In the Cloud R12

Christian Berg -Oracle

Hi Matthew,

In that case Financials doesn't count as an "application". Look at the GUI and what it shows as a sample URL. "application" means any Oracle analytics source.

https://imgur.com/Qa2S4OQ

Matthew Hoerman

Yes I see that in the example URL. When I do create custom SQL data models it's still using that /analytics/ address but "/analytics/saw.dll?bipublisherEntry" so I wasn't sure if that address worked for both types of query. If custom SQL doesn't count as an Application what does it count as? Which connector applies to that situation? thanks!

Mark_Daynes

Hi Matthew,

Subject area or Logical SQL I think are the only options for 'Applications'.

You can get SQL access to the Cloud ERP Database using BIP as part of OTBI and create extracts you can consume ... or use Data Sync ... or use the BICC .... and also 18.3.3 of OAC (aka OAC 5/September 2018 release) also has a replication wrapper around BICC that is brilliantly documented by the A-Team.

Mark

Christian Berg -Oracle

You can use the "Oracle Database" connector type.