Usage & Architecture
How Stored Connections Are Used
Once defined in the Database Store, connections can be reused by other modules by referencing the logical name of the stored connection instead of manually entering credentials.
Example Integration
- A connection is defined in Database Store (e.g.,
PG_ANALYTICS). - The Database Wizard retrieves it to browse schema and tables.
- Connector Manager references it when creating a replication connector.
- Database Comparer uses it to perform structure and data comparison.
This flow ensures unified and secure connection handling throughout the platform.
Module Integrations
| Module | Role | How It Integrates |
|---|---|---|
| Database Comparer | Compares database schemas and data | Retrieves connection definitions from Database Store. |
| Database Wizard | Interactive data explorer | Uses saved connections to connect and browse database structures. |
| Connector Manager | Manages replication connectors | Maps connection parameters from Database Store into connector configurations. |
Architectural Overview
Key Benefits
- Centralized configuration management for all databases.
- Time efficiency when creating and maintaining connectors.
- Consistent parameters shared between modules.
- Improved security — credentials stored securely in one place.
- Simplified integration with GUI-based tools.
- Reduced configuration errors through validation and mapping automation.