VK Cloud logo

Configuring ADB connections

Adding a PXF connection

A PXF connection allows Arenadata DB to work with external data sources. These can be both third-party DBMSs and data in text and binary formats.

  1. Go to the VK Cloud management console.

  2. Go to the Аналитические БД → Инстансы АБД section.

  3. Click the name of the desired ADB instance.

  4. On the PXF подключения tab, click the Добавить PXF подключение button.

  5. In the Подключение field, select the desired connection type and set the corresponding parameters:

    • Название PXF подключения: enter the PXF connection name.

    • Бакет S3: select a VK Object Storage bucket or create a new bucket.

      The bucket name must comply with the recommended rules.

      The bucket name cannot be changed after creation.

    • Путь внутри бакета: specify the path inside the bucket in the /folder1/ format.

      This directory can contain files in text and binary formats supported by the Greenplum kernel.

    • S3 Access Key ID: specify the access key identifier.

    • S3 Secret Key: specify the secret access key.

  6. Click the Добавить button.

Viewing PXF connections

  1. Go to the VK Cloud management console.

  2. Go to the Аналитические БД → Инстансы АБД section.

  3. Click the name of the desired ADB instance, and then select the PXF подключения tab.

    A list of PXF connections with the specified profile type will be displayed.

  4. Click the connection name to view detailed information about its parameter values.

Deleting a PXF connection

  1. Go to the VK Cloud management console.
  2. Go to the Аналитические БД → Инстансы АБД section.
  3. Click the name of the desired ADB instance, and then select the PXF подключения tab.
  4. Click Configuring ADB connections for the desired connection and select the Удалить option.
  5. Confirm the deletion.
Was this article helpful?