Account
Skip to main content

Configuring an ADF Linked Service Connection for Greenplum

note

For information on how to enable a connection for use with linked services, see Configuring a Linked Service Connection.

After selecting Greenplum from the Linked Service Type dropdown, the form required for creating a Greenplum Linked Service will appear. The Greenplum option is offered on connections that use the Greenplum System Type.

BimlFlex authors the Greenplum linked service at connector version 2.0. The linked service uses Basic authentication, and the form has no control for it. The SSL Mode select writes the SSL mode of the linked service, and when it is left at Not set the Azure Data Factory default of Require applies.

Source Only Connector​

A Greenplum connection is used as a source. It is not available as a target.

A Greenplum connection drives a Copy dataset from metadata, with the Schema and Table of the source object. The dataset element is Greenplum and the copy source is GreenplumSource. The copy source carries the query that BimlFlex composes from the columns and the source filters of the source object, with identifiers quoted in double quotes (").

Required Fields​

The required fields are:

Optional fields are:

Connect via Integration Runtime​

Connect via Integration Runtime names the integration runtime for a Greenplum Linked Service connection. The default value is AutoResolveIntegrationRuntime. To use another runtime, select it from the dropdown or choose + New to add one. The custom values that appear in this dropdown can be maintained in Settings under Azure, in the AzureIntegrationRuntime setting.

Azure Data Factory connects to Greenplum at version 2.0 through the Azure integration runtime or a self-hosted integration runtime. Use a self-hosted integration runtime for a Greenplum database inside an on-premises network or a private cloud network, such as an Azure virtual network or an Amazon Virtual Private Cloud, and the Azure integration runtime for a managed cloud database. Azure Data Factory provides the driver for Greenplum, so no driver is installed. BimlFlex writes the selected runtime to the linked service when it is not AutoResolveIntegrationRuntime.

Server​

The Server is the host name or IP address of the Greenplum server. Server is required. The form saves it in the LS_Server column, and BimlFlex writes it to the linked service as the host property.

Port​

The Port is the TCP port of the Greenplum database server. Port is optional, and the form shows 5432 as a placeholder. The form saves it in the LS_Port column, and BimlFlex writes it to the linked service as the port property. When Port is empty, BimlFlex writes no port property and the Azure Data Factory default of 5432 applies.

Database Name​

The Database Name is the name of the Greenplum database. Database Name is required. The form saves it in the LS_Db column, and BimlFlex writes it to the linked service as the database property.

User Name​

The User Name is the user name that connects to the Greenplum database. The form does not mark User Name as required, but the Greenplum linked service requires it. The form saves it in the LS_Username column, and BimlFlex writes it to the linked service as the username property.

Password​

The Password field has a Password tab for the password as text, and an Azure Key Vault tab beside it for a reference that resolves to the password at runtime. The form saves the tab that is selected: a password entered as text in the LS_Password column, or the Azure Key Vault reference in the LS_PasswordKVS columns.

The Greenplum linked service takes its password from Azure Key Vault alone. The Azure Key Vault reference is named by the AKV Linked Service, the Secret Name and an optional Secret Version. BimlFlex writes it as the pwd secret of the linked service when both the AKV Linked Service and the Secret Name are filled.

A password entered as text on the Password tab is not written to the linked service. The build reports a warning that names the connection:

Connection '<connection name>': the password column is not written to the Greenplum linked service, which takes its password from Key Vault alone. Name the secret in the PasswordKVS columns.
note

Use Azure Key Vault for the Greenplum password, on the Azure Key Vault tab of the Password field.

SSL Mode​

The SSL Mode select sits after the Password field and offers Not set, Disabled, Allow, Preferred, Required, Verify CA and Verify Full. SSL Mode is optional, and Not set is the default. The form saves a selected mode as the sslMode key of the connection's additional settings, and BimlFlex writes it to the linked service as the sslMode property. When SSL Mode is Not set, the form stores no key, BimlFlex writes no sslMode property, and the Azure Data Factory default of Require applies. A stored value that is not one of the six modes is reported by name as a warning when the linked service is built, and no sslMode property is written.

Azure Data Factory Linked Services Additional Information​

For additional information on ADF Linked Service types and their connection requirements see the Azure Data Factory Greenplum Connector documentation.