🐨 Koala Data Explorer

Query Oracle Fusion Cloud data directly from VS Code

Boost your productivity with instant access to Oracle Fusion data. Whether you're troubleshooting issues, supporting business operations, validating data conversions, or building report queries - get the answers you need in seconds, right from VS Code.

⚡ Why Choose Koala?

Save Hours Every Week
Stop wasting time with slow web portals and complex interfaces. Connect instantly and query your Oracle Fusion data in seconds.

Stay in Your Flow
Write code, query data, export results - all without leaving VS Code. Perfect for developers, analysts, and consultants.

Enterprise Security
Read-only access ensures data safety. OAuth 2.0, encrypted storage, and enterprise-grade security built-in.

🚀 Key Features

• SQL editor: Monaco-based editing, syntax highlighting, quick execute
• Results: Sort/filter/select; CSV/JSON export; Excel export (paid)
• Connections: Basic (free); OAuth/PKCE and SSO - Windows only (paid)
• Data Sources: Searchable table/view explorer (paid)
• History: Recent query history; up to 50 in free mode
• Performance: In-editor performance monitor (paid)

📦 Getting Started

1. Install the extension from VS Code marketplace
2. Open SQL Editor - Use Command Palette: "Open Fusion SQL Query Editor"
3. Add Connection - Click the Manage Connections button in the top-left corner
4. Select Connection - Choose your connection from the dropdown in the query tab
5. Connect & Query - Click Connect button, then write and execute your SQL queries
6. Export Results - Click Export button to save in any format

🔧 Quick Setup

Set Up Your First Connection

1. Click "Manage Connections" button (top-left corner of SQL editor)
2. Click "Add Connection" in the dialog
3. Choose connection type:
   • Basic Auth - Username/password
   • OAuth PKCE - Enterprise SSO (recommended)
   • SSO - Windows only
4. Enter connection details and test
5. Save the connection

Connect and Query

1. Select your connection from the dropdown in any query tab
2. Click the "Connect" button
3. Wait for data sources to load in the sidebar
4. Write your query and press Ctrl+Enter (Cmd+Enter on Mac)

Your First Query

SELECT * FROM ap_invoices_all;

Press Ctrl+Enter (Cmd+Enter) to execute.

🆓 Free vs Paid

• Free mode (included)
  • 1 tab, Basic Auth only
  • 50 rows per query (Max Rows locked)
  • CSV/JSON export
  • SQL History up to 50
  • Data Sources, Excel export, Unlimited rows, Autocomplete, Performance Monitor, multi-tab: disabled
• Paid mode (license)
  • Unlocks Data Sources, Excel export, Unlimited rows, Autocomplete, multiple tabs, Performance Monitor, and OAuth/SSO connections

🎯 Perfect For

• Support Teams - Quickly troubleshoot user issues with real-time data access
• Implementation Consultants - Validate configurations and data conversions
• Business Analysts - Build and test report queries before deployment
• Developers - Debug integrations and verify data flows
• Data Migration Teams - Validate converted data and reconcile differences

🔐 Privacy & Security

• Read-only: the editor runs SELECT queries only
• Credentials stored via VS Code SecretStorage
• No telemetry collected by the extension
• OAuth 2.0/SSO supported (paid)

🌟 Customer Results

"Reduced data analysis time by 70%" - Fortune 500 Developer
"Essential tool for our Oracle Fusion team" - Global Consulting Firm
"Perfect for data validation during migration" - Healthcare Provider

⌨️ Essential Shortcuts

📋 System Requirements

• VS Code 1.74.0 or higher
• Network access to Oracle Fusion Cloud
• Valid Oracle Fusion credentials

🔑 Licensing & Trial

• Free mode is included (see Free vs Paid above)
• A paid annual license unlocks all features
• Start and manage from the “Manage License” (key) button in the editor
• Trial availability may vary by region/account

🆘 Support

• Email: support@btsscorp.com
• Response Time: Within 1-2 business days

📄 License

This extension includes a Free mode and supports a paid license to unlock all features.

See the LICENSE file for the commercial license terms.

⚠️ Disclaimer

This extension depends on Oracle Fusion Cloud web services. Availability and behavior of those services are controlled by Oracle and may change. Koala Data Explorer is not affiliated with or endorsed by Oracle; “Oracle” and related marks are trademarks of Oracle and/or its affiliates.

🧰 Logging & Diagnostics

To enable backend and webview logs for troubleshooting, see docs/LOGGING.md.

Ready to solve problems faster?
Install Koala Data Explorer and get instant insights into your Oracle Fusion data.