Users with experience of using SQLConnect by BI Splash
Summary:
Users with experience of using SQLConnect by BI Splash
Content (please ensure you mask any confidential information):
We are reviewing the feasibility of granting our Report Developer to use external client software such as SQLConnect to Oracle Fusion. Our developers had signed up to use the 15 days trial and now wish to purchase the licences. https://sqlconnect.com/
The primary reason is to assist in writing adhoc custom SQL to aid in defect resolution or writing SQL statements which can then be used in BI data models to aid faster development.
I am aware that Oracle does not allow SQL Developer client to connect to Oracle Fusion as there is no access to the database using tnsnames and Oracle recommend that users should run SQL in a BI Publisher SQL Data Model then view the data (if less than 200 records) or to create a BI report to extract the data (if > 200 records).