Data Sources Overview
Resplendent Data pulls from your business tools and databases. This section covers what you can connect and how to manage those connections.
Types of data sources
Section titled “Types of data sources”1. Cloud integrations
Section titled “1. Cloud integrations”Direct API connections to common business apps. These are pre-configured to sync the data you’ll actually use.
- PSA/ITSM: ConnectWise Manage, Autotask, HaloPSA
- Monitoring / RMM: Liongard, NinjaOne
- Accounting: QuickBooks Online, Wave Financial
- Office: Google Sheets
2. Database connections
Section titled “2. Database connections”Connect directly to your own databases.
- PostgreSQL, MySQL, Microsoft SQL Server, IBM DB2
3. On-premise and local sources
Section titled “3. On-premise and local sources”For systems that aren’t accessible from the cloud, we have a Sync Agent.
- QuickBooks Desktop: Sync your desktop accounting data
- Private databases: Connect to databases behind a firewall
How syncing works
Section titled “How syncing works”The data flow
Section titled “The data flow”Source App/Database → Integration → Datasets → Widgets- Connect: Authenticate with your source
- Initial sync: We pull your historical data (can take a while for large accounts)
- Automated refresh: The system checks for changes based on your tier’s refresh rate
Refresh rates by tier
Section titled “Refresh rates by tier”| Tier | Refresh rate |
|---|---|
| Free Forever | 60 minutes |
| Starter | 15 minutes |
| Professional | 60 seconds |
| Business / Starship | 60 seconds |
Connecting a new source
Section titled “Connecting a new source”Step 1: Open the integrations page
Section titled “Step 1: Open the integrations page”- Click Data Settings in the sidebar
- Select Integrations
Step 2: Connect and authenticate
Section titled “Step 2: Connect and authenticate”- Find your integration in the gallery
- Click Connect on the card
- Follow the prompts to sign in via OAuth or enter your API credentials
Step 3: Select datasets
Section titled “Step 3: Select datasets”Once connected, you’ll see all available tables from that source. Pick the ones you want and click Start Sync.
Managing existing connections
Section titled “Managing existing connections”Your active connections live in Data Settings → Integrations.
- Monitor status: See if a connection is healthy or has an auth error
- Update credentials: If your API key changes, update it here without breaking your widgets
- Disconnect: Removes the integration and stops syncing