nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Is it possible to create a data set using REST API as a data source in oracle fusion cloud?

Prakash B Roy

Please suggest solutions to set up an REST API as a data source for a data model in Oracle Fusion. instead of sql query as a data set we need to pull data from rest api data.

Find more posts tagged with

BI Publisher

BI Publisher Data Models

Accepted answers

All comments

Sumanth V -Oracle

@Prakash B Roy -

This community is dedicated to OAC/OAS BIP-related queries. From your description, it seems you might be seeking guidance on Oracle Fusion or the OTBI tool. Could you please confirm? Thanks!

Prakash B Roy

Hi @Sumanth V -Oracle ,

Our requirement related to BIP only, we need to make data set using rest API instead of SOAP.

MandeepGupta

Hi @Prakash B Roy ,

Looks like this is not supported. You can check the end points on below link:

REST API for Oracle BI Publisher - About the REST APIs

Thanks.

Prakash B Roy

Hi @MandeepGupta ,

The link provided is for BIP Report API, but as you stated create data model in BIP report using rest API is not available seems.

Thanks,

Prakash

MandeepGupta

Yes, it will be a good idea to create an idea in Idea lab in customer connect:

Oracle Transactional Business Intelligence Idea Lab — Oracle Analytics

Thanks.

Sure

Have you tried configuring Web Service or HTTP Data Source?

https://docs.oracle.com/middleware/1221/bip/BIPAD/data_sources.htm#websvc_ds

Mallikarjuna Kuppauru-Oracle

Hi @Prakash B Roy

Refer below MOS doc -

How to add custom/user defined REST based data sources to BI Publisher in Fusion Cloud ? (Doc ID 2436451.1)

Regards,

Arjun

MandeepGupta

Hi @Mallikarjuna Kuppauru-Oracle ,

The doc confirms that this is unsupported at the moment. Thanks for sharing the note id for reference.

Thanks.

MandeepGupta

Also, are you able to check the ER status or any ETA on the ER?

@Mallikarjuna Kuppauru-Oracle

Thanks.

Upcoming Event

Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion SCM Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…

Top Leaders