Partager via


PostgreSqlV2LinkedService Class

Definition

Linked service for PostgreSQLV2 data source.

public class PostgreSqlV2LinkedService : Azure.ResourceManager.DataFactory.Models.DataFactoryLinkedServiceProperties, System.ClientModel.Primitives.IJsonModel<Azure.ResourceManager.DataFactory.Models.PostgreSqlV2LinkedService>, System.ClientModel.Primitives.IPersistableModel<Azure.ResourceManager.DataFactory.Models.PostgreSqlV2LinkedService>
type PostgreSqlV2LinkedService = class
    inherit DataFactoryLinkedServiceProperties
    interface IJsonModel<PostgreSqlV2LinkedService>
    interface IPersistableModel<PostgreSqlV2LinkedService>
Public Class PostgreSqlV2LinkedService
Inherits DataFactoryLinkedServiceProperties
Implements IJsonModel(Of PostgreSqlV2LinkedService), IPersistableModel(Of PostgreSqlV2LinkedService)
Inheritance
PostgreSqlV2LinkedService
Implements

Constructors

PostgreSqlV2LinkedService(DataFactoryElement<String>, DataFactoryElement<String>, DataFactoryElement<String>, DataFactoryElement<String>, DataFactoryElement<Int32>)

Initializes a new instance of PostgreSqlV2LinkedService.

Properties

AdditionalProperties

Additional Properties

To assign an object to the value of this property use FromObjectAsJson<T>(T, JsonSerializerOptions).

To assign an already formatted json string to this property use FromString(String).

Examples:

  • BinaryData.FromObjectAsJson("foo"): Creates a payload of "foo".
  • BinaryData.FromString("\"foo\""): Creates a payload of "foo".
  • BinaryData.FromObjectAsJson(new { key = "value" }): Creates a payload of { "key": "value" }.
  • BinaryData.FromString("{\"key\": \"value\"}"): Creates a payload of { "key": "value" }.

(Inherited from DataFactoryLinkedServiceProperties)
Annotations

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

To assign an object to the element of this property use FromObjectAsJson<T>(T, JsonSerializerOptions).

To assign an already formatted json string to this property use FromString(String).

Examples:

  • BinaryData.FromObjectAsJson("foo"): Creates a payload of "foo".
  • BinaryData.FromString("\"foo\""): Creates a payload of "foo".
  • BinaryData.FromObjectAsJson(new { key = "value" }): Creates a payload of { "key": "value" }.
  • BinaryData.FromString("{\"key\": \"value\"}"): Creates a payload of { "key": "value" }.

(Inherited from DataFactoryLinkedServiceProperties)
AuthenticationType

The authentication type to use. Type: string.

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 DataFactoryLinkedServiceProperties)
Database

Database name for connection. Type: string.

Description

Linked service description.

(Inherited from DataFactoryLinkedServiceProperties)
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.

LinkedServiceVersion

Version of the linked service.

(Inherited from DataFactoryLinkedServiceProperties)
LogParameters

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

Parameters

Parameters for linked service.

(Inherited from DataFactoryLinkedServiceProperties)
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.

Methods

JsonModelWriteCore(Utf8JsonWriter, ModelReaderWriterOptions)

Explicit Interface Implementations

IJsonModel<DataFactoryLinkedServiceProperties>.Create(Utf8JsonReader, ModelReaderWriterOptions)

Reads one JSON value (including objects or arrays) from the provided reader and converts it to a model.

(Inherited from DataFactoryLinkedServiceProperties)
IJsonModel<DataFactoryLinkedServiceProperties>.Write(Utf8JsonWriter, ModelReaderWriterOptions)

Writes the model to the provided Utf8JsonWriter.

(Inherited from DataFactoryLinkedServiceProperties)
IJsonModel<PostgreSqlV2LinkedService>.Create(Utf8JsonReader, ModelReaderWriterOptions)

Reads one JSON value (including objects or arrays) from the provided reader and converts it to a model.

IJsonModel<PostgreSqlV2LinkedService>.Write(Utf8JsonWriter, ModelReaderWriterOptions)

Writes the model to the provided Utf8JsonWriter.

IPersistableModel<DataFactoryLinkedServiceProperties>.Create(BinaryData, ModelReaderWriterOptions)

Converts the provided BinaryData into a model.

(Inherited from DataFactoryLinkedServiceProperties)
IPersistableModel<DataFactoryLinkedServiceProperties>.GetFormatFromOptions(ModelReaderWriterOptions)

Gets the data interchange format (JSON, Xml, etc) that the model uses when communicating with the service.

(Inherited from DataFactoryLinkedServiceProperties)
IPersistableModel<DataFactoryLinkedServiceProperties>.Write(ModelReaderWriterOptions)

Writes the model into a BinaryData.

(Inherited from DataFactoryLinkedServiceProperties)
IPersistableModel<PostgreSqlV2LinkedService>.Create(BinaryData, ModelReaderWriterOptions)

Converts the provided BinaryData into a model.

IPersistableModel<PostgreSqlV2LinkedService>.GetFormatFromOptions(ModelReaderWriterOptions)

Gets the data interchange format (JSON, Xml, etc) that the model uses when communicating with the service.

IPersistableModel<PostgreSqlV2LinkedService>.Write(ModelReaderWriterOptions)

Writes the model into a BinaryData.

Applies to