Skip to content

Create connection

Team Edition provides multiple methods to set up a connection. To create a connection, do one of the following:

Create a new connection

  1. Initiate new connection:

    • Click the + button in the top menu.
    • Select New Connection from the dropdown options.

  2. Select the appropriate driver from the available options.

    Note

    If no driver is available for your database, you may need to create a custom driver. By default, some drivers require downloading. If a driver is missing, you’ll see a warning message.

  3. Enter all necessary details in the form fields provided. For detailed steps on filling out these fields, refer to the section below.

  4. Test the connection (optional):

    • Click the Test button to ensure the connection parameters are correct.

  5. After confirming all details, click the Create button.

Access and modify connection

To edit the connection details, click the context button next to the connection name and choose Manage -> Edit Connection.

Use the Cloud Explorer

Cloud connections are set up through your cloud service provider and automatically populated in your navigator tree, based on configurations managed by the server administrator.

Info

For details on configuring and managing cloud connections, see the Cloud Explorer.

Configure connection settings

In the New connection wizard, on the Main tab, you need to set all primary connection settings.

Here's what you typically need to configure:

Setting Description
Host The address of your database server .
Port The port number used to connect.
Database The name of the database you want to connect to.
Connection name A name you choose for this connection. It shows up in the Database Navigator.
Project Links the connection to a specific Project. You can choose between "Shared" and "Private".
Description A short description of the connection.
Authentication Choose the type of authentication the database requires.

Private and shared connections

Each connection belongs to a project - either Private or Shared. Private connections are only visible to you. Shared connections are managed by the administrator and accessible to multiple users or teams.

Share credentials with teammates

To share a connection with your team, switch to a shared project in the toolbar:

  1. Start creating a new database connection.
  2. In the Authentication section, check the Share credentials with teammates checkbox.
  3. Select the required type of credentials.

  4. Navigate to the Credentials tab.

  5. In the Credentials tab, select the team with which you want to share the credentials.

  6. Fill in the necessary fields based on the selected type of credentials.

Note

Share credentials checkbox ignored when using Secret Providers.

Expert settings

Setting Description
Keep alive (in seconds) Sets the interval in seconds for sending signals to keep the connection active. Set to 0 to disable.
Auto commit Automatically commits changes during a transaction if enabled. For more information, see Auto and Manual commit

Note

The number and type of connection properties depend on the driver.

Additional settings

When setting up a new connection, you may need to configure additional options:

Additional tab Description
Driver Properties Each driver has its own set of additional properties.
SSH Tunnel Configure an SSH tunnel if your database requires a secure connection.
SSL Enable and configure SSL if your connection requires encryption.

Secure Storage with Secret Providers

Team Edition supports various cloud-based secret providers to retrieve database credentials securely.

Info

For detailed setup instructions, see Secret Providers.

Use pre-configured connections

You can pre-configure database connections (datasources) in data-sources.json before the server starts - useful when you deploy the server repeatedly and don't want to create connections manually in the UI each time.

Info

For details, see Configuring server datasources.