Why Oracle is not allowing to connect Oracle Fusion database using SQL Developer

Rajesh BR

Summary: Why Oracle is not allowing to connect Oracle Fusion database using SQL Developer similar to EBS database connection

Content (required): By Connecting using SQL Developer, we can directly utilize data as per need instead of creating additional layer for extraction.

Sahithi Kolasani-Oracle

Hi @Rajesh_BR

Please check the support id for this

How To Connect SQL Developer to a SaaS/Fusion Database (Doc ID 2556632.1)

Connecting to a database with SQL Developer requires the ability to use a SQL*Net connection. Since SaaS / Fusion does not allow this type of connection, it is not possible to connect with SQL Developer to a SaaS / Fusion database.

Instead, the recommendation is to use BI Publisher against the Fusion Applications Database:

Note 1910762.1 - Fusion Applications BI Publisher : How Can I Use BI Publisher to Run SQL Against the Fusion Applications Database ?

Also review

Note 2145444.1 - Oracle BI Publisher Best Practices for SaaS Environments (Doc ID 2145444.1)

If the SaaS / Fusion service has a corresponding Oracle Database Cloud Schema Service, it is possible to make connect to SQL Developer through this service using the Cloud connection. Please see this blog post by the SQL Developer Product Manager:

https://www.thatjeffsmith.com/archive/2015/01/uploading-data-to-oracle-schema-as-a-service-using-oracle-sql-developer/

Rajesh BR

Hi @Sahithi Kolasani-Oracle

Thanks for your response.

I am aware of SaaS / Fusion does not allow SQL *Net connection due to which we are unable to connect database with SQL Developer. My question is why Oracle is not allowing?

Mitchell R Eichblatt

I'd like to know the answer to Rajesh's follow-up question, and whether Oracle has any plans to correct this missing functionality.

I understand oracle provides BI Publisher and Fusion Data Intelligence to SaaS customers, however, basic ODBC functionality is an industry standard and opens up a lot of possibilities. While Oracle may offer a robust ecosystem, these solutions are not always going to be the ideal solution for every use case, which is why it provides value to the customer to provide options

Maruti Pratapa

Please check the Fusion DB connect.

https://www.youtube.com/watch?v=kA7e3RYyb98

Please check the above youtube link to go over the steps to connect to Fusion DB.

Maruti

Robb Penoyer

+1 on Www.fusion connect.com game changer

Sergey6885

Check https://krokozyab.github.io/ofjdbc/ its opensource and free