SQL Workspace
SQL Direct for Oracle.
A dedicated Windows workspace for running queries through Oracle BI Publisher, reviewing usable results, and exporting the data your team needs.
record_status
FROM your_oracle_view;– Run through BI Publisher
Your SQL workspace, connected through Oracle BI Publisher.
Keep the environment in view
Save connection profiles and select the Oracle instance for your work.
Work with usable results
Review output in a grid, sort columns, and export the data you need.
Return to previous runs
Review SQL, timing, status, and retained output in instance run history.
BUILT FOR EVERYDAY QUERY WORK
A dedicated workspace for Oracle analysis.
Move from a SQL question to a shareable result in one desktop application. Multiple query tabs help you organize related work while the environment selector makes the execution context visible.
SQL formatting and validation assistance support authoring. The results grid supports review without requiring an export for every question.
How a query becomes a result
- Select an environment: Choose a saved connection and BI Publisher data source.
- Prepare the SQL: Open a worksheet, write your query, and review validation feedback.
- Execute through BI Publisher: The application uses the configured Oracle service connection.
- Review and export: Inspect the result grid or export CSV, Excel, text, or PDF.
ONE APPLICATION, A CONNECTED WORKFLOW
The tools around the query matter too.
SQL worksheets
Use multiple editor tabs, save SQL files, format statements, and access table and column suggestions.
Results and visualizations
Inspect grid output, resize columns, and open visualization options from the result context menu.
BI Publisher catalog
Browse accessible catalog folders and copy report or data model paths for your work.
Run history
Filter executions by date and review SQL, elapsed time, errors, and retained results.
Scheduled output
Configure query schedules and output delivery to a local folder, email, or SFTP.
Administrator diagnostics
Review service calls and elapsed time through restricted SOAP and REST monitoring tools.
A WORKSPACE THAT FITS YOUR TEAM
Personal settings.
Practical controls.
Choose themes and fonts, configure result limits, and adjust visible workspaces. Set a retention period for saved query output.
Windows credential protection supports local storage. Administrator access separates diagnostics from everyday query work.
For the people behind Oracle reporting
Reporting analysts and BI Publisher developers
Implementation consultants
Oracle technology and production support teams
Finance, operations, and enterprise reporting teams
Requires an Oracle Fusion environment with suitable BI Publisher permissions. Oracle limits apply to report execution and output. Local query schedules run while SQL Direct is open.
LET’S TALK ABOUT YOUR QUERY WORKFLOW
See CBC SQL Direct in action.
Talk with CBC about your Oracle environments, reporting needs, and licensing.