How to Connect Your Database to clariBI

clariBI supports multiple database types and connection methods. This guide covers the most common scenarios.

Supported Databases

• PostgreSQL (recommended)
• MySQL/MariaDB
• Google BigQuery
• AWS Redshift
• Snowflake
• Microsoft SQL Server
• MongoDB

Connection Setup

PostgreSQL/MySQL

1. Go to Data Sources → Add Connection
2. Select Database → PostgreSQL or MySQL
3. Enter connection details:
   - Host: your-database-host.com
   - Port: 5432 (PostgreSQL) or 3306 (MySQL)
   - Database name
   - Username and password
4. Click Test Connection
5. Save your connection

Google BigQuery

1. Select Google BigQuery as connection type
2. Upload your service account JSON key
3. Enter your project ID and dataset
4. Test and save

Security Best Practices

• Use read-only database users
• Enable SSL connections
• Whitelist clariBI IP addresses
• Rotate credentials regularly

Troubleshooting

• Connection timeout: Check firewall settings
• Permission denied: Verify user privileges
• SSL required: Enable SSL in connection settings

For more help, contact our technical support team.