Data Sources
The Pirivision Port module supports six data source types commonly used in industrial and enterprise systems. Once a data source is added, queries / topics / endpoints / sheets are defined in Compass and transformed into dashboards through the Cartography → Horizon → Atlas chain.
Supported Data Sources
| Data Source | Category | Connection Type | Save Action |
|---|---|---|---|
| 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 | — (offline) | Save |
Typical Usage Scenarios
| Scenario | Recommended Data Source |
|---|---|
| Production history (SCADA / MES) | PostgreSQL or MSSQL |
| ERP / enterprise reporting | MSSQL or REST API |
| Open-source DBs, web apps | MySQL |
| Real-time sensor streams | MQTT |
| Third-party SaaS / microservice APIs | REST API |
| Manual reports (lab, maintenance) | Excel Offline |
Add Guides
| Data Source | Page |
|---|---|
| PostgreSQL | Add PostgreSQL |
| MSSQL | Add MSSQL |
| MySQL | Add MySQL |
| MQTT | Add MQTT |
| REST API | Add REST API |
| Excel Offline | Add Excel Offline |
Edit Guides
| Data Source | Page | Update Button |
|---|---|---|
| PostgreSQL | Edit PostgreSQL | Test and Update |
| MSSQL | Edit MSSQL | Test and Update |
| MySQL | Edit MySQL | Test and Update |
| MQTT | Edit MQTT | Update |
| REST API | Edit REST API | Test and Update |
| Excel Offline | Edit Excel Offline | Update |
Test & Save vs Save
Relational DBs and REST API use Test & Save / Test and Update which actually probes the connection before saving. MQTT (asynchronous broker connection) and Excel (file upload) use Save / Update only.
Data Source Management
Move, duplicate or delete existing data sources:
Next Step
After adding a data source, define a query / topic / endpoint / sheet in Compass.
→ Compass