Teradata

Teradata version

Teradata <version number>

The version of your Teradata client. This is the version of Teradata that the datastore accesses.

Use Data Source (ODBC)

Yes

No

Select to use a DSN to connect to the database.

By default, this option is set to Yes. To use a DSN connection, you must also specify the ODBC data source name.

If you set this option to No, you must also specify the Database server name, Database name, and Port number for a DSN-less connection.

ODBC data source name

Refer to the requirements of your database

The ODBC data source name (DSN) defined for connecting to your database.

This option is required if Use Data Source (ODBC) is set to Yes.

Database server name

Refer to the requirements of your database

The Teradata database server name.

This option is required if Use Data Source (ODBC) is set to No.

Database name

Refer to the requirements of your database

The name of the database defined in Teradata.

This option is required if Use Data Source (ODBC) is set to No.

Port number

Integer

Default: 8888

The number of the database port.

This option is required if Use Data Source (ODBC) is set to No.

User name

Alphanumeric characters and underscores

The user name of the account through which the software accesses the database.

Password

Alphanumeric characters, underscores, and punctuation

The password of the account through which the software accesses the database.

Rows per commit

Positive integer

Default: 1000

Enter the maximum number of rows loaded to a target table before saving the data. This value is the default commit size for target tables in this datastore. You can overwrite this value for individual target tables.

Overflow file directory

Directory path

Enter the location of overflow files written by target tables in this datastore.

You can enter a variable for this option.

Language

SAP-supported ISO three-letter language codes or <default>

Select the language from the possible values in the drop-down list. The <default> option sets the language to the system language of the SAP Data Services Agent host system.

Code page

-

Specify the character encoding of character data in the datastore.

Server code page

-

Specify the character encoding of character data in the datastore.

Log directory

Directory path

The directory in which to write log files.

Additional session parameters

A valid SQL statement or multiple SQL statements delimited by semicolon

A valid SQL statement or multiple SQL statements delimitated by semicolon.

Aliases

-

Enter the alias name and the owner name to which the alias name maps.