Class TeradataDatasourceConnection

Namespace: YndigoBlue.Velocity.Connections

Assembly: YndigoBlue.Velocity.dll

Connection configuration for Teradata Vantage databases.

public class TeradataDatasourceConnection : DatasourceConnection, IDatasourceConnection

Inheritance: object

DatasourceConnection

TeradataDatasourceConnection

Implements: IDatasourceConnection

Remarks

Warning

Teradata database support is not available in the Community Edition of Velocity. It requires the Full Edition.

Supports Teradata Vantage 17.0 and later versions.

Default port: 1025

Includes extensive support for data warehousing features, spatial transformations, and bulk import operations.

Examples

// Connect to Teradata with standard configuration
var conn = new TeradataDatasourceConnection
{
    Hostname = "localhost",
    Port = 1025,
    Database = "DBC",
    Username = "dbc",
    Password = "dbc"
};

using (var m = new Manager(conn))
{
    var schema = m.LoadSchema("myschema");
    // Perform database operations
}

Constructors

TeradataDatasourceConnection()

Properties

DatasourceType: Gets the datasource type for Teradata.

FullTextSearchClobs: Gets or sets whether full-text search indexing supports CLOBs. If set to true then full text indexes will be built to support CLOBs, which is significantly slower at time of index. If set to false then CLOBs will be truncated at 32,0000 characters but indexing will be significantly faster. Default is false.

FullTextSearchEnabled: Gets or sets whether full-text search is enabled for the connection. When enabled, Velocity will support full-text indexes and full text searching. Default is false.

IdentityStartValue: Gets or sets the starting value for identity columns. Default is 1.

ImportCastClob: Gets or sets whether Clob types are converted to VarChar before being imported. Performance is much improved if set to true but the size of Clob columns are limited to the value of VarCharCastSize, which has a maximum size of 32,000 characters. Default is true.

ImportCastGeo: Gets or sets whether Geospatial types are converted to VarChar before being imported. Performance is much improved if set to true but the size of Well-Known Text geometry columns are limited to the value of VarCharCastSize, which has a maximum size of 32,000 characters. Default is true.

NumberOfStagingTables: Gets or sets the number of staging tables for import operations. Default is 4.

PermanentSpace: Gets or sets the permanent space allocation in bytes for database objects. Default is 100000000 (100MB).

SelectCastClob: Gets or sets whether Clob types are converted to VarChar before being added to a select statement. Performance is much improved if set to true but the size of Clob columns are limited to the value of VarCharCastSize, which has a maximum size of 32,000 characters. Applies to Retrieve, Search and Export. Default is true.

SessionCharacterSet: Gets or sets the session character set. Default is "UTF8".

SourceSpatialReference: Gets or sets the source spatial reference system (SRS) in Well-Known Text (WKT) format for coordinate transformations.

TargetSpatialReference: Gets or sets the target spatial reference system (SRS) in Well-Known Text (WKT) format for coordinate transformations.

VarCharCastSize: Gets or sets the VARCHAR size for Clob and Geospatial columns that are cast to VARCHARs when importing, exporting and searching. Default is 32000.