Name of the connection. The name is not case sensitive and must be unique within the domain. The name cannot exceed 128 characters, contain spaces, or contain the following special characters:

~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /

String that the Data Integration Service uses to identify the connection. The ID is not case sensitive. It must be 255 characters or less and must be unique in the domain. You cannot change this property after you create the connection. Default value is the connection name.

<data source name>

The Data Integration Service runs the connection environment SQL each time it connects to the database.

The Data Integration Service runs the transaction environment SQL at the beginning of each transaction.

Type of character that the database uses to enclose delimited identifiers in SQL queries. The available characters depend on the database type.

Select (None) if the database uses regular identifiers.

When the Data Integration Service generates SQL queries, the service does not place delimited characters around any identifiers.

Select a character if the database uses delimited identifiers.

When the Data Integration Service generates SQL queries, the service encloses delimited identifiers within this character.

Enable if the database uses case-sensitive identifiers.

When enabled, the Data Integration Service encloses all identifiers within the character selected for the

SQL Identifier Character

property.

When the

SQL Identifier Character

property is set to none, the

Support Mixed-case Identifiers

property is disabled.

For pushdown optimization, specify the database type to enable the Data Integration Service to generate native database SQL.

The options are:

Other
Sybase
Microsoft_SQL_Server
Snowflake

Default is Other.