Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment
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
Comments
-
A tool like this will increase developer productivity.
Current way of working is to export all the data to another database and from there to use the SQL tooling to make custom BI reports.0 -
This would help us create queries way more easily and without errors. Current options are only to write in Notepad with no system help / validation whatsover.
Would prefer not only HCM but all of Oracle's suites to be added.
0 -
This Tool will help to increase the efficiency and we are also looking to have this Tool.
Thanks0 -
Very useful tool to write the queries.
0 -
Agreed, there are paid tools available however it would be nice to have a built-in Oracle solution
0 -
This would make custom reporting much easier
0 -
I would love to see this. Development using BI Publisher is simply painful
0 -
Thanks for the idea and your feedback! Product development is evaluating this request. SQL Connect https://oraclecloudtools.com/sql-connect/ is not an Oracle-certified tool. We don't advise customers using this tool.
Ling
0 -
I totally agree that the BI Publisher and Data Model current functionality is not very efficient.
I'd love to be able to use SQL Developer connected to the database (even just to read)Thanks!
0 -
I know that for some big customers they do arrange a Read Only SQL utility (something which requires security authentication and GoldenGate setups....).
Also, most probably Oracle Support team members has access to query directly.
0
