BI Connector for Oracle Fusion SQL Developers — VS Code Extension

Query Oracle Fusion data directly from Visual Studio Code.

BI Connector for VS Code brings your Oracle Fusion data pipelines, BI queries, and analytics workflows into the developer environment you already use every day. Write, run, version-control, and publish queries without ever leaving VS Code.

Note: A BI Connector subscription is required. A 14-day free trial license is available on first launch. Contact sales@biconnector.com for paid subscription.

Features

Connect to Oracle Fusion

Create and manage multiple Oracle Fusion connections from the VS Code sidebar. Supports SSO authentication. No need to open the BI Connector desktop application to manage connections.

Write and Run Queries

Open a query editor directly in VS Code. Run queries against your Oracle Fusion connections, view results in a data grid, and export results as CSV, all without leaving your editor.

Run Queries in the Background

Long-running queries can be dispatched as background jobs, freeing up your editor for other work. Monitor job progress from the extension panel.

Version Control for Queries

Save SQL files in your local workspace or repository. Commit, branch, and track changes to your queries using Git, just like any other source code. Pull existing queries from BI Connector desktop or a connected gateway into your local file system to start versioning them immediately.

AI-Assisted Query Generation (GitHub Copilot and Claude Code)

Oracle and Fusion developers who use GitHub Copilot, Claude Code, or other VS Code-integrated LLM tools can now use those agents to generate BI Connector queries. Point your AI assistant at your schema files, and let it draft queries that you can immediately run, verify, and publish. No Oracle SQL expertise required to get started.

Publish Queries and Tables

Publish queries from your local workspace directly to:

• BI Connector (as saved queries)
• BI Connector Gateway / Power BI Gateway (for Power BI and Fabric reports)
• Oracle Fusion Data Model (for use in Fusion reports and dashboards)

Enable Auto-Sync in settings so that every time you save a query file, it is automatically published to BI Connector, removing the manual publish step entirely.

Multi-Instance Support

Configure connections to any number of BI Connector instances. Each instance is identified by its URL and API key, and can be selected when publishing or syncing queries.

Requirements

• Visual Studio Code version 1.80.0 or higher
• BI Connector Desktop installed locally (the extension will prompt you to download it on first use if it is not detected)
• A valid BI Connector license (or a 14-day trial, activated automatically on first launch)
• Network access to your Oracle Fusion or Oracle Analytics environment

Getting Started

1. Install the Extension

Search for BI Connector in the VS Code Extensions Marketplace and click Install, or install directly from the .vsix file provided by your administrator.

2. Install BI Connector Desktop

If BI Connector Desktop is not already installed, the extension will detect this on first use and prompt you to download it. Follow the on-screen instructions to complete the installation.

3. Activate Your License

On first launch, a 14-day trial license is activated automatically. To use your existing subscription, open the extension settings and enter your license key.

4. Create a Connection

Click the BI Connector icon in the VS Code Activity Bar (left sidebar). Select Create Connection and fill in your Oracle Fusion or Oracle Analytics connection details, including the connection name, host URL, credentials, and SSO settings if applicable.

5. Write and Run Your First Query

Open a new .sql file or use the built-in query editor panel. Select your connection from the dropdown, write your query, and click Run. Results appear in the data panel below.

Extension Settings

Extension Views

Connections Panel

Lists all configured Oracle Fusion and Analytics connections. From here you can create, edit, and test connections, browse tables, columns, constraints, and indexes, and run ad-hoc queries.

Queries Panel

Displays queries saved to BI Connector. Pull existing queries from BI Connector Desktop or a connected gateway into your local file structure with a single click.

Background Jobs Panel

Tracks all queries running as background jobs. View status and download results when complete.

Common Workflows

AI Query Generation

(Use Claude Code or GitHub Copilot to Generate Queries)

1. Add a .claude or Copilot instructions file to your workspace. Include your schema CSV or reference files.
2. Instruct the agent: for example, "Read the schema in tables.csv and write a query to return unaccounted AP invoices. Save the output to fusion_queries/ap_unaccounted_invoices.sql."
3. Review the generated query in the editor.
4. Run it using your BI Connector connection to verify results.
5. Publish to BI Connector or Fusion as needed.

Query Versioning (Customer-managed)

This will be managed by customers from their own repository. The Git repository will manage query versioning, with internal branches/commits.

Pull Existing Queries from BI Connector

1. Open the Queries panel.
2. Select your BI Connector instance and the target folder path.
3. Click Pull. All queries from that folder are saved as local .sql files.
4. Commit the files to your Git repository.

Publish a Query to Server

Applicable to servers hosting the following apps with BI Connector: Power BI Gateway, Self-hosted Integration Runtime, and Tableau Server/Bridge.

1. Open the query file.
2. Right-click or use the Command Palette to select Publish as BI Connector Query.
3. Choose the target instance and folder.
4. Click Publish.

Publish a Query to Oracle Fusion Data Model

1. Open the query file.
2. Select Publish to Fusion Data Model from the Command Palette.
3. Enter the data model name, select the Fusion connection, and specify the folder path.
4. Click Publish.

Known Issues

• VS Code for the Web (vscode.dev) is not supported. The extension requires a local VS Code installation with BI Connector Desktop running on the same machine.

About BI Connector

BI Connector by Guidanz Inc. is the leading connectivity solution for Oracle Fusion and Oracle Analytics. It enables Power BI, Tableau, and other BI tools to connect securely to Oracle Fusion data, with support for Direct Query, live connections, and pre-built semantic layers.

Learn more at guidanz.com.

License

Use of this extension requires a valid BI Connector subscription. A 14-day free trial is available on first launch.

Terms of Service | Privacy Policy