Supported systems
Audience: IT and data teams
Goal: Choose supported database and warehouse connectors for PrismBI.
Databases and warehouses
PrismBI Edge Agents support read-only connectivity to common analytical and operational stores, including:
| System | Notes |
|---|---|
| PostgreSQL | Common OLTP and analytics |
| MySQL | Operational reporting |
| SQLite | Edge and embedded scenarios |
| DuckDB | Local analytical files |
| Snowflake | Cloud warehouse |
| SQL Server | Enterprise warehouse and OLTP |
| ClickHouse | High-volume analytics |
| Oracle | Enterprise workloads |
Additional connector logos appear on the PrismBI marketing site (public/integrations/) as the platform expands—confirm availability with your account team before procurement.
Setup path
- Install the required driver on the Edge Agent (Agents → <agent> → Drivers).
- Create a datasource in the Admin Portal.
- Run Test connection and Discover schema.
- Review entities in the Semantic catalog.
Service integrations (non-SQL)
| Service | Purpose | Configuration |
|---|---|---|
| Amazon S3 | Object storage exports | Integrations |
| SMTP | Email notifications | Integrations |
| MCP servers | External tools | MCP connections |
Security expectations
- Use read-only database roles with row and timeout limits enforced by PrismBI.
- Keep credentials in the customer network; rotate on your standard schedule.
- No inbound firewall rules from PrismBI cloud into your VPC are required.
Tips
- Match connector choice to where data already lives—PrismBI does not require centralizing data in the vendor cloud.
- Pilot with one warehouse before connecting every source.
- Document which datasource powers which business domain for Explore users.
Troubleshooting
| Issue | What to try |
|---|---|
| Type not listed | Contact support for connector roadmap |
| Connection timeout | Check agent egress and database security groups |
| Schema incomplete | Re-run discovery; verify driver version on agent |