Element Details: Connection.Vertica
 Back


Available in: Logi Info Source code name: Connection.Vertica

The Connection.Vertica element sets the parameters required to connect to a Vertica data source.

In order to use this element you must have installed the .Net Vertica data provider. Version 7.2.3 of the Vertica data provider is available in rdTemplate/rdDriver/Vertica for both DotNet and Java. If you wish to use a different version then the data provider is typically included on your Vertica CD or can be downloaded from the HP Vertica web site.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
CommandTimeOut
UserDefined
The CommandTimeOut attribute specifies the amount of time, in seconds, before the request to connect to the data source is presumed to have failed. For most data sources, the default value is 60 seconds. For MySql, the default is 30 seconds.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
VerticaBackupServer
UserDefined
A string containing the host name or IP address of one or more alternative Vertica servers to connect to if the primary Vertica server connection fails. Multiple servers may be specified. Separate them with commas. The host name or IP address can also include a colon followed by the port number for the database. The default port is 5433.
VerticaConnectionString
UserDefined
A full JDBC connection string to the Vertica database. If a value is defined, it will override all other settings for the connection element and use this string to connect to the database. Vertica Server Parameter elements are still processed and added to the string.
VerticaDatabase
UserDefined
(Required) The name of the Vertica database.
VerticaLoadBalance
True
False
A Boolean indicating whether the client is willing to have its connection redirected to another host in the HP Vertica database. This setting only has an effect if the server has also enabled connection load balancing. The default is False if not specified.
VerticaPassword
UserDefined
The password for the Vertica database.
VerticaPort
UserDefined
The port address of the Vertica database. Defaults to port 5433.
VerticaServer
UserDefined
(Required) The host name of the Vertica database server.
VerticaSSL
True
False
A boolean value, whether to use SSL for the Vertica connection.
VerticaUser
UserDefined
The user name for the Vertica database.



PARENT ELEMENTS

Click element to drill down for more information.

Connections Studio Connection


CHILD ELEMENTS

Click element to drill down for more information.

Logi Application Service Jdbc Params
Metadata
Studio Connection Vertica Parameters


 Back to top


 Chart Debug