Oracle Fusion BIP VS Code Extension

Run Oracle Fusion BI Publisher SQL directly from VS Code with a workflow built for day-to-day query tasks.

Features

• Create and manage multiple Fusion BIP connections in one place.
• Quickly test and save working connections.
• Run selected SQL or full editor SQL without leaving VS Code.
• View results in a dedicated panel with paging controls.
• Export complete result sets to CSV or Excel.
• Stop running queries when needed.

What You Can Do

Manage Connections

• Add, edit, select, and delete connections from the Fusion BIP side panel.
• Keep one connection active while switching between environments as needed.

Run SQL Fast

• Execute highlighted SQL or the full SQL editor content.
• Launch queries from keyboard shortcut, context menu, editor action, or Command Palette.

Work with Results

• Browse result pages in the results panel.
• Change page size based on how much data you want to inspect at once.
• Export full results to CSV or Excel for sharing and analysis.

Requirements

• Oracle Fusion environment with BI Publisher access.
• Fusion URL, username, and password with query/report permissions.
• Network connectivity to the Fusion environment from your machine.

Quick Start

1. Open the Fusion BIP view in the Activity Bar.
2. Create a connection and test it.
3. Open SQL in the editor.
4. Run the query.
5. Review results and export when needed.