Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment

AshishERPCloud

Organization Name

Tesco

Description

Hi Experts,

 

I hope that most of you who have worked on an On-Premise system must be well versed with using SQL Developer to run/execute a query and get raw data.

 

But in Oracle HCM Cloud or rather Oracle ERP Cloud enviornment one had to use Oracle BI Data Model or OTBI SQL Option (now not supported from 19D)

 

So wondering won't it would be great to be able to connect to Oracle ERP Cloud database using SQL Developer. (could be a nice enhancement in product)

 

I do heard about some paid tools developed by some organization but still not sure will individuals / orgs pay for the tool on a per user per month

(Details about tools can be found here: https://oraclecloudtools.com/sql-connect/ )

 

I personally feel that the tool is good but only if free , else am happy to take the pain of creating Data Model to run my SQL).

 

What do you guys think, having a SQL developer like interface to execute queries in cloud helps and if it does shall it be paid or free (embedded within project or additional bolt on).

 

Would love to hear both the pros and cons for it.

 

Do let-me know your views?

Use Case and Business Need

Hi Experts,

 

I hope that most of you who have worked on an On-Premise system must be well versed with using SQL Developer to run/execute a query and get raw data.

 

But in Oracle HCM Cloud or rather Oracle ERP Cloud enviornment one had to use Oracle BI Data Model or OTBI SQL Option (now not supported from 19D)

 

So wondering won't it would be great to be able to connect to Oracle ERP Cloud database using SQL Developer. (could be a nice enhancement in product)

 

I do heard about some paid tools developed by some organization but still not sure will individuals / orgs pay for the tool on a per user per month

(Details about tools can be found here: https://oraclecloudtools.com/sql-connect/ )

 

I personally feel that the tool is good but only if free , else am happy to take the pain of creating Data Model to run my SQL).

 

What do you guys think, having a SQL developer like interface to execute queries in cloud helps and if it does shall it be paid or free (embedded within project or additional bolt on).

 

Would love to hear both the pros and cons for it.

 

Do let-me know your views?

More details

Hi Experts,

 

I hope that most of you who have worked on an On-Premise system must be well versed with using SQL Developer to run/execute a query and get raw data.

 

But in Oracle HCM Cloud or rather Oracle ERP Cloud enviornment one had to use Oracle BI Data Model or OTBI SQL Option (now not supported from 19D)

 

So wondering won't it would be great to be able to connect to Oracle ERP Cloud database using SQL Developer. (could be a nice enhancement in product)

 

I do heard about some paid tools developed by some organization but still not sure will individuals / orgs pay for the tool on a per user per month

(Details about tools can be found here: https://oraclecloudtools.com/sql-connect/ )

 

I personally feel that the tool is good but only if free , else am happy to take the pain of creating Data Model to run my SQL).

 

What do you guys think, having a SQL developer like interface to execute queries in cloud helps and if it does shall it be paid or free (embedded within project or additional bolt on).

 

Would love to hear both the pros and cons for it.

 

Do let-me know your views?

Original Idea Number: 4bd50672ab