Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 82 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
SHENBAGARAJAN RAJENDRAN
Rank 1 - Community Starter
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.
0
Best 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, OLAPFusion Applications BI Publisher: External data sources are not supported (Doc ID 2003782.1)
Regards,
Arjun
0
