Features

​

Core Features

​

SQL Query Editor

• Syntax Highlighting: Full SQL syntax highlighting for better readability
• IntelliSense (Paid): Auto-completion for tables, columns, and SQL keywords
• Quick Execute: Run queries with Ctrl+Enter (Windows/Linux) or Cmd+Enter (Mac)
• Multi-tab Support (Paid): Work with multiple queries simultaneously
• Save Queries: Persist your queries for later use

​

Query Execution

• Bind Variables: Support for parameterized queries
• Performance Monitoring (Paid): Track query execution time and performance metrics
• Row Limits: Configurable maximum rows (50 in free mode, unlimited in paid)
• Timeout Settings: Configurable request timeouts for long-running queries
• Error Handling: Detailed error messages with SOAP fault parsing

​

Results Management

• Grid View: Professional data grid powered by AG-Grid
• Sorting & Filtering: Sort and filter results without re-querying
• Column Selection: Choose which columns to display
• Cell Selection: Select and copy individual cells or ranges
• Virtual Scrolling: Handle large datasets efficiently

​

Data Export

• CSV Export: Standard comma-separated values format
• JSON Export: Structured JSON for programmatic use
• Excel Export (Paid): Native Excel format with formatting preserved
• Clipboard Copy: Copy selected data to clipboard

​

Connection Management

​

Authentication Methods

• Basic Authentication: Username and password (Free)
• OAuth 2.0 PKCE (Paid): Secure OAuth with Proof Key for Code Exchange
• Windows SSO (Paid): Simple SAML-based SSO integration with Oracle Fusion
• Enterprise SSO Support: Integration with identity providers

​

Connection Features

• Multiple Connections: Manage multiple Oracle Fusion environments
• Secure Storage: Credentials stored using VS Code’s SecretStorage API
• Connection Testing: Validate connections before saving
• Quick Switch: Easily switch between different connections

​

Data Exploration

​

Data Sources Explorer (Paid)

• Searchable Catalog: Find tables and views quickly
• Schema Information: View table structures and relationships
• Auto-refresh: Automatically load data sources on connection
• Favorites: Mark frequently used tables for quick access

​

SQL History

• Recent Queries: Access your recently executed queries
• Search History: Find previous queries by content
• History Limits: 50 entries (Free), 500 entries (Paid)
• Persistent Storage: History preserved across sessions

​

Advanced Features

​

Performance Monitor (Paid)

• Execution Timing: Track query execution time
• Performance Metrics: View detailed performance statistics
• Historical Tracking: Monitor performance trends over time
• Optimization Hints: Suggestions for query optimization

​

BIP Integration

• Report Execution: Run BIP reports directly from VS Code
• Scheduled Reports: Support for large dataset processing
• CSV Processing: Advanced CSV parsing and handling
• Catalog Deployment: Deploy BIP catalogs

​

Configuration Options

​

Extension Settings

{
  "koalaDataExplorer.timeout": 120000,
  "koalaDataExplorer.maxRows": 1000,
  "koalaDataExplorer.autoRefreshDataSources": true,
  "koalaDataExplorer.logging.enabled": false,
  "koalaDataExplorer.logging.level": "INFO"
}

​

Logging & Diagnostics

• Debug Logging: Configurable logging levels
• Log Viewer: Built-in log viewing panel
• Performance Logs: Track performance issues
• Secure Logging: Sensitive data redaction

​

Security Features

​

Data Protection

• Read-Only Access: Only SELECT queries are allowed
• Encrypted Storage: Credentials encrypted at rest
• Session Management: Secure session handling
• No Telemetry: No usage data collected

​

Enterprise Compliance

• OAuth 2.0: Industry-standard authentication
• SSO Support: Integration with enterprise identity providers
• Audit Trail: Query history for compliance tracking
• Secure Communication: HTTPS-only connections

​

User Experience

​

Interface Design

• Intuitive Layout: Clean, professional interface
• Dark Theme Support: Follows VS Code theme preferences
• Responsive Design: Adapts to different window sizes
• Keyboard Shortcuts: Comprehensive keyboard navigation

​

Productivity Features

• Quick Actions: Common tasks accessible via buttons
• Context Menus: Right-click actions for efficiency
• Status Bar: Real-time connection and query status
• Progress Indicators: Visual feedback for long operations

​

Feature Comparison

​

Coming Soon

• Query templates and snippets
• Advanced query builder UI
• Data visualization charts
• Query sharing and collaboration
• Custom keyboard shortcuts
• Extended Oracle dialect support

​

Next Steps