DBAppender Connection Options for Teradata

The following is an example of the basic syntax for specifying options in the ConnectionString parameter of a DBAppender configuration for a Teradata database. If you need additional details, contact SAS Technical Support.

Valid in:	ConnectionString parameter of DBAppender configuration
Note:	To set up the connection, you must run the Teradata TTU.exe client.
See:	DBAppender

Table of Contents

Syntax

CATALOG=catalog-identifier;
DATABASE=database-name;
DRIVER=TERADATA;
PASSWORD=password;
SERVER=Teradata-server-identifier;
USER=user-id;

Syntax Description

The data source connection options for a Teradata database include the following:

CATALOG=catalog-identifier;

specifies an arbitrary identifier for an SQL catalog, which groups logically related schemas. Any identifier is valid (for example, catalog=tera).

Requirement

You must specify a catalog.

DATABASE=database-name;: specifies the Teradata database. If this option is not specified, a connection will be made to the default Teradata database for the user ID that is associated with the process. If the database name contains spaces or non-alphanumeric characters, you must enclose it in quotation marks.

DRIVER=TERADATA;

identifies the data source to which you want to connect, which is a Teradata database.

Requirement

You must specify the driver.

PASSWORD=password;

specifies a Teradata password. The password that you specify must be correct for your USER= value.

Alias	PWD=
Requirement	You must specify the PASSWORD= option.

SERVER=Teradata-server-identifier;: specifies the Teradata server identifier.

USER=user-id;

specifies a Teradata user ID. If the user ID contains blanks or national characters, enclose it in quotation marks.

Alias	UID=
Requirement	You must specify the USER= option.

Example: Connection String for Teradata

DRIVER=TERADATA;UID=User1;PWD=Password1;server=dbc;database=mydatabase;CATALOG=X;