Configuring ADB connections
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.
-
Go to the VK Cloud management console.
-
Go to the Аналитические БД → Инстансы АБД section.
-
Click the name of the desired ADB instance.
-
On the PXF подключения tab, click the Добавить PXF подключение button.
-
In the Подключение field, select the desired connection type and set the corresponding parameters:
S3KafkaHivePostgresClickhouseHDFSOracleMS SQLMySQL-
Название 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.
-
-
Click the Добавить button.
-
Go to the VK Cloud management console.
-
Go to the Аналитические БД → Инстансы АБД section.
-
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.
-
Click the connection name to view detailed information about its parameter values.
- Go to the VK Cloud management console.
- Go to the Аналитические БД → Инстансы АБД section.
- Click the name of the desired ADB instance, and then select the PXF подключения tab.
- Click
for the desired connection and select the Удалить option.
- Confirm the deletion.