nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

create analysis from direct db query

new.bi

Summary

how to created direct db query

Content

Is there a way to create an analysis from direct database query. I tried the option but cannot get it to work. is there any additional set that is required for this? please advise.

direct db.png

Find more posts tagged with

Comments

Ramesh Nakka

Hi,

We can create the report in OBIEE by using advanced SQL..

New - Analysis- Create Analysis from simple logical SQL

You can click on Advanced tab and can create your own custom Query.

Regards,

Ramesh

User_AEMC1

Please update the required setup for the above question.

Vijaya Kumar-70229

Hi ,

You can create direct db query by using Data model and create a report.

New >> Data Model

Regards,

Vijay S

Vijaya Kumar-70229

Hi ,

PFA , This is the way to create direct db query.

Regards,

Vijay S

Nick Grobel

Not sure of the setup required for permission but a big hurdle to overcome is understanding the delivered connection pool names in order to access the data. I am by no means an expert, but the following connection pool names work in my testing environment

CRM DATA: "CRM_OLTP"."CONNECTION POOL"

HCM DATA: "HCM_OLTP"."CONNECTION POOL"

FSCM DATA: "FSCM_OLTP"."CONNECTION POOL"

Ashish Shah-Oracle

Hi All,

Please refer below idea before putting in efforts into this.

https://cloudcustomerconnect.oracle.com/posts/51c4d1c58e

Regards,

Ashish

Jason McWatts-22341

Have just upvoted your idea. We are being told DDB queries are being deprecated at some point during the R13 cycle which is very disappointing news as we were looking to make a lot of use of this functionality.

Jason

Nick Grobel

Can confirm. This functionality is already removed from all of my pods. Unfortunate. Have up voted your Idea as well.

Nick Grobel

Can confirm. This functionality is already removed from all of my pods. Unfortunate. Have up voted your Idea as well.

New Announcements

Upcoming Events

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Oracle AI Data Platform Hackathon at Oracle AI World 2026
Oracle AI Data Platform Hackathon at Oracle AI World 2026 Sunday, October 25, 2026 12:00–5:00 p.m. PT Request your spot at the AI Data Platform Hackathon Join us in person for the Oracle AI Data Platform Hackathon on Sunday, October 25, from 12:00–5:00 p.m. PT in Las Vegas at Oracle AI World. Lunch will be provided.…
Oracle AI Data Platform Customer Advisory Council at AI World 2026
Oracle AI Data Platform team will host an in-person Customer Advisory Council for AIDP customers attending Oracle AI World 2026 on October 26, from 1–3 PM PT. Join Oracle AI Data Platform executive leaders and selected customers for interactive discussions on our product roadmap, priorities, and future direction. Share…