Connections

The Connections section is designed for configuring and managing database connections that are used within a project. Configured connections contain all the necessary parameters for database access and are automatically utilized by various project elements.

Adding a Project Connection

To add a new project connection, the following details are required:

• Database Type (supported DBMS):
  • PostgreSQL
  • MS SQL Server
• Connection Name
• Database Host
• Database Port
• Database Name
• Database Schema
• Database User
• User Password

Using Connections

The system operates with connections in offline mode. After the initial connection setup, the database structure (metadata of tables, fields, and types) is saved within the system. All subsequent work in the project—designing fact tables, data marts, and metrics—is performed using these saved structural snapshots, without the need for a constant live connection to the database.