Oracle Communities

Oracle Analytics and AI

Child Item

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):

Find more posts tagged with

Core HR

Data Models

Accepted answers

Bhaskar Konar

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,

All comments

Bhaskar Konar

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,

maria.stanciu

Thank you for the answer. It was helpful.

Praveen Kumar Akkala-Oracle

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)

Robb Penoyer

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

User_993MK

Hi Robb - I tried Fusiondbconnect but it didnt work

User_EADEB

if you have trouble using Fusion DB Connect, reach out to support@fusiondbconnect.com. The really is fantastic!

User_EADEB

SarfarazSSK

Does anyone here know where to find list of tables for 'secured resource' and security objects like DSP, privileges?

User_5VV3R

DataFusing CloudSQL provides an SQL Developer like IDE for connecting to Oracle Fusion database.

Riyaz Ali-Oracle

Check Below with respect to tables & Secured Views:

PER_EMAIL_ADDRESSES

IRC_CANDIDATES

Fusion BI Publisher - Fusion Security in BI Publisher Data Models - Secured List Views SLV (Doc ID 2708546.1)