> ## Documentation Index
> Fetch the complete documentation index at: https://docs.lerian.studio/llms.txt
> Use this file to discover all available pages before exploring further.

# Managing Data Sources

> Review, test, and manage the database connections that supply data to Reporter.

Data Sources are connections that Reporter uses to fetch the data needed for report generation. Some Data Sources can already be configured for internal Lerian products, such as Midaz or CRM. Use this page to review those connections, test them, or manage external database connections through the [Lerian Console](/en/platform/console/about-lerian-console).

## What is a Data Source?

***

A Data Source is a connection between Reporter and a data store. To generate reports, Reporter needs access to source data. For internal product data, the connection may already exist. For external databases, operators can add and manage the connection from this page.

Each Data Source includes:

* **Connection name**: a human-readable identifier.
* **Database type**: the database engine used by the connection: PostgreSQL or MongoDB.
* **Access configuration**: host, port, database name, credentials, and optionally SSL configuration, when the Data Source is an external database connection.
* **Schemas**: for PostgreSQL connections, you can specify which schemas to access.
* **Metadata**: additional key-value fields for organization.

Operators usually use this page to answer three questions:

* Is the connection available?
* Which schemas, tables, and fields can Reporter read?
* Is this the right Data Source for the Template or Report that you prepare?

## Supported databases

***

| Database   | Default port | Schema support |
| ---------- | :----------: | :------------: |
| PostgreSQL |     5432     |        ✅       |
| MongoDB    |     27017    |        ❌       |

## Accessing the Data Sources page

***

To open the **Data Sources** page, click **Data Sources** from the left-side menu on the **Reporter** page.

You do not need to start here in every Reporter journey. Start here when the needed Data Source is absent. Start here when you must add an external database, or when a report fails because data is unreachable.

The page displays all configured connections, each in a card showing:

* Connection name and database type.
* Connection status (**Connected**, **Disconnected**, or **Connecting**).
* Configured schemas (if any).
* Latency from the last check.
* Host, database, and user details.

You can expand each card to view the database schema, including available tables and columns.

### Available actions

From the Data Sources page, you can:

<Columns cols={2}>
  <Card title="Add a Data Source" icon="plus" horizontal href="/en/products/reporter/console/adding-a-data-source">
    Create a reusable external database connection for Reporter.
  </Card>

  <Card title="Edit a Data Source" icon="pen" horizontal href="/en/products/reporter/console/editing-a-data-source">
    Update credentials, host, schemas, SSL, or metadata.
  </Card>

  <Card title="Test connection" icon="plug" horizontal href="/en/products/reporter/console/testing-a-data-source">
    Confirm Reporter can reach the database and load schema information.
  </Card>

  <Card title="Delete a Data Source" icon="trash" horizontal href="/en/products/reporter/console/deleting-a-data-source">
    Remove retired connections that you no longer use.
  </Card>
</Columns>

<Tip>
  If a Report fails because data is absent or unreachable, first test the Data Source. Then check whether the expected schema and table appear in the expanded card.
</Tip>