Overview
Connections represent Entegrata’s link to your data sources. Each connection securely stores authentication credentials and defines default collection settings for all resources within that data source.Key Concepts
What is a Connection?
A Connection provides the secure bridge between Entegrata and a data source (database, API, file system). Each connection includes:Secure credentials (username/password, API keys, tokens) used to access your data source
Technical details needed to reach your data source (host, port, database name, API endpoint)
Default schedule that determines when resources collect data (can be overridden per resource)
Current state of the connection:
- Active - Connection is operational and resources can collect
- Inactive - Connection is paused; no data collection occurs
Connection Lifecycle
Each data source type has specific authentication requirements and available connection parameters.
Connection vs. Resources
It’s important to understand the relationship:| Aspect | Connection | Resource |
|---|---|---|
| Authentication | Stored at connection level | Inherited from connection |
| Schedule | Default for all resources | Can override connection default |
| Discovery | Discovers all resources | Discovered within connection |
| Enable/Disable | Determines if any resources can collect | Only affects specific resource |
Authentication Methods
SQL Authentication
Username and password-based authentication for SQL databases:- Standard login credentials
- Password expiration tracking
- Connection string parameters
Windows Authentication
Domain-based authentication for on-premise SQL Server:- Uses Windows domain credentials
- No password required (trusted connection)
- Requires domain connectivity
API Keys and Tokens
Token-based authentication for cloud APIs:- API keys for various services
- OAuth tokens for various platforms
- Bearer tokens for REST APIs
Azure Entra ID
Modern authentication for Azure services:- OAuth 2.0 token-based
- Multi-factor authentication supported
- Managed identity options for self hosted customers
Connection Settings
Collection Schedule
Determines when resources in this connection collect data:- Interval-based: Regular time intervals (minutely, hourly, daily)
- Time-based: Specific times (e.g., “Daily at 2:00 AM”)
Throttle Profile
Controls collection speed to manage source system load:- Safe - Slower collection to reduce impact on source systems (least resource intensive)
- Standard - Normal collection speed for most use cases (default)
- Faster - Faster collection for time-sensitive data (medium resource intensive)
- Fastest - Fastest collection from read replicas (most resource intensive)
Secret Expiration
Track when authentication credentials expire:- Set expiration date for passwords and API keys
- Receive notifications before expiration
- Plan credential rotation in advance
Connection Status
Active
- Collection is allowed
- Resources can collect according to schedule
- Discovery runs automatically every 3 hours
Inactive
- Collection is paused
- All resources stop collecting (even if individually enabled)
- Discovery does not run
Getting Started
Creating Connections
Step-by-step guide to add a new data source connection
Viewing Connections
Browse and search your configured connections
Editing Connections
Update credentials and connection settings
Collection Settings
Configure schedules and collection behavior