Data Sources¶
Connect Report Studio to the databases and services that supply report data and maps.
Goal¶
Add a connection in Connection Manager and use it for queries or map sources.
Prerequisites¶
- Network access to the target database or service
- Account credentials supplied by your administrator
Open Connection Manager¶
- Choose Data → Connection Manager… (or the Connections toolbar action).
- Click to add a new connection.
- Choose the provider type.
- Enter host, database, authentication, and options.
- Test the connection, then save.
[ Screenshot: Connection Manager ]
Supported database providers¶
| Provider | Notes |
|---|---|
| PostgreSQL / PostGIS | Primary GIS database provider (listed as PostgreSQL) |
| Oracle / Oracle Spatial | Oracle databases and spatial maps |
| SQL Server | Microsoft SQL Server |
| MySQL / MariaDB | MySQL connections; MariaDB via MySQL provider |
| SQLite | SQLite and GeoPackage files |
| IBM Db2 | Db2 LUW |
| Snowflake | Account identifier with password or key-pair authentication |
| Apache Cassandra | Native CQL data source (keyspaces / tables) |
| Google BigQuery | GoogleSQL via BigQuery API (service-account JSON) |
| DuckDB | Embedded DuckDB database or direct Parquet/CSV/JSON files |
| GeoServer | Workspaces and feature types; same connection can feed maps |
| ArcGIS Feature Server | Live Feature Server or Map Server layers |
Map image services¶
WMS and QGIS Server connections supply map images. See Maps.
File-based sources¶
| Source | Notes |
|---|---|
| CSV | One delimited file; the first row is the header |
| Excel | One .xlsx workbook; each visible worksheet is a table |
| JSON | A JSON file, or one HTTP(S) document fetched when the report runs |
| XML | One XML file; a repeating element is the record collection |
Tips¶
Tip
Use clear connection display names. Map publishing workflows often match these names on AcuGIS Report Server.
Note
Passwords are stored in the operating system credential store, not in plain text inside the project.