Contact UsGet started

Creating a connection

Written by
Updated at September 27, 2024

Note

This feature is in the Preview stage.

You can create connections of the following types:

Connecting to a cluster with a managed database

Managed Service for PostgreSQL

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select the Connection type.
  8. Under Connection to PostgreSQL, select Managed Service for PostgreSQL cluster as the connection type and specify the cluster you need.
  9. Under Authentication:
    1. Specify the Username you will use to connect to the cluster.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You can connect only to the databases that exist in the cluster. You must have access to them configured.
  11. Click Create.

Managed Service for ClickHouse®

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select the Connection type.
  8. Under Connection to ClickHouse®, select Managed Service for ClickHouse® cluster as the connection type and specify the cluster you need.
  9. Under Authentication:
    1. Specify the Username you will use to connect to the cluster.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.
  11. Click Create.

Managed Service for MySQL®

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select the Connection type.
  8. Under Connection to MySQL®, select Managed Service for MySQL® cluster as the connection type and specify the cluster you need.
  9. Under Authentication:
    1. Specify the Username you will use to connect to the cluster.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You can connect only to the databases that exist in the cluster. You must have access to them configured.
  11. Click Create.

Managed Service for Redis

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select the Connection type.
  8. Under Connection to Redis, select Managed Service for Redis cluster as the connection type and specify the cluster you need.
  9. Under Authentication, select how to set the password:
    • Enter manually: Enter the password manually.
    • Generate: Specify the options to generate a Lockbox password automatically.
  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.
  11. Click Create.

Connecting to a user database installation

PostgreSQL

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select the Connection type.
  8. Under Connection to PostgreSQL, specify the connection parameters:

    1. In the Connection type field, select User installation.

    2. In the Hosts field, specify the database host address and port number for the connection.

    3. (Optional) Enable TLS.

      If your company has a certification authority (CA), the certificate issued by the CA will be used by default. If the company has no CA, upload the server's TLS certificate.

  9. Under Authentication:
    1. Specify the Username you will use to connect to the database.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.
  11. Click Create.

ClickHouse®

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select the Connection type.
  8. Under Connection to ClickHouse®, specify the connection parameters:

    1. In the Connection type field, select User installation.

    2. In the Hosts field, specify the FQDNs or IP addresses of the hosts in the shard, HTTP or TCP port for connection, and the shard name.

    3. (Optional) Enable TLS.

      If your company has a certification authority (CA), the certificate issued by the CA will be used by default. If the company has no CA, upload the server's TLS certificate.

  9. Under Authentication:
    1. Specify the Username you will use to connect to the database.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.
  11. Click Create.

MySQL®

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select the Connection type:
  8. Under Connection to MySQL®, specify the connection parameters:

    1. In the Connection type field, select User installation.

    2. In the Hosts field, specify the database host address and port number for the connection.

    3. (Optional) Enable TLS.

      If your company has a certification authority (CA), the certificate issued by the CA will be used by default. If the company has no CA, upload the server's TLS certificate.

  9. Under Authentication:
    1. Specify the Username you will use to connect to the database.
    2. Select the password setting method:
      • Enter manually: You set the password manually.
      • Generate: Password will be generated automatically. You can configure Lockbox password generation rules or leave the default ones.
  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.
  11. Click Create.

Redis

  1. In the management console, select the folder you want to create a connection in.
  2. Select Yandex MetaData Hub.
  3. In the left-hand panel, select Connection manager.
  4. Click Create connection.
  5. Specify the connection name.
  6. (Optional) Add a description and label for the connection.
  7. Select the Connection type.
  8. Under Connection to Redis, specify the connection parameters:
    1. In the Connection type field, select User installation.
    2. In the Hosts field, specify the FQDNs or IP addresses of the hosts in the shard, HTTP or TCP port for connection, and the shard name.
    3. (Optional) Enable TLS.
  9. Under Authentication, specify a username and select how you want to set the password:
    • Enter manually: Enter the password manually.
    • Generate: Specify the options to generate a Lockbox password automatically.
  10. (Optional) List the databases whose connections you want to manage. You must have access to them configured.
  11. Click Create.

ClickHouse® is a registered trademark of ClickHouse, Inc.

Previous
All guides
Next
Viewing a connection