Class PostgreSqlV2LinkedService

Linked service for PostgreSQLV2 data source.

Inheritance
System.Object
LinkedService
PostgreSqlV2LinkedService
Inherited Members
Namespace: System.Dynamic.ExpandoObject
Assembly: Azure.Analytics.Synapse.Artifacts.dll
Syntax
[System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.PostgreSqlV2LinkedService/PostgreSqlV2LinkedServiceConverter))]
public class PostgreSqlV2LinkedService : Azure.Analytics.Synapse.Artifacts.Models.LinkedService

Constructors

PostgreSqlV2LinkedService(Object, Object, Object, Object, Object)

Initializes a new instance of PostgreSqlV2LinkedService.

Declaration
public PostgreSqlV2LinkedService (object server, object username, object database, object authenticationType, object sslMode);
Parameters
System.Object server

Server name for connection. Type: string.
System.Object username

Username for authentication. Type: string.
System.Object database

Database name for connection. Type: string.
System.Object authenticationType

The authentication type to use. Type: string.
System.Object sslMode

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

server, username, database, authenticationType or sslMode is null.

Properties

AuthenticationType

The authentication type to use. Type: string.

Declaration
public object AuthenticationType { get; set; }
Property Value
System.Object

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.

Declaration
public object CommandTimeout { get; set; }
Property Value
System.Object

ConnectionTimeout

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

Declaration
public object ConnectionTimeout { get; set; }
Property Value
System.Object

Database

Database name for connection. Type: string.

Declaration
public object Database { get; set; }
Property Value
System.Object

Encoding

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

Declaration
public object Encoding { get; set; }
Property Value
System.Object

EncryptedCredential

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

Declaration
public object EncryptedCredential { get; set; }
Property Value
System.Object

LogParameters

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

Declaration
public object LogParameters { get; set; }
Property Value
System.Object

Password

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

Declaration
public Azure.Analytics.Synapse.Artifacts.Models.AzureKeyVaultSecretReference Password { get; set; }
Property Value
AzureKeyVaultSecretReference

Pooling

Whether connection pooling should be used. Type: boolean.

Declaration
public object Pooling { get; set; }
Property Value
System.Object

Port

The port for the connection. Type: integer.

Declaration
public object Port { get; set; }
Property Value
System.Object

ReadBufferSize

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

Declaration
public object ReadBufferSize { get; set; }
Property Value
System.Object

Schema

Sets the schema search path. Type: string.

Declaration
public object Schema { get; set; }
Property Value
System.Object

Server

Server name for connection. Type: string.

Declaration
public object Server { get; set; }
Property Value
System.Object

SslCertificate

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

Declaration
public object SslCertificate { get; set; }
Property Value
System.Object

SslKey

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

Declaration
public object SslKey { get; set; }
Property Value
System.Object

SslMode

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

Declaration
public object SslMode { get; set; }
Property Value
System.Object

SslPassword

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

Declaration
public object SslPassword { get; set; }
Property Value
System.Object

Timezone

Gets or sets the session timezone. Type: string.

Declaration
public object Timezone { get; set; }
Property Value
System.Object

TrustServerCertificate

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

Declaration
public object TrustServerCertificate { get; set; }
Property Value
System.Object

Username

Username for authentication. Type: string.

Declaration
public object Username { get; set; }
Property Value
System.Object