Data Sources are connections to external databases that the Reporter uses to fetch the data needed for report generation. In this section, you’ll learn how to manage Data Sources via the Lerian Console.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.
What is a Data Source?
A Data Source represents a configured connection between the Reporter and a database. To generate reports, the Reporter needs to access data stored in your environment’s databases — and Data Sources are the mechanism to configure and manage those connections. Each Data Source includes:
- Connection name — a human-readable identifier for easy management.
- Database type — the database engine being used (PostgreSQL, MySQL, MongoDB, Oracle, or SQL Server).
- Access configuration — host, port, database name, credentials, and optionally SSL configuration.
- Schemas — for databases that support schemas (PostgreSQL, Oracle, SQL Server), you can specify which schemas to access.
- Metadata — additional key-value fields for organization.
Supported databases
| Database | Default port | Schema support |
|---|---|---|
| PostgreSQL | 5432 | ✅ |
| MySQL | 3306 | ❌ |
| MongoDB | 27017 | ❌ |
| Oracle | 1521 | ✅ |
| SQL Server | 1433 | ✅ |
Accessing the Data Sources page
To open the Data Sources page, click Data Sources from the left-side menu on the Reporter page. 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.