PostgreSQL

AllowDateTimeOffset

Determines whether to use the DateTimeOffset type instead of DateTime when a timestamptz value is returned.

ApplicationName

The name of the application, associated with the connection string.

Character Set

A character set used by the client. Actually, if this property is enabled, then the "SET NAMES <Charset>" query is executed on establishing a connection. Default value is an empty string. That means there is no action performed with charset on the client and on the server.

Connection Lifetime

When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by Connection Lifetime. The default value is 0.

Connection Timeout

The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. The default value is 15.

Database

The name of the PostgreSQL database you want to connect to.

Default Command Timeout

The default time in seconds to wait while trying to execute a command before terminating the attempt and generating an error. 0 indicates no limit.

Default FetchAll

This parameter is ignored. Do not use this parameter.

Enlist

Determines whether the connection is automatically enlisted in the current distributed transaction. The default value is true.

Force IPv4

Determines whether authentication by an IPv6 address can be used, or an IPv4 address must always be used for authentication.

Host

The name or IP address of host of the PostgreSQL database to which to connect.

Ignore Unnamed Parameters

Determines whether to treat the '?' character in the command text as an unnamed parameter.

Initial Schema

The name of the schema to be used once a connection is opened. You can change it later if you need. By default it is schema 'Public'.

Integrated Security

Determines whether to use a secure authentication with single sign-on (GSSAPI or SSPI, depending on the server).

Join Statement Notices

Determines whether all the notices, raised during the statement execution, will be returned together in one InfoMessage event after the statement execution, or each notice will be returned as a separate InfoMessage event.

Keep Alive

Specifies whether to send TCP keep-alive packets and the interval at which they are sent in seconds. Default value is 0, which means that the packets are not sent.

Max Pool Size

The maximum number of connections allowed in the pool. Setting the Max Pool Size value in the connection string can affect performance. The default value is 100.

Min Pool Size

The minimum number of connections allowed in the pool. The default value is 0.

Password

The password to login with.

Persist Security Info

Indicates if security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state.

Pooling

If true, by default, the connection is drawn from the appropriate pool or is created and added to the appropriate pool.

Port

PostgreSQL connection port; default value is 5432.

Protocol

The Frontend/Backend Protocol version. Available values are Ver20 and Ver30. Set the parameter to Ver20 for the protocol version 2.0 or to Ver30 for protocol version 3.0.

Proxy Host

The host name or IP address of proxy server.

Proxy Password

The password for the proxy server account.

Proxy Port

The port number of the proxy server. The default value is 3128.

Proxy User

The proxy server account name.

SSH Authentication Type

Client's SSH authentication methods.

SSH Cipher List

The list of ciphers that client agrees to use, separated by colons. Two modes of block ciphering are supported: Cipher-block chaining (CBC) and Counter (CTR).

The following ciphers are available for SSH connections in the CBC mode:

 
In the CTR mode the AES ciphers are used.

You can use ALL keyword to indicate whole set of ciphers. To exclude certain cipher from the set use "-" sign. For instance, the value of CipherList parameter "ALL-Blowfish" means that any cipher but Blowfish can be used.

SSH Host

The name or IP address of the SSH server.

SSH Host Key

The location of the public key on the client side to verify the server host key during establishing connection. OpenSSH or IETF SECSH key files are supported. You may use such utilities as 'ssh-keygen.exe' or 'puttygen.exe' for generation of the corresponding public/private key pair.

SSH Passphrase

The client key passphrase.

SSH Password

The user password on the SSH server.

SSH Port

The number of port on SSH server to connect.

SSH Private Key

The location of the client private key.

SSH Strict Host Key Check

Indicates whether the host key is verified during establishing connection.

SSH User

The user id on the SSH server.

SSL CA Cert

The location of the authority SSL certificate.

SSL Cert

The location of the client SSL certificate.

SSL Cipher List

The list of ciphers that client agrees to use.

SSL Key

The location of the user's private key.

SSL TLS Protocol

The preferred TLS protocol version, reported to the server when establishing a secure connection.

SSLMode

SSL connection priority. May be Disable, Allow, Prefer, and Require. The default value is Disable, which means that only an unencrypted SSL connection will be attempted.

Transaction Error Behavior

Determines how the driver handles errors that occur within a transaction.

Transaction Scope Local

If there are several connections with the same connection string (which includes "Transaction Scope Local=true;") within a scope of TransactionScope, Devart SSIS Data Flow Components will use only one connection internally. The default value is false.

Unicode

If true, by default, sets client charset to UTF8 and converts client data according to this charset.

UnpreparedExecute

If true, unprepared execute mode is used by default.

User ID

The user name to login with.

Validate Connection

Specifies whether to validate connections that are being got from the pool.