Share via


PostgreSqlV2LinkedService Class

Definition

Linked service for PostgreSQLV2 data source.

[System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.PostgreSqlV2LinkedService+PostgreSqlV2LinkedServiceConverter))]
public class PostgreSqlV2LinkedService : Azure.Analytics.Synapse.Artifacts.Models.LinkedService
[<System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.PostgreSqlV2LinkedService+PostgreSqlV2LinkedServiceConverter))>]
type PostgreSqlV2LinkedService = class
    inherit LinkedService
Public Class PostgreSqlV2LinkedService
Inherits LinkedService
Inheritance
PostgreSqlV2LinkedService
Attributes

Constructors

PostgreSqlV2LinkedService(Object, Object, Object, Object)

Initializes a new instance of PostgreSqlV2LinkedService.

Properties

AdditionalProperties

Additional Properties.

(Inherited from LinkedService)
Annotations

List of tags that can be used for describing the linked service.

(Inherited from LinkedService)
CommandTimeout

The time to wait (in seconds) while trying to execute a command before terminating the attempt and generating an error. Set to zero for infinity. Type: integer.

ConnectionTimeout

The time to wait (in seconds) while trying to establish a connection before terminating the attempt and generating an error. Type: integer.

ConnectVia

The integration runtime reference.

(Inherited from LinkedService)
Database

Database name for connection. Type: string.

Description

Linked service description.

(Inherited from LinkedService)
Encoding

Gets or sets the .NET encoding that will be used to encode/decode PostgreSQL string data. Type: string.

EncryptedCredential

The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string).

LogParameters

When enabled, parameter values are logged when commands are executed. Type: boolean.

Parameters

Parameters for linked service.

(Inherited from LinkedService)
Password

The Azure key vault secret reference of password in connection string. Type: string.

Pooling

Whether connection pooling should be used. Type: boolean.

Port

The port for the connection. Type: integer.

ReadBufferSize

Determines the size of the internal buffer uses when reading. Increasing may improve performance if transferring large values from the database. Type: integer.

Schema

Sets the schema search path. Type: string.

Server

Server name for connection. Type: string.

SslCertificate

Location of a client certificate to be sent to the server. Type: string.

SslKey

Location of a client key for a client certificate to be sent to the server. Type: string.

SslMode

SSL mode for connection. Type: integer. 0: disable, 1:allow, 2: prefer, 3: require, 4: verify-ca, 5: verify-full. Type: integer.

SslPassword

Password for a key for a client certificate. Type: string.

Timezone

Gets or sets the session timezone. Type: string.

TrustServerCertificate

Whether to trust the server certificate without validating it. Type: boolean.

Username

Username for authentication. Type: string.

Applies to