PostgreSqlV2LinkedService interface

Linked service for PostgreSQLV2 data source.

Extends

Properties

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.

database

Database name for connection. Type: string.

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.

logParameters

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

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.

type

Polymorphic discriminator, which specifies the different types this object can be

username

Username for authentication. Type: string.

Inherited Properties

annotations

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

connectVia

The integration runtime reference.

description

Linked service description.

parameters

Parameters for linked service.

version

Version of the linked service.

Property Details

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.

commandTimeout?: any

Property Value

any

connectionTimeout

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

connectionTimeout?: any

Property Value

any

database

Database name for connection. Type: string.

database: any

Property Value

any

encoding

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

encoding?: any

Property Value

any

encryptedCredential

The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string.

encryptedCredential?: string

Property Value

string

logParameters

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

logParameters?: any

Property Value

any

password

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

password?: AzureKeyVaultSecretReference

Property Value

pooling

Whether connection pooling should be used. Type: boolean.

pooling?: any

Property Value

any

port

The port for the connection. Type: integer.

port?: any

Property Value

any

readBufferSize

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

readBufferSize?: any

Property Value

any

schema

Sets the schema search path. Type: string.

schema?: any

Property Value

any

server

Server name for connection. Type: string.

server: any

Property Value

any

sslCertificate

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

sslCertificate?: any

Property Value

any

sslKey

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

sslKey?: any

Property Value

any

sslMode

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

sslMode: any

Property Value

any

sslPassword

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

sslPassword?: any

Property Value

any

timezone

Gets or sets the session timezone. Type: string.

timezone?: any

Property Value

any

trustServerCertificate

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

trustServerCertificate?: any

Property Value

any

type

Polymorphic discriminator, which specifies the different types this object can be

type: "PostgreSqlV2"

Property Value

"PostgreSqlV2"

username

Username for authentication. Type: string.

username: any

Property Value

any

Inherited Property Details

annotations

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

annotations?: any[]

Property Value

any[]

Inherited From LinkedService.annotations

connectVia

The integration runtime reference.

connectVia?: IntegrationRuntimeReference

Property Value

Inherited From LinkedService.connectVia

description

Linked service description.

description?: string

Property Value

string

Inherited From LinkedService.description

parameters

Parameters for linked service.

parameters?: {[propertyName: string]: ParameterSpecification}

Property Value

{[propertyName: string]: ParameterSpecification}

Inherited From LinkedService.parameters

version

Version of the linked service.

version?: string

Property Value

string

Inherited From LinkedService.version