Feature Comparison
Koala Data Explorer offers both free and paid modes to suit different needs.Quick Comparison
| Feature | Free Mode | Paid Mode |
|---|---|---|
| Query Tabs | 1 | Unlimited |
| Max Rows | 50 (locked) | Unlimited |
| Authentication | Basic only | Basic, OAuth PKCE, Windows SSO |
| Data Sources Explorer | ❌ | ✅ |
| Excel Export | ❌ | ✅ |
| IntelliSense | ❌ | ✅ |
| Performance Monitor | ❌ | ✅ |
| SQL History | 50 entries | 500 entries |
| CSV/JSON Export | ✅ | ✅ |
| Query Execution | ✅ | ✅ |
| Grid Features | ✅ | ✅ |
Free Mode Features
What’s Included
Perfect for basic Oracle Fusion data queries: ✅ Core Functionality- Full SQL query editor
- Monaco-based editing with syntax highlighting
- Query execution with results grid
- Basic authentication (username/password)
- CSV export for spreadsheet analysis
- JSON export for programmatic use
- Copy to clipboard functionality
- 50 SQL history entries
- Bind variable support
- Error handling and messages
- Sort and filter results
Limitations
Free mode has these restrictions: ❌ Single Tab Only- Work with one query at a time
- No multi-tab workflows
- Maximum 50 rows per query
- Cannot be changed in settings
- Basic authentication only
- No OAuth PKCE or Windows SSO support
- No data sources explorer
- No Excel export
- No IntelliSense autocomplete
- No performance monitoring
Paid Mode Features
Unlimited Productivity
🚀 Multiple Query Tabs- Open unlimited query tabs
- Work on multiple queries simultaneously
- Compare results side-by-side
- Organize complex analysis workflows
Advanced Authentication
🔐 Enterprise Security- OAuth 2.0 PKCE: Secure token-based authentication with Oracle IAM
- Windows SSO: Simple SAML-based SSO integration with Oracle Fusion
- Session Management: Persistent secure sessions
- Multi-factor Authentication: Supported through enterprise SSO
Data Exploration
📊 Data Sources Explorer- Browse all available tables and views
- Search for specific objects
- View table structures
- Auto-refresh on connection
- Favorites for quick access
Enhanced Export Options
📁 Excel Export- Native .xlsx format
- Preserve formatting
- Multiple sheets support
- Large dataset handling
- Formula-safe export
Developer Productivity
⚡ IntelliSense Autocomplete- Table name suggestions
- Column name completion
- SQL keyword hints
- Function suggestions
- Context-aware recommendations
Performance Tools
📈 Performance Monitor- Query execution timing
- Resource usage metrics
- Performance history
- Optimization suggestions
- Bottleneck identification
Extended History
📝 SQL History (500 entries)- 10x more history than free mode
- Search through past queries
- Persistent across sessions
- Quick re-execution
- History management tools
Use Case Recommendations
When Free Mode is Sufficient
Perfect for:- ✅ Occasional data queries
- ✅ Simple troubleshooting
- ✅ Learning Oracle Fusion
- ✅ Basic reporting needs
- ✅ Personal use
- Students learning Oracle Fusion
- Occasional users checking data
- Basic support tasks
When to Upgrade to Paid
Essential for:- ✅ Daily Oracle Fusion work
- ✅ Complex data analysis
- ✅ Enterprise environments
- ✅ Team collaboration
- ✅ Production support
- Implementation consultants
- Business analysts
- Support teams
- Data migration specialists
- Report developers
ROI Calculator
Time Savings
Free Mode Workflow:- Open web portal: 2 minutes
- Navigate to BI: 1 minute
- Run query: 3 minutes
- Export data: 2 minutes
- Total: 8 minutes per query
- Already in VS Code: 0 minutes
- Run query with IntelliSense: 30 seconds
- Excel export: 10 seconds
- Total: 40 seconds per query
Monthly Impact
For a typical user running 10 queries per day:- Time saved: 70 minutes/day
- Monthly savings: 23 hours
- Annual savings: 280 hours (7 work weeks!)
Pricing
License Options
| Plan | Price | Duration | Best For |
|---|---|---|---|
| Annual | Contact Sales | 12 months | Teams & regular users |
| Trial | Free | Variable | Evaluation |
Volume Discounts
Available for:- 5+ licenses: 10% discount
- 10+ licenses: 15% discount
- 25+ licenses: 20% discount
- Enterprise: Custom pricing
Upgrade Process
How to Upgrade
- Open SQL Editor: Launch Koala Data Explorer
- Click License Button: Key icon in toolbar
- Choose Option:
- Start trial (if available)
- Enter license key
- Purchase license
- Activate: Follow prompts to activate
- Restart: Reload VS Code if prompted
Instant Activation
- ⚡ No reinstallation needed
- ⚡ Immediate feature unlock
- ⚡ Preserves all settings
- ⚡ Keeps connection data
License Management
Check License Status
- Open SQL Editor
- Look for license indicator:
- 🔓 Free Mode
- 🔑 Licensed Mode
- ⏰ Trial Mode
License Transfer
Licenses can be transferred:- Deactivate on old machine
- Activate on new machine
- Contact support for assistance
Team Licenses
For organizations:- Centralized license management
- Bulk activation codes
- Usage reporting
- Priority support
Frequently Asked Questions
Can I try before buying?
Yes! The extension includes free mode to test basic functionality. Trial licenses may be available in your region.What happens when license expires?
The extension reverts to free mode. All your data and settings are preserved.Can I upgrade mid-year?
Yes, licenses are pro-rated. You only pay for remaining months.Is the license per-user or per-machine?
Licenses are per-user. You can use on multiple machines you personally use.Do you offer educational discounts?
Yes, contact support or email support@btsscorp.com with your .edu email for special pricing.Making the Decision
Stay with Free Mode if:
- You query data occasionally
- 50 rows is sufficient
- You don’t need Excel export
- Single tab meets your needs
- Basic auth works for you
Upgrade to Paid Mode if:
- You work with Oracle Fusion daily
- You need unlimited data access
- Excel export saves you time
- SSO is required by your org
- Multiple tabs improve workflow
- IntelliSense speeds development
- Performance monitoring helps optimization
Support
Free Mode Support
- Documentation access
- Community resources
- Email support (best effort)
Paid Mode Support
- Priority email support
- 1-2 business day response
- Technical assistance
- License management help