Package version:

Interface PostgreSqlV2LinkedService

Linked service for PostgreSQLV2 data source.

interface PostgreSqlV2LinkedService {
    annotations?: any[];
    authenticationType: any;
    commandTimeout?: any;
    connectionTimeout?: any;
    connectVia?: IntegrationRuntimeReference;
    database: any;
    description?: string;
    encoding?: any;
    encryptedCredential?: string;
    logParameters?: any;
    parameters?: {
        [propertyName: string]: ParameterSpecification;
    };
    password?: AzureKeyVaultSecretReference;
    pooling?: any;
    port?: any;
    readBufferSize?: any;
    schema?: any;
    server: any;
    sslCertificate?: any;
    sslKey?: any;
    sslMode: any;
    sslPassword?: any;
    timezone?: any;
    trustServerCertificate?: any;
    type: "PostgreSqlV2";
    username: any;
    version?: string;
}

Hierarchy (view full)

Properties

annotations? authenticationType commandTimeout? connectionTimeout? connectVia? database description? encoding? encryptedCredential? logParameters? parameters? password? pooling? port? readBufferSize? schema? server sslCertificate? sslKey? sslMode sslPassword? timezone? trustServerCertificate? type username version?

Properties

Optionalannotations

annotations?: any[]

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

authenticationType

authenticationType: any

The authentication type to use. Type: string.

OptionalcommandTimeout

commandTimeout?: any

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.

OptionalconnectionTimeout

connectionTimeout?: any

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

OptionalconnectVia

connectVia?: IntegrationRuntimeReference

The integration runtime reference.

database

database: any

Database name for connection. Type: string.

Optionaldescription

description?: string

Linked service description.

Optionalencoding

encoding?: any

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

OptionalencryptedCredential

encryptedCredential?: string

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

OptionallogParameters

logParameters?: any

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

Optionalparameters

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

Parameters for linked service.

Optionalpassword

password?: AzureKeyVaultSecretReference

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

Optionalpooling

pooling?: any

Whether connection pooling should be used. Type: boolean.

Optionalport

port?: any

The port for the connection. Type: integer.

OptionalreadBufferSize

readBufferSize?: any

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

Optionalschema

schema?: any

Sets the schema search path. Type: string.

server

server: any

Server name for connection. Type: string.

OptionalsslCertificate

sslCertificate?: any

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

OptionalsslKey

sslKey?: any

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

sslMode

sslMode: any

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

OptionalsslPassword

sslPassword?: any

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

Optionaltimezone

timezone?: any

Gets or sets the session timezone. Type: string.

OptionaltrustServerCertificate

trustServerCertificate?: any

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

type

type

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

username

username: any

Username for authentication. Type: string.

Optionalversion

version?: string

Version of the linked service.

Settings

Member Visibility