> ## 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.

# Introduction

> Professional SQL tool for Oracle Fusion Cloud

## What is Koala Data Explorer?

Koala Data Explorer is a powerful VS Code extension that enables you to query Oracle Fusion Cloud data directly from your development environment. Built for developers, analysts, and consultants who work with Oracle Fusion, it provides instant access to your enterprise data without the need to navigate slow web portals or complex interfaces.

## Why Koala Data Explorer?

### Save Time

Stop wasting hours navigating through Oracle's web interfaces. Connect instantly and query your data in seconds, not minutes.

### Stay in Your Flow

Write code, query data, export results - all without leaving VS Code. Perfect for developers who need to validate data while coding.

### Enterprise-Ready

Built with security in mind, featuring read-only access, OAuth 2.0 authentication, encrypted credential storage, and enterprise-grade security.

## Key Benefits

<CardGroup cols={2}>
  <Card title="Instant Access" icon="bolt">
    Connect to Oracle Fusion Cloud and start querying data within seconds
  </Card>

  <Card title="Professional SQL Editor" icon="code">
    Monaco-based editor with syntax highlighting, IntelliSense, and quick execute
  </Card>

  <Card title="Powerful Results" icon="table">
    Sort, filter, and export data in multiple formats including Excel
  </Card>

  <Card title="Enterprise Security" icon="shield">
    OAuth 2.0, SSO support, and encrypted credential storage
  </Card>
</CardGroup>

## Who Uses Koala?

### Support Teams

Quickly troubleshoot user issues with real-time data access. No more waiting for data extracts or navigating slow portals.

### Implementation Consultants

Validate configurations and data conversions during Oracle Fusion implementations.

### Business Analysts

Build and test report queries before deployment to production.

### Developers

Debug integrations, verify data flows, and validate API responses against actual data.

### Data Migration Teams

Validate converted data and reconcile differences during migration projects.

## Free vs Paid Features

Koala Data Explorer includes a free mode with essential features, and offers a paid license for advanced capabilities:

### Free Mode

* Single query tab
* Basic authentication
* 50 rows per query limit
* CSV/JSON export
* SQL History (up to 50 entries)

### Paid Mode

* Unlimited query tabs
* OAuth PKCE and Windows SSO authentication
* Unlimited rows
* Excel export
* Data sources explorer
* IntelliSense autocomplete
* Performance monitor
* Extended SQL history (500 entries)

## Getting Started

Ready to boost your productivity? Here's how to get started:

1. [Install the extension](/koala/installation/vscode-marketplace) from the VS Code marketplace
2. [Set up your first connection](/koala/installation/first-connection) to Oracle Fusion Cloud
3. [Start querying](/koala/editor/writing-queries) your data immediately

<Tip>
  Want early access to new features? Try our [pre-release versions](/koala/installation/pre-release) and help shape development with your feedback.
</Tip>

<Note>
  The extension is designed for read-only access to ensure data safety. It only executes SELECT queries and cannot modify any data in your Oracle Fusion instance.
</Note>

## System Requirements

* **VS Code**: Version 1.74.0 or higher
* **Network**: Access to Oracle Fusion Cloud
* **Credentials**: Valid Oracle Fusion user credentials

## Support

Need help? The BTSS team is here to support you:

* **Support Portal**: [Submit a ticket](https://btsscorp.freshdesk.com/support/tickets/new) (recommended)
* **Email**: [support@btsscorp.com](mailto:support@btsscorp.com) (alternative contact)
* **Response Time**: Within 1-2 business days
* **Documentation**: Comprehensive guides and troubleshooting

## Next Steps

<CardGroup cols={2}>
  <Card title="Installation Guide" icon="download" href="/koala/installation/vscode-marketplace">
    Learn how to install Koala Data Explorer
  </Card>

  <Card title="Features Overview" icon="sparkles" href="/koala/features">
    Explore all available features
  </Card>

  <Card title="Quick Start" icon="rocket" href="/koala/installation/first-connection">
    Set up your first connection
  </Card>

  <Card title="User Guide" icon="book" href="/koala/editor/writing-queries">
    Start writing queries
  </Card>
</CardGroup>
