Connecting Your Data
Estimated reading time: 10 minutes
Before clariBI can analyze anything, it needs access to your data. This guide covers the three main ways to connect: databases, files, and cloud services.
Data Source Limits by Plan
- Trial: 3 data sources, 1 GB storage, 5 file uploads
- Starter ($99/mo): 10 data sources, 5 GB storage, 50 file uploads
- Professional ($199/mo): 50 data sources, 10 GB storage, 500 file uploads
- Enterprise ($999/mo): 100 data sources, 100 GB storage, 5,000 file uploads
Method 1: Upload Files
The fastest way to get started. Go to Data Sources and click Add New Source, then choose File Upload. Supported formats:
- CSV — comma-separated values, the most common format
- Excel (.xlsx, .xls) — workbooks with multiple sheets
- JSON — structured data files
- PDF — document analysis with OCR
- TXT — plain text data files
Drag your file onto the upload area or click to browse. clariBI automatically detects column types, headers, and data formats. Upload completes in seconds for files under 100 MB.
Pro Tip
For CSV files, make sure the first row contains column headers. clariBI uses headers to understand your data structure. Files without headers will have columns named "Column 1", "Column 2", etc.
Method 2: Connect a Database
For live, continuously updated data, connect a database directly. Go to Data Sources, click Add New Source, and select your database type:
| Database | Required Info |
|---|---|
| PostgreSQL | Host, port (5432), database name, username, password |
| MySQL | Host, port (3306), database name, username, password |
| SQLite | Database file path |
| MongoDB | Host, port (27017), database name, username, password |
After entering credentials, click Test Connection to verify clariBI can reach your database. If the test passes, click Save. clariBI will run an initial sync to catalog your tables and columns.
Firewall Note
If your database is behind a firewall, you will need to whitelist clariBI's IP address. Contact support for the current IP range.
Method 3: Cloud Services
Connect cloud platforms through OAuth or API keys:
- Google Analytics — OAuth flow, select property and views
- Google Sheets — OAuth flow, select specific spreadsheets
- REST APIs — custom API endpoint with configurable headers and authentication
- Meta (Facebook) Ads — OAuth flow for ad performance data
- Jira / Confluence — API token authentication
See Data Sources Overview for the full list of supported data source types.
After Connecting
Once a data source is connected and synced:
- It appears in the Data Sources list with a green "Connected" status
- It becomes available as an option when creating dashboards, reports, or asking questions in Ask clariBI
- You can trigger manual syncs from the Data Sources page
Troubleshooting Common Issues
If your connection fails:
- Connection timeout — check that the host is reachable and the port is correct
- Authentication failed — verify username and password; ensure the user has read access
- SSL required — toggle the SSL option in the connection form
- File parsing error — check that CSV files use UTF-8 encoding and consistent delimiters
For more details, see Data Source Troubleshooting.
Next Steps
Ready to try clariBI?
Start your free 14-day trial. No credit card required.