# BTSS Documentation ## Docs - [Introduction](https://docs.btsscorp.com/koala/introduction.md): Professional SQL tool for Oracle Fusion Cloud - [Features](https://docs.btsscorp.com/koala/features.md): Comprehensive overview of Koala Data Explorer capabilities - [System Requirements](https://docs.btsscorp.com/koala/requirements.md): Prerequisites and system requirements for Koala Data Explorer - [VS Code Marketplace Installation](https://docs.btsscorp.com/koala/installation/vscode-marketplace.md): Install Koala Data Explorer from the VS Code Marketplace - [Manual Installation](https://docs.btsscorp.com/koala/installation/manual-install.md): Install Koala Data Explorer from a VSIX file - [Pre-Release Versions](https://docs.btsscorp.com/koala/installation/pre-release.md): Try new features early with pre-release versions - [First Connection Setup](https://docs.btsscorp.com/koala/installation/first-connection.md): Set up your first connection to Oracle Fusion Cloud - [Activity Bar](https://docs.btsscorp.com/koala/installation/activity-bar.md): Access Koala Data Explorer from the VS Code Activity Bar - [Basic Authentication](https://docs.btsscorp.com/koala/connections/basic-auth.md): Connect to Oracle Fusion Cloud using username and password - [OAuth PKCE Authentication](https://docs.btsscorp.com/koala/connections/oauth-sso.md): Enterprise authentication with OAuth 2.0 PKCE for Oracle Fusion Cloud - [SSO Authentication (Windows)](https://docs.btsscorp.com/koala/connections/windows-sso.md): Simple Single Sign-On integration with Oracle Fusion Cloud SSO - [Managing Connections](https://docs.btsscorp.com/koala/connections/managing-connections.md): Create, edit, and switch between Oracle Fusion connections - [Interface Guide](https://docs.btsscorp.com/koala/editor/interface-guide.md): Complete guide to Koala Data Explorer's user interface elements and buttons - [Writing Queries](https://docs.btsscorp.com/koala/editor/writing-queries.md): Master the SQL query editor and write efficient Oracle Fusion queries - [Executing Queries](https://docs.btsscorp.com/koala/editor/executing-queries.md): Execute SQL with per-tab isolation, background execution, and instant cancellation in Koala Data Explorer. - [Large SQL Queries](https://docs.btsscorp.com/koala/editor/large-sql.md): Execute large SQL statements with compression and chunking - [Keyboard Shortcuts](https://docs.btsscorp.com/koala/editor/keyboard-shortcuts.md): Essential keyboard shortcuts for efficient query development - [Bind Variables](https://docs.btsscorp.com/koala/editor/bind-variables.md): Use parameters and bind variables for dynamic, reusable queries - [Viewing Data](https://docs.btsscorp.com/koala/results/viewing-data.md): Navigate and explore query results in Koala Data Explorer - [Sorting & Filtering](https://docs.btsscorp.com/koala/results/sorting-filtering.md): Sort and filter query results to analyze your data effectively - [In-Grid Search](https://docs.btsscorp.com/koala/results/in-grid-search.md): Search results with Ctrl/Cmd + F and jump through matches instantly. - [Exporting Data](https://docs.btsscorp.com/koala/results/exporting-data.md): Export query results to CSV, JSON, and Excel formats - [Excel Export](https://docs.btsscorp.com/koala/results/excel-export.md): Export query results to Excel format with professional formatting - [Data Sources](https://docs.btsscorp.com/koala/advanced/data-sources.md): Explore Oracle Fusion Cloud data sources and schemas - [SQL History](https://docs.btsscorp.com/koala/advanced/sql-history.md): Track and reuse your query history in Koala Data Explorer - [Performance Monitor](https://docs.btsscorp.com/koala/advanced/performance-monitor.md): Monitor query execution performance and timing - [Multiple Tabs](https://docs.btsscorp.com/koala/advanced/multiple-tabs.md): Work with multiple query tabs for efficient development - [Auto-Deployment](https://docs.btsscorp.com/koala/advanced/auto-deployment.md): Learn how Koala's hash-based deployment verifies and deploys BIP catalog artifacts to Oracle Fusion Cloud. - [Extension Settings](https://docs.btsscorp.com/koala/config/extension-settings.md): Configure Koala Data Explorer to match your workflow - [Timeout Settings](https://docs.btsscorp.com/koala/config/timeout-settings.md): Configure query timeout and connection settings - [Logging & Diagnostics](https://docs.btsscorp.com/koala/config/logging.md): Enable diagnostic logging for troubleshooting and support - [Performance Settings](https://docs.btsscorp.com/koala/config/performance.md): Tune Koala for faster query execution and efficient resource use - [Free vs Paid Features](https://docs.btsscorp.com/koala/licensing/free-vs-paid.md): Compare free and paid features of Koala Data Explorer - [Activating License](https://docs.btsscorp.com/koala/licensing/activating-license.md): How to activate your Koala Data Explorer license after purchase - [Managing License](https://docs.btsscorp.com/koala/licensing/managing-license.md): Manage your Koala Data Explorer license, subscription, and billing - [Refund Policy](https://docs.btsscorp.com/koala/licensing/refund-policy.md): 7-day free trial and refund terms for Koala Data Explorer - [Connection Issues](https://docs.btsscorp.com/koala/troubleshooting/connection-issues.md): Troubleshoot Oracle Fusion Cloud connection problems - [Query Errors](https://docs.btsscorp.com/koala/troubleshooting/query-errors.md): Troubleshoot SQL query execution errors and issues - [Performance Issues](https://docs.btsscorp.com/koala/troubleshooting/performance-issues.md): Diagnose and resolve performance problems in Koala Data Explorer - [Deployment Issues](https://docs.btsscorp.com/koala/troubleshooting/deployment-issues.md): Resolve auto-deployment and hash verification problems - [SQL Validation](https://docs.btsscorp.com/koala/troubleshooting/sql-validation.md): Understand Koala's validation rules and fix common errors - [Getting help](https://docs.btsscorp.com/koala/support/getting-help.md): Support channels for Koala Data Explorer - [Introduction](https://docs.btsscorp.com/kdes/introduction.md): Professional native SQL tool for Oracle Fusion Cloud - [KDEE vs. KDES](https://docs.btsscorp.com/kdes/differentiators.md): Two ways to use Koala, one feature set - [System Requirements](https://docs.btsscorp.com/kdes/installation/prerequisites.md): What end users need before installing Koala Studio - [Account Access](https://docs.btsscorp.com/kdes/installation/account-access.md): Create or recover your Koala account for Studio - [Download & Install](https://docs.btsscorp.com/kdes/installation/download-install.md): How to install Koala Data Explorer Studio on your machine - [First Connection](https://docs.btsscorp.com/kdes/installation/first-connection.md): Create your first Oracle connection inside Koala Studio - [Basic Authentication](https://docs.btsscorp.com/kdes/connections/basic-auth.md): Sign in with Oracle username and password - [OAuth PKCE Authentication](https://docs.btsscorp.com/kdes/connections/oauth-pkce.md): Use OAuth 2.0 with Proof Key for Code Exchange - [Windows SSO Authentication](https://docs.btsscorp.com/kdes/connections/windows-sso.md): Authenticate with your Windows credentials via WebView2 - [Managing Connections](https://docs.btsscorp.com/kdes/connections/managing-connections.md): Organize, edit, export, and import your Koala Studio connections - [Interface Guide](https://docs.btsscorp.com/kdes/query-editor/interface-guide.md): Tour the Koala Studio editor layout - [Writing Queries](https://docs.btsscorp.com/kdes/query-editor/writing-queries.md): Compose SQL efficiently in Koala Studio - [Executing Queries](https://docs.btsscorp.com/kdes/query-editor/executing-queries.md): Run SQL safely and understand what executes - [Large SQL Queries](https://docs.btsscorp.com/kdes/query-editor/large-sql.md): Handle big scripts and result sets with confidence - [Keyboard Shortcuts](https://docs.btsscorp.com/kdes/query-editor/keyboard-shortcuts.md): Native shortcuts available in Koala Studio - [Bind Variables](https://docs.btsscorp.com/kdes/query-editor/bind-variables.md): Use bind variables in Koala Studio queries - [Viewing Data](https://docs.btsscorp.com/kdes/results/viewing-data.md): Navigate result sets in Koala Studio - [Sorting & Filtering](https://docs.btsscorp.com/kdes/results/sorting-filtering.md): Interact with result grids without rerunning queries - [In-Grid Search](https://docs.btsscorp.com/kdes/results/in-grid-search.md): Quickly find values within the current result page - [Exporting Data](https://docs.btsscorp.com/kdes/results/exporting-data.md): Download query results as CSV or JSON - [Excel Export](https://docs.btsscorp.com/kdes/results/excel-export.md): Generate native Excel files directly from Koala Studio - [Data Sources Explorer](https://docs.btsscorp.com/kdes/advanced/data-sources.md): Browse Oracle objects without leaving Koala Studio - [SQL History](https://docs.btsscorp.com/kdes/advanced/sql-history.md): Review and reuse previously executed queries - [Multiple Tabs](https://docs.btsscorp.com/kdes/advanced/multiple-tabs.md): Work on several queries simultaneously - [App Settings](https://docs.btsscorp.com/kdes/config/app-settings.md): Customize Koala Studio to match your workflow - [Timeout Settings](https://docs.btsscorp.com/kdes/config/timeout-settings.md): Control how long Koala waits for Oracle responses - [Logging & Diagnostics](https://docs.btsscorp.com/kdes/config/logging-diagnostics.md): Collect logs to troubleshoot Koala Studio - [Performance Settings](https://docs.btsscorp.com/kdes/config/performance-settings.md): Tune Koala Studio for large workloads - [Free vs Paid Features](https://docs.btsscorp.com/kdes/licensing/free-vs-paid.md): Understand what’s included in each Koala Studio tier - [Activating Koala Studio](https://docs.btsscorp.com/kdes/licensing/activating-license.md): Enter your Koala license key in the native app - [Managing Licenses](https://docs.btsscorp.com/kdes/licensing/managing-license.md): Move Koala Studio licenses between machines - [Refund Policy](https://docs.btsscorp.com/kdes/licensing/refund-policy.md): How Koala Studio handles refunds and cancellations - [Troubleshooting & Support](https://docs.btsscorp.com/kdes/support/troubleshooting.md): Quick fixes and how to contact Koala - [Koala Studio Privacy Policy](https://docs.btsscorp.com/kdes/policies/privacy-policy.md): Customer-facing summary of how Koala Studio handles data, security, and user rights. - [Introduction](https://docs.btsscorp.com/orca/introduction.md): Convert data and manage configuration in Oracle Fusion Cloud - [How ORCA works](https://docs.btsscorp.com/orca/how-orca-works.md): The building blocks, the conversion lifecycle, and the Configuration Workbench - [Tenancy & users](https://docs.btsscorp.com/orca/account/tenancy-and-users.md): The multi-tenant model, roles, and user management - [The AI engine](https://docs.btsscorp.com/orca/account/ai-engine.md): The Anthropic API key, model routing, and the autonomous agent - [Oracle connections](https://docs.btsscorp.com/orca/connections/oracle-connections.md): Create a connection and let ORCA discover the pod's metadata - [Governed REST vs SQL](https://docs.btsscorp.com/orca/connections/governed-rest-vs-sql.md): How ORCA stays inside your Oracle security, and when direct SQL is allowed - [Projects, cycles & entities](https://docs.btsscorp.com/orca/workspace/projects-cycles-entities.md): The workspace hierarchy where a conversion runs - [The conversion lifecycle](https://docs.btsscorp.com/orca/workspace/conversion-lifecycle.md): From POC to prod cutover across cycles and environments - [Inside an entity](https://docs.btsscorp.com/orca/workspace/entity-workspace.md): Source data, mappings, preview, run, and ORCA Learnings - [Configuration Workbench](https://docs.btsscorp.com/orca/workspace/configuration-workbench.md): Migrate, reconcile, and version Oracle setup across environments - [The agent & chat](https://docs.btsscorp.com/orca/agent/agent-and-chat.md): The autonomous conversion agent and ask-anything chat - [Skills](https://docs.btsscorp.com/orca/agent/skills.md): Pre-built expert playbooks ORCA chat applies automatically - [Governance & autonomy](https://docs.btsscorp.com/orca/agent/governance-and-autonomy.md): The SQL consent moment and how tasks earn autonomy - [Connect to Claude](https://docs.btsscorp.com/orca/integrations/connect-to-claude.md): Query your Oracle Fusion data from Claude over MCP — governed, within your own Oracle security - [Getting help](https://docs.btsscorp.com/orca/support/getting-help.md): Support channels and common questions for ORCA - [Introduction](https://docs.btsscorp.com/finops/introduction.md): Multi-cloud cost intelligence — see your spend and ask Koala - [How it works](https://docs.btsscorp.com/finops/how-it-works.md): The ingest-to-insight pipeline, and why every number is evidence-backed - [Connect your clouds](https://docs.btsscorp.com/finops/connections/connect-clouds.md): Point Koala at your OCI, AWS, Azure, and GCP cost exports - [Ingestion](https://docs.btsscorp.com/finops/connections/ingestion.md): Upload FOCUS files, run loads on demand, or schedule automatic ingestion - [Dashboard](https://docs.btsscorp.com/finops/dashboard.md): Live spend visibility across every cloud - [Cost explorer](https://docs.btsscorp.com/finops/explorer.md): Slice your cost data and trace any total to its line items - [Insights](https://docs.btsscorp.com/finops/insights.md): Explainable, evidence-backed findings and recommendations - [Allocation](https://docs.btsscorp.com/finops/allocation.md): Attribute spend to applications — even when resources aren't tagged - [Ask Koala](https://docs.btsscorp.com/finops/chat.md): Query your cloud costs in plain language and get answers with charts and totals - [Tenancy & users](https://docs.btsscorp.com/finops/account/tenancy-and-users.md): Sign-in, tenants, roles, and access - [The AI engine](https://docs.btsscorp.com/finops/account/ai-engine.md): The model that powers chat and insight explanations — and the evidence guardrail - [Getting help](https://docs.btsscorp.com/finops/support/getting-help.md): Support channels and common questions for Koala FinOps ## OpenAPI Specs - [openapi](https://docs.btsscorp.com/api-reference/openapi.json) This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.