Cloud Tool to Run SQL on Oracle Cloud ERP & HCM
“Superb tool for data model creation in OTBI, reduced effort by 70% for my AR Aging Reports!”
- “This tool enabled me to better interact with Oracle Support and rapidly respond to user issues”
- “Using schema release comparison gave me insight in preparing for new releases and bug fixing”
What is sqlXtract?
sqlXtract allows users to connect to Fusion Cloud Applications and query the database using sql. Built on the Cloud using Oracle technologies, using a modern architecture, sqlXtract is fast, secure and built on Oracle for use with Oracle SaaS Fusion.
The User Interface is modeled on familiar tools to developers, with the Monaco text editor, offering a seamless experience and an easy fit into the OTBI report development lifecycle. sqlXtract allows each ERP/HCM connection to use a different colour theme. Quickly highlighting to the user through the use of colour, to which ERP/HCM instance they are connected.
Feature rich with user options to control data presentation, allowing sorting, single record views, exports to MS excel and control over formatting. Options for Date and Time presentation such as DD-MM-YY hh:mm-ss are available to facilitate analysis.
sqlXtract is modelled to be used from anywhere and offers execution history and save functionality so that valuable sql statements can be retained and are available wherever you are and for any environment need to connect to. No Data is stored in the system while saved sql can be inserted into the text editor easily, as the query is refined.
The syntax highlighting & line numbering make the query readable and the availability of themes enables the developer to select what works for them. During sql refinements, the short cuts to execute selected or the code on the current line, are available to add speed to process.
Testers and Support analysts can compare schemas between Fusion Releases. This can be used to preempt impacts and support issues arising from changes made to the database as part of updates.
Because sqlXtract is built on the Oracle Apex platform it has a coherent and feature rich UI. All secured under the Apex Security model, supplemented with 2 factor authentications.
Incorporating a schema browser offers the developer to describe the objects to verify field names and easily link to the Oracle source documentation at the click of a button for the selected database table or view.
SAAS Fusion Versions
The SaaS Fusion version is understood by sqlXtract and changes to tables and views from version to version can be identified. This feature enables a developer to quickly identify issues that are introduced to OTBI reports by the Oracle update, as well as being able to identify all changes to facilitate improvements to existing reports.
Professional - Single seat subscriber with trial period
- 2 ERP/HCM Instances
- Transition to Professional after 5 days
Professional - multiple seats purchased under single subscription
- 2 ERP/HCM Instances
- Multiple Seat Purchase
Enterprise - single or multiple seats with unlimited Instances
- Unlimited ERP/HCM Instances
- Volume Discounts Available
Enterprise License Discount
sqlXtract can be bulk purchased and the associated users allocated to your teams.
Manage your account
Existing customers can: manage their account from the Subscribe Page
Existing users can log on from here www.sqlXtract.com