An External Database Connection lets you link the platform to an external Microsoft SQL Server (MSSQL) or PostgreSQL database so that you can access and use live data directly from that database without copying or storing it inside the platform.
This allows the platform to work with data that already exists in external systems while keeping the source database as the single source of truth. Any change made in the external database is reflected immediately when the data is accessed through the platform.
Use an External Database Connection when:
This approach ensures data accuracy and removes the need for manual synchronization.
Use Case
Real-time access to external system data
An organization connects the platform to an existing MSSQL or PostgreSQL database that stores operational data such as customers, orders, or inventory. Instead of importing this data, the platform reads it directly from the external database.
With this setup, teams can:
- View up-to-date records without manual updates.
- See changes instantly when data is modified in the external database.
- Work with consistent data across systems.
This helps teams operate efficiently while maintaining a single, authoritative data source.
An External Database Connection acts as a data source within the platform. Once the connection is configured, the external data can be used in the same way as other data sources.
You can:
This enables seamless integration with existing databases while keeping data management centralized in the source system.