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?

Cloud Based

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.

User Interface

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

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.

Use Anywhere

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.

Syntax Highlighting

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.

Release Comparison

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.

Oracle Apex

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.

Schema Browser

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.

Features

Link to Oracle Documentation

2 Phase Authentication

Tutorial Videos

Format Grid

Run from anywhere

Describe Tables & Views

Separates Fusion Versions

Familiar IDE – Monaco Editor

Use Cases

Development

Improved Productivity:

Patch Impact Analyst / Review schema differences
Freelance Consultants / Take Toolkit Anywhere
DBA / Transferable SQL skills to cloud
OTBI Report Developers / Verify SQL against DB
OTBI Report Design / Generate SQL for models

Developers can use sqlXtract to review changes to key tables columns and in conjunction with the release notes gain insight as to implementation and possible improvements to existing setup.

With schema browser click through to Oracle table and view documentation, code can be readily debugged and improved.

Support

Pre Release and Post upgrade testing can be supplemented with Patch Impact Analysis and a review of schema differences.

Support engineers can see the schema differences in columns which have been introduced during an upgrade, and can use Adhoc queries to verify and gain insight while resolving issues.

An example would be to use sqlXtract to verify backend profile data following an upgrade, facilitating speedy resolution and efficient Service Request processing with Oracle.

Migration

When migrating data the process of verification can be supplemented by queries against specific tables greatly improving the efficiency of verification.

Currently the migration consultant would need to request reports or design and release BI reports to make source to target comparison.

The flexibility and speed of having the ability to verify against the tables affected is a great asset to any migration specialist.