Port
Port is the central module in Pirivision where all data sources are added, listed, edited, and managed.
Once a data source is added to Port, queries can be written in the Compass module; the queries then flow through the Cartography → Horizon → Atlas chain to become a dashboard.
flowchart LR
A[Port<br/>Data Source] --> B[Compass<br/>Query]
B --> C[Cartography<br/>Chart / KPI]
C --> D[Horizon<br/>Page / Board]
D --> E[Atlas<br/>Dashboard]
Data Sources
Supported Data Sources
| Data Source |
Category |
Connection Type |
Save |
| PostgreSQL |
Relational Database |
TCP / network |
Test & Save |
| MSSQL |
Relational Database |
TCP / network |
Test & Save |
| MySQL |
Relational Database |
TCP / network |
Test & Save |
| MQTT |
Real-Time Broker |
WebSocket / TCP |
Save |
| REST API |
Web Service |
HTTP / HTTPS |
Test & Save |
| Excel Offline |
File Upload |
— |
Save |
Adding a Data Source
| Guide |
Description |
| Add PostgreSQL |
Relational database — schema, host, port, auth |
| Add MSSQL |
Microsoft SQL Server — T-SQL, SQL Auth |
| Add MySQL |
Open-source SQL — host, port, auth |
| Add MQTT |
Real-time broker — protocol, topic, keep-alive |
| Add REST API |
HTTP endpoint — base URL, headers, timeout |
| Add Excel Offline |
.xlsx file upload |
Editing a Data Source
Data Source Management
| Action |
Description |
| Move |
Move a data source or folder to a different location |
| Duplicate |
Copy an existing data source with the same settings |
| Delete |
Remove an unused data source |
Synthetic Data Generation
A ready-made industrial dataset for demo and documentation environments:
| Source |
Description |
| Demo Factory Setup |
Integrated demo scenario covering PostgreSQL, MSSQL, MySQL, MQTT, REST API, and Excel data sources |
| Area |
Resource |
| Tagging |
Organize data sources with color-coded labels → Tags |
| SQL Assistant |
AI-assisted SQL writing in Compass for PostgreSQL / MSSQL / MySQL sources → Makinist |
Next Step
After adding a data source, create a query in the Compass module.
→ Compass