How to access PaaS table or external database through BI Publisher

Dileep Rai

We have a PaaS solution where we have created a custom screen and stored the data in the custom table(DBCS), and we have another DW system as well; we want to build a report in Oracle Fusion BIP and want to access the PaaS table as well external DW tables. How can we access these tables, and What is the best approach?

Sandeep S. Chauhan-Oracle

Hi Dileep, Oracle Analytics Publisher(earlier known as BI Publisher) in Oracle Fusion Apps Cloud is designed to access data from Fusion Apps transactional database.

JDBC/JNDI connections to external databases aren't supported.

Refer https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/data-source-connections.html