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

# Basic Authentication

> Sign in with Oracle username and password

## Overview

Basic authentication lets you connect to Oracle Fusion by entering the same username and password you use in the web UI. It’s available on every Koala Studio plan.

## Prerequisites

* Oracle Fusion Cloud account with report access
* Username/password that are allowed to run OTBI or BI Publisher queries
* Network access to your Oracle environment (VPN if required)

## Step-by-Step

1. Open Koala Studio and sign in with your Koala account.
2. Click **Connections** in the left rail or use `Ctrl/Cmd+,`.
3. Choose **Add Connection** → **Basic Authentication**.
4. Fill in:
   * **Name** – e.g., “Prod Financials”.
   * **Server URL** – your Oracle Fusion host ([https://xxxx.oraclecloud.com](https://xxxx.oraclecloud.com)).
   * **Username/Password** – saved securely and encrypted.
   * Optional **Description/Default schema** to label the connection.
5. Click **Test Connection**. If it succeeds, choose **Save**.

The new connection now appears in every query tab’s dropdown so you can run SQL immediately.

## Security Notes

* Credentials are encrypted locally and in Koala Cloud—Koala never stores them in plain text.
* Password changes on Oracle require you to edit the connection and update the stored password.

## Troubleshooting

* **Invalid credentials** – confirm the account isn’t locked and that MFA isn’t required for API access.
* **Connection timeout** – verify VPN/proxy settings or try again after switching networks.