Categories
- All Categories
- 76 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- 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):
Answers
-
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 -
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
