🐨 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

• Professional SQL Editor - Monaco editor with IntelliSense and syntax highlighting
• Smart Data Discovery - Automatic table/view discovery with searchable explorer
• Multi-Tab Interface - Work on multiple queries simultaneously
• Instant Exports - CSV, Excel, JSON, and XML in one click
• Secure Connections - OAuth 2.0 and Basic Auth support
• Interactive Results - Sort, filter, and select data directly
• Bind Variables - Parameterized queries with interactive prompts

📦 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)
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.

🎯 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

🔐 Security & Compliance

✅ Read-Only Access - No data modification possible
✅ Encrypted Storage - Credentials stored securely in VS Code
✅ SQL Validation - Only SELECT statements allowed
✅ Enterprise Auth - OAuth 2.0 and SSO support

🌟 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

💰 Pricing

$19.99/year - Incredible value that pays for itself before your morning coffee break.

• ✅ Full-featured VS Code extension
• ✅ Regular updates and bug fixes
• ✅ Email support included
• ✅ 7-day money-back guarantee

Click the Manage License button in the extension to purchase and activate your license.

🆘 Support

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

📄 License

This extension requires a paid license.

• Trial: 7-day trial with full money-back guarantee if cancelled within 7 days
• License: Annual subscription at $19.99/year
• Refunds: Full refund if cancelled within 7 days of purchase

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