How to Connect Oracle to Excel – Stream Live Enterprise Database Data

CONNECTOR GUIDE

Oracle ➤ Microsoft Excel

Oracle

Query Streams

Microsoft Excel

No VPN Required

Live Data

Open Source

See everything Query Streams can do beyond this guide Get Started Free

Supports

+more

Live Data

Replace exports with on-demand SQL

Excel Sheets

BI & AI Analytics

Ask Nova, get SQL + charts

Meet Nova

Database REST API

One key per partner. No credentials shared.

Build an API

+more

Automation

Scheduled sync to 6+ platforms

Explore

+more

API to SQL

Query APIs with SQL, no code

Explore

+more

AI Database MCP

Claude, Cursor, ChatGPT & Grok talk to your data

Connect AI

Query Streams enables you to connect Oracle databases directly to Microsoft Excel, streaming live data without VPNs, firewall changes, or complex ODBC configuration. Sign up for free at QueryStreams.com and start pulling live Oracle data into your spreadsheets in minutes.

This guide shows you how to establish a secure, real-time connection between your Oracle database and Microsoft Excel. Whether you’re running on-premise Oracle, AWS RDS for Oracle, Azure Database for Oracle, or Google Cloud SQL, Query Streams provides a simple solution for building live dashboards, automating reporting, and securely sharing database queries with teams worldwide.

What You’ll Accomplish

By the end of this guide, you’ll be able to:

• Connect Excel to Oracle – On-premise, AWS RDS, Azure, or Google Cloud SQL
• Execute Oracle queries in real-time from Excel
• Build live dashboards and reports with auto-refreshing data
• Share secure database access with colleagues globally

Prerequisites

Step 1: Access the Query Streams Agent Interface

With your agent installed and running, configure your Oracle connection through the local agent interface.

1. Open your web browser and navigate to the agent interface: https://localhost:1823
2. Navigate to Data Connections: Click Data Sources in the sidebar, then select Connections
3. Add a new connection: Click the Add Connection button

Step 2: Select Oracle as Your Connection Type

1. Choose Oracle: Click on the Oracle tile (it will highlight with a green border when selected)
2. Alternative – Use search: Type “Oracle” in the search bar to quickly find it
3. Proceed to next step: Once selected, click Next

Step 3: Configure Your Oracle Connection Details

You’re now on Step 2: Configure Connection where you’ll enter your Oracle credentials.

Required Connection Details:

1. Connection Name (required) – A friendly name like “Production Oracle” or “AWS RDS Oracle”
2. Server (required) – Hostname or IP address. Examples: 192.168.1.100, mydb.us-east-1.rds.amazonaws.com, localhost
3. Port (required) – Default is 5432. Change only if using a custom port.
4. Database (required) – Specific database name (e.g., myapp, analytics)
5. Username (required) – Oracle database user
6. Password (required) – Database password (click eye icon to toggle visibility)
7. Connection Timeout – Default 30 seconds. Increase for slower networks.

Once all fields are completed, click Next to proceed.

Step 4: Select Your Data Realm

A Data Realm determines your query processing capacity – how much data can flow through your queries, measured in MB/GB based on your subscription.

1. Review available realms: You’ll see options based on your subscription tier
2. Select realm: Choose “Default Data Realm” for most use cases
3. Click Next to test the connection

Step 5: Test Your Database Connection

Query Streams will verify your Oracle is accessible with the credentials provided.

1. Automatic testing: The agent attempts to connect to your Oracle
2. Review results: Success shows server version, database name, and connection details
3. Click Next if successful

Step 6: Finish Setup

1. Review configuration: Verify all settings are correct
2. Click Finish to save your Oracle connection

Your Oracle connection is now ready! Next, you’ll install the Excel add-in to start querying.

Step 7: Install Add-In and Run Your First Query

Install the Query Streams add-in from Microsoft AppSource:

After installation, you can access the add-in from the Home ribbon tab in Excel.

1. Click “Stream a Query” to begin creating a new query
2. Select your Oracle connection from the Data Source dropdown
3. Choose the database from the Database dropdown
4. Write your Oracle query in the editor

SELECT 
    customer_id,
    first_name,
    last_name,
    email,
    country
FROM customers
WHERE country = 'USA'
ORDER BY last_name
LIMIT 100;

5. Configure destination: Choose “Create a new tab” for your first query
6. Click the Play button to execute the query

Next Steps: Save and Share Queries

Use the Query Streams web portal to build, save, and manage your Oracle queries:

• Save queries: Store frequently used SQL for easy reuse
• Add parameters: Create dynamic filters users can adjust without seeing SQL
• Share globally: Let colleagues run queries from anywhere in the world
• Access from add-in: Saved queries appear in the “Saved Queries” menu

Frequently Asked Questions

Related Guides