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

Welcome!

It looks like you're new here. Sign in or register to get started.

Best Answer

  • Rank 8 - Analytics Strategist
    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,

Answers

  • Rank 3 - Community Apprentice

    Thank you for the answer. It was helpful.

  • Rank 6 - Analytics Lead

    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)

  • Rank 1 - Community Starter

    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

  • Rank 1 - Community Starter
    edited November 2024

    Hi Robb - I tried Fusiondbconnect but it didnt work

  • Rank 1 - Community Starter

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

  • Rank 1 - Community Starter
  • Rank 1 - Community Starter

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

  • Rank 1 - Community Starter

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

  • Rank 6 - Analytics Lead

    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)

Welcome!

It looks like you're new here. Sign in or register to get started.