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.