Database Connections

You can connect directly to your own databases—useful for building dashboards on custom applications, data warehouses, or legacy systems.

Supported databases

• PostgreSQL
• MySQL / MariaDB
• Microsoft SQL Server
• IBM DB2

---

Prerequisites

You’ll need this info from your database administrator:

1. Host/IP: The server’s network address
2. Port: Connection port (e.g., 5432 for Postgres, 3306 for MySQL)
3. Database name: The specific schema to access
4. Read-only credentials: Username and password with SELECT permissions

Caution

Never use a superuser or admin account. Create a dedicated read-only user limited to the tables you need for reporting.

---

Setup instructions

Step 1: Whitelist our IPs

If your database is behind a firewall, you’ll need to whitelist our sync servers. Contact support@resplendentdata.com for the current IP list.

Step 2: Connect in Resplendent Data

1. Go to Data Settings → Integrations
2. Find your database type and click Connect on the card
3. Enter your connection details:
   • Host
   • Port
   • Database name
   • Username & password
   • SSL Mode (we recommend Require for cloud connections)
4. Click Test Connection

---

Sync performance and refresh rates

Tier	Refresh frequency
Free Forever	Every 60 minutes
Starter	Every 15 minutes
Professional / Business / Starship	Every 60 seconds

Incremental sync

For larger tables, set up incremental sync to avoid pulling the entire table every time:

• Primary Key: The unique ID for each row
• Updated Column: A timestamp like updated_at that tells us which records changed

On-premise databases

If your database isn’t on the public internet, you can use the Resplendent Sync Agent (available on Business tier and higher).

Related topics

• Managing synced datasets
• Creating modified datasets