We don't have a tool to access the backend read-only. We should get a tool instead of using the BIP, where there are limitations on querying the number of reports. It would be good if Oracle could provide an easy-to-use read-only tool to access the database. Using the BIP model to run a query is time-consuming. Earlier, we used to have a Toad SQL developer. Whenever you run the BIP data model, you get only 100 to 200 records simultaneously, which you cannot extract without building a report. A flexible tool will help developers look at the data instead of going into BIP, building the report, having a layout, and then creating the report to extract your data.
We don't have a tool to access the backend read-only. We should get a tool instead of using the BIP, where there are limitations on querying the number of reports. It would be good if Oracle could provide an easy-to-use read-only tool to access the database. Using the BIP model to run a query is time-consuming. Earlier, we used to have a Toad SQL developer. Whenever you run the BIP data model, you get only 100 to 200 records simultaneously, which you cannot extract without building a report. A flexible tool will help developers look at the data instead of going into BIP, building the report, having a layout, and then creating the report to extract your data.
Depending on which variables are being used in the report, there can be issues related to security.
The GUI could use some improvement. The pricing can be reduced and some changes could be made to the interface.