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.
Connecting your database — allowlist Tepun
Cloud databases often block unknown clients. Allow Tepun's permanent outbound IP on your firewall before testing the connection. The current IP is shown on the New Connection page (copy button). Tepun connects outbound only — we never require inbound access into your network.
- Ports: SQL Server / Azure SQL
1433, PostgreSQL5432, MySQL3306 - Encryption: Require SSL/TLS
- Azure: SQL/PostgreSQL/MySQL → Networking → Firewall rules → add the Tepun IP
- AWS RDS: Security group inbound from the Tepun IP
/32to your DB port - GCP Cloud SQL: Authorized networks → add the Tepun IP
/32
Connection Security
- Encrypted Credentials: All passwords are encrypted at rest
- Secure Transmission: Connections use TLS/SSL encryption
- IP allowlisting: Allow only Tepun's outbound IP (see above)
Troubleshooting
| Issue | Solution |
|---|---|
| Connection timeout / firewall (e.g. Azure SQL 40615) | Allowlist Tepun's outbound IP; confirm port and SSL |
| Authentication failed | Double-check username and password (not a firewall issue) |
| Permission denied | Ensure user has SELECT permission on tables |
| DNS / host not found | Verify the hostname spelling and public DNS |
Once connected, Tepun AI analyzes your schema and generates suggestions. Continue to Schema Explorer to learn more.