We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Flow Using Oracle Custom SQL instead of Analysis Subject Areas

Received Response
edited Sep 11, 2019 5:22AM in Oracle Analytics 4 comments


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!

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!