Class TeradataDatasourceConnection

Namespace: YndigoBlue.Velocity.Data.Teradata

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.

Default port: 1025

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

Integrated security / LDAP / Kerberos:

Set UseIntegratedSecurity to true to use enterprise authentication instead of a username and password. The AuthenticationMethod property controls which mechanism is used:

Ldap (default) — AuthenticationMechanism=LDAP. Delegates authentication to the LDAP/Active Directory server configured on the Teradata Gateway.
Spnego — IntegratedSecurity=true. Uses TeraGSS to auto-select the highest-ranked SPNEGO/Kerberos mechanism. Requires a valid Kerberos TGT on the client machine.
Tdnego — AuthenticationMechanism=TDNEGO. Lets the Teradata server negotiate the authentication mechanism.

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(): Initializes a new TeradataDatasourceConnection with default configuration.

Properties

AuthenticationMethod: Gets or sets the Teradata authentication mechanism used when UseIntegratedSecurity is true.

DatasourceType: Gets the datasource type for Teradata.

FullTextSearchClobs: Gets or sets whether full-text search indexes support CLOB (Character Large Object) columns.

FullTextSearchEnabled: Gets or sets whether full-text search is enabled for the connection.

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

ImportCastClob: Gets or sets whether CLOB columns are converted to VARCHAR before import operations.

ImportCastGeo: Gets or sets whether geospatial columns are converted to VARCHAR before import operations.

NumberOfStagingTables: Gets or sets the number of staging tables used during import operations.

PermanentSpace: Gets or sets the maximum permanent space in bytes allocated to a schema when it is created.

SelectCastClob: Gets or sets whether CLOB columns are converted to VARCHAR before retrieval and export operations.

SessionCharacterSet: Gets or sets the session character set for the Teradata connection.

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.