Oracle Analytics Publisher Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forum› Oracle Analytics Publisher Forum

Categories

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

How to enable the MDS repository Schema/tables as a new Data Source in Oracle Fusion BIP

Accepted answer
22
Views
1
Comments
SHENBAGARAJAN RAJENDRAN
SHENBAGARAJAN RAJENDRAN Rank 1 - Community Starter
in Oracle Analytics Publisher Forum

I want to create a BIP Report to get the list of customizations deployed in the Oracle Fusion instance.

SQL Query for the data model is below. But I need MDS Repository as data source to create the data model. When I try to create the new data source using JDBC, add data source is disabled in the Oracle demo instance.

SELECT
DOCID,
DOCUMENT_NAME,
CUSTOMIZATION_ID,
DOCUMENT_CONTENT,
LASTUPDATED
FROM
MDS.MDS_DOCUMENTS
WHERE
CUSTOMIZATION_ID IS NOT NULL

Could you help.

BIP - MDS Dat Source 01.jpg

Best Answer

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics & AI Strategist
    Answer ✓

    Hi @User_ZKRCM

    This is an Expected behavior . You can refer below -

    In SaaS (cloud) environments, the follow are disabled and cannot be enabled
    JDBC, File, LDAP, OLAP

    Fusion Applications BI Publisher: External data sources are not supported (Doc ID 2003782.1)

    Regards,

    Arjun