> ## Documentation Index > Fetch the complete documentation index at: https://docs.btsscorp.com/llms.txt > Use this file to discover all available pages before exploring further. # Free vs Paid Features > Compare free and paid features of Koala Data Explorer ## 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) ✅ **Data Export** * CSV export for spreadsheet analysis * JSON export for programmatic use * Copy to clipboard functionality ✅ **Essential Tools** * 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 ❌ **Row Limit** * Maximum 50 rows per query * Cannot be changed in settings ❌ **No Advanced Auth** * Basic authentication only * No OAuth PKCE or Windows SSO support ❌ **No Premium Features** * 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 Example users: * 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 Example users: * 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** **Paid Mode Workflow**: * Already in VS Code: 0 minutes * Run query with IntelliSense: 30 seconds * Excel export: 10 seconds * **Total: 40 seconds per query** **Savings**: 7+ minutes 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 Contact [support](https://btsscorp.freshdesk.com/support/tickets/new) or email [support@btsscorp.com](mailto:support@btsscorp.com) for quotes. ## Upgrade Process ### How to Upgrade 1. **Open SQL Editor**: Launch Koala Data Explorer 2. **Click License Button**: Key icon in toolbar 3. **Choose Option**: * Start trial (if available) * Enter license key * Purchase license 4. **Activate**: Follow prompts to activate 5. **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 1. Open SQL Editor 2. Look for license indicator: * 🔓 Free Mode * 🔑 Licensed Mode * ⏰ Trial Mode ### License Transfer Licenses can be transferred: 1. Deactivate on old machine 2. Activate on new machine 3. 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 purchase a license at any time? Yes, you can purchase an annual license at any time. Your subscription begins on the purchase date and renews automatically on the same date next year. ### 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](https://btsscorp.freshdesk.com/support/tickets/new) or email [support@btsscorp.com](mailto: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 ## Next Steps Learn how to activate your license Install the extension Set up your connection Get a quote for your team