Configuring a Greenplum® target endpoint

• MDB cluster ID: Select the cluster to connect to.

• Security groups: Select the cloud network to host the endpoint and security groups for network traffic.

  This will let you apply the specified security group rules to the VMs and clusters in the selected network without changing the settings of these VMs and clusters. For more information, see Network in Yandex Data Transfer.

• Database: Specify the name of the database in the selected cluster.

• Username: Specify the username that Data Transfer will use to connect to the database.

• Password: Enter the user's password to the database.

• CA certificate: Upload the certificate file or add its contents as text if encryption of the transmitted data is required, for example, to meet the PCI DSS requirements.

• Subnet ID: Select or create a subnet in the desired availability zone.

  If the source and target are geographically close, connecting over the selected subnet speeds up the transfer.

• Coordinator host: Specify the IP or FQDN of the primary master host to connect to.

• Coordinator port: Specify the port for Data Transfer to use to connect to the primary master host.

• Coordinator mirror host: Specify the IP or FQDN of the backup master host to connect to (optional if there is only one master host).

• Coordinator mirror port: Specify the port for Data Transfer to use to connect to the backup master host (optional if there is only one master host).

• Greenplum® cluster segments: Specify segment host connection information. If you omit these, segment host addresses will be retrieved automatically from the master host housekeeping table.

• Security groups: Select the cloud network to host the endpoint and security groups for network traffic.

  This will let you apply the specified security group rules to the VMs and clusters in the selected network without changing the settings of these VMs and clusters. For more information, see Network in Yandex Data Transfer.

• Database: Specify the name of the database in the selected cluster.

• Username: Specify the username that Data Transfer will use to connect to the database.

• Password: Enter the user's password to the database.

• CA certificate: Upload the certificate file or add its contents as text if encryption of the transmitted data is required, for example, to meet the PCI DSS requirements.

• Subnet ID: Select or create a subnet in the desired availability zone.

  If the source and target are geographically close, connecting over the selected subnet speeds up the transfer.

Cleanup policy: Select a way to clean up data in the target database before the transfer:

• Drop: Fully delete tables included in the transfer (default).

  Use this option so that the latest version of the table schema is always transferred to the target database from the source whenever the transfer is activated.

• Disabled: Do not clean.

  Select this option if only replication without copying data is performed.

• Truncate: Delete only the data from the tables included in the transfer but leave the schema.

  Use this option if the schema in the target database differs from the one that would have been transferred from the source during the transfer.