Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to query fusion tables in SQL developer
Summary:
We have a data model to select the email_address_id from fusion.PER_EMAIL_ADDRESSES but we want to be able to query this table or data from this table (or IRC_CANDIDATES table) in SQL developer . Is this possible?
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Best Answer
-
Hi @maria.stanciu,
It is not possible to connect Fusion Database with SQL Developer directly. Instead you have to use BI Publisher to query the Fusion Database.
Please find below a note from Oracle which might be useful for you.
Document 2556632.1 (oracle.com)
Hope this help.
Cheers,
1
Answers
-
Thank you for the answer. It was helpful.
1 -
You can use this doc on how to run the SQLs in Fusion BIP Data Model.
Fusion Applications BI Publisher : How Can I Use BI Publisher to Run SQL Against the Fusion Applications Database ? (Doc ID 1910762.1)
1 -
It is possible to do this. There is a tool in the market, Fusion DB Connect that lets you use SQL*Developer and query the Fusion Cloud database. https://www.fusiondbconnect.com
1 -
Hi Robb - I tried Fusiondbconnect but it didnt work
0 -
if you have trouble using Fusion DB Connect, reach out to support@fusiondbconnect.com. The really is fantastic!
0 -
0
-
Does anyone here know where to find list of tables for 'secured resource' and security objects like DSP, privileges?
0 -
DataFusing CloudSQL provides an SQL Developer like IDE for connecting to Oracle Fusion database.
0 -
Check Below with respect to tables & Secured Views:
Fusion BI Publisher - Fusion Security in BI Publisher Data Models - Secured List Views SLV (Doc ID 2708546.1)
1
