Class TeradataDatasourceConnection
- Namespace
- YndigoBlue.Velocity.Connections
- Assembly
- YndigoBlue.Velocity.dll
Connection configuration for Teradata Vantage databases.
public class TeradataDatasourceConnection : DatasourceConnection, IDatasourceConnection- Inheritance
-
TeradataDatasourceConnection
- Implements
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
}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.
Properties
- AutoCastClobsOnSelect
Gets or sets whether to automatically cast CLOB columns to VARCHAR on SELECT. Default is false.
- ClobAutoCastVarCharSize
Gets or sets the VARCHAR size when auto-casting CLOBs. Default is 30000.
- DatasourceType
Gets the datasource type for Teradata.
- IdentityStartValue
Gets or sets the starting value for identity columns. Default is 1.
- ImportVarCharSize
Gets or sets the VARCHAR size for imported text columns. Default is 1000.
- NumberOfStagingTables
Gets or sets the number of staging tables for import operations. Default is 10.
- PermanentSpace
Gets or sets the permanent space allocation in bytes for database objects. Default is 100000000 (100MB).
- ReservedSettings
Gets the reserved connection string settings that are handled by named properties.
- SessionCharacterSet
Gets or sets the session character set. Default is "UTF8".
- SourceSpatialReference
Gets or sets the source spatial reference system for coordinate transformations.
- TargetSpatialReference
Gets or sets the target spatial reference system for coordinate transformations.
- UseConcurrentImport
Gets or sets whether to use concurrent import for bulk loads. Default is false.