Home PageDataWorksDeveloper ReferenceAppendixData source connection information (ConnectionProperties)Vertica
Search for Help Content

Vertica

Updated at: 2024-11-07 02:09
Product
Community

Property definition

  • Data source type: vertica

  • Supported configuration mode (ConnectionPropertiesMode): Connection string mode (UrlMode)

Connection string mode

Parameter

Type

Example

Required

Description

Parameter

Type

Example

Required

Description

address

JSON Array

 
[
    {
        "host": "127.0.0.1",
        "port": 3306
    }
]

Yes

The address, which is configured in the JSON array format but contains only a single pair of host and port.

database

String

mysql_database

Yes

The name of the database.

username

String

xxxxx

Yes

The username.

password

String

xxxxx

Yes

The password.

properties

JSON Object

 
{
    "useSSL": "false"
}

No

The properties of the driver.

envType

String

Dev

Yes

The information about the data source environment. Valid values:

  • Dev: The development environment.

  • Prod: The production environment.

Configuration examples

Connection string mode

{
    "address": [
        {
            "host": "127.0.0.1",
            "port": 5432
        }
    ],
    "database": "db",
    "properties": {
        "connectTimeout": "2000"
    },
    "username": "xxxxx",
    "password": "xxxxx",
    "envType": "Dev"
}
Previous: TablestoreNext: Support
  • On this page （1, T）
  • Property definition
  • Connection string mode
  • Configuration examples
  • Connection string mode
Feedback
phone Contact Us

Chat now with Alibaba Cloud Customer Service to assist you in finding the right products and services to meet your needs.

alicare alicarealicarealicare