Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to query fusion tables in SQL developer

Accepted answer
2055
Views
10
Comments

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

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics Strategist

    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,

Answers