How to Create a Data Connection
Follow these steps to connect your database to Tepun AI Report Builder and unlock AI-powered analytics.
- Navigate to Connections — From the report.tepun.com dashboard, click "Connections" in the main menu.
- Click New Connection — Select "New Connection" or "Add Connection" to start the wizard.
- Choose Your Database Type — Select PostgreSQL, MySQL, SQL Server, or your data source type.
- Enter Connection Details:
- Host: Your database server address (e.g., db.example.com)
- Port: Database port (e.g., 5432 for PostgreSQL)
- Database Name: The specific database to connect to
- Username: Database user with read access
- Password: User password (encrypted and secure)
- Test the Connection — Click "Test" to verify connectivity. The wizard confirms successful connection.
- Save and Build Schema — Save the connection. Tepun AI automatically scans and indexes your schema.
Pro Tip: Use a read-only database user for security. Tepun reports only needs SELECT permissions to analyze and query your data.
Connection Security
- Encrypted Credentials: All passwords are encrypted at rest
- Secure Transmission: Connections use TLS/SSL encryption
- IP Whitelisting: Configure firewalls to allow only Tepun servers
Troubleshooting
| Issue | Solution |
|---|---|
| Connection timeout | Verify host is accessible, check firewall rules |
| Authentication failed | Double-check username and password |
| Permission denied | Ensure user has SELECT permission on tables |
Once connected, Tepun AI analyzes your schema and generates suggestions. Continue to Schema Explorer to learn more.