Name of the connection.

Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,

Maximum length is 255 characters.

Description of the connection. Maximum length is 4000 characters.

Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.

This property appears only if secrets manager is set up for your organization.

This property is not supported by

Data Ingestion and Replication

and the

Data Access Management

services.

When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.

For information about how to configure and use a secrets manager, see

"Secrets manager configuration" in the Administrator help

.

In

Data Ingestion and Replication

, you cannot run a

streaming ingestion and replication

task on a Hosted Agent, serverless runtime environment, or elastic runtime environment.

Name of the JDBC driver class.

For example, to connect to Aurora PostgreSQL, specify the following driver class name: org.postgresql.Driver

For more information about which driver class to use with specific databases, see the corresponding third-party vendor documentation.

Connection string to connect to the database.

Use the following format to specify the connection string:

jdbc:<subprotocol>:<subname>

For example, the connection string for the Aurora PostgreSQL database type is

jdbc:postgresql://<host>:<port>[/dbname]

.

For more information about the connection string to use with specific drivers, see the corresponding third-party vendor documentation.

Select one of the following database types:

PostgreSQL. Connect to the Aurora PostgreSQL database hosted in the Amazon Web Services or the Microsoft Azure environment.
Azure SQL Database. Connect to Azure SQL Database hosted in the Microsoft Azure environment.
Others. Connect to any database that supports the Type 4 JDBC driver, such as Salesforce Data Cloud.

Default is Others.

If you don't specify the schema name, all the schemas available in the database are listed.

To read from

or write to

Oracle public synonyms, enter PUBLIC.

For example, you can enter this statement to set the time zone:

Specify the part of the connection string that you want to mask.

When you create a connection, the string you enter in this field appends to the string that you specified in the

Connection String

field.

When disabled, the driver does not support connections to automatically commit data even if the auto-commit mode is enabled in the JDBC driver.

Default is disabled.

When enabled, the Secure Agent encloses all identifiers within the character selected for the SQL Identifier Character property.

Default is disabled.

Select

None

if the database uses regular identifiers. When the Secure Agent generates SQL queries, it does not place delimited characters around any identifiers.

Select a character from the list based on what delimiter the database uses for identifiers. When the Secure Agent generates SQL queries, it encloses delimited identifiers within this character.