Connector for Teradata Aster — Features and settings

You can connect to and access data from Teradata Aster databases with the connector for Teradata Aster. On this page, you can find information about the capabilities, available settings, and things to keep in mind when you work with data connections to Teradata Aster.

Page content

Connector features

The following functionality is available when you access data with the connector for Teradata Aster.


Feature	Supported?
Load methods	Import (in-memory) External (in-database) On-demand
Custom queries	Yes
Stored procedures	No
Custom connection properties	No
Single sign-on with identity provider	No
Authoring in web client	No
Included in Spotfire distribution on Linux	Yes, if a driver exists

Data source properties

The following are the supported data source properties that you can configure when you create a data connection with the connector for Teradata Aster.


Option	Description
Server	The name of the server where your data is located. To include a port number, add it directly after the name preceded by colon. Example with port number: MyDatabaseServer:1234
Connect	Connects you to the specified server and populates the list of available databases below.
Database	Select the database of interest from the drop-down list.

Supported data types

When you are setting up a connection to an external data source, Spotfire needs to map the data types in the data source to data types in Spotfire. The following are the data types that the Teradata Aster connector supports.


Database data type	Spotfire data type
BYTEA	Binary
BOOL	Boolean
DATE	Date
TIMESTAMP WITH TIME ZONE	DateTime
TIMESTAMP WITHOUT TIME ZONE	DateTime
INTEGER	Integer
SMALLINT	Integer
BIGINT	LongInteger
DOUBLE PRECISION	Real
REAL	SingleReal
BIT	String
CHARACTER	String
INTERVAL	String
IP4	String
IP4RANGE	String
TEXT	String
UNKNOWN	String
UUID	String
VARBIT	String
VARCHAR	String
TIME WITH TIME ZONE	Time
TIME WITHOUT TIME ZONE	Time
NUMERIC	When p <= 9 and s = 0: Integer When 9 < p <= 18 and s = 0: LongInteger Else: Real

Note: User defined data types, including geometry types, are not supported.

Supported functions

Supported functions are the functions that you can use when you work with in-database data tables, for example for calculated columns and custom expressions.

Note: Some supported functions might not be possible to use with your database. This depends on what functions are available in the database, which often differs between database versions and types.

The following are the functions that the Teradata Aster connector supports.


Function type	Functions supported
Date and Time	`Millennium, Century, Decade, Year, Quarter, Month, Week, DayOfWeek, DayOfYear, DayOfMonth, Day, Hour, Minute, Second, MilliSeconds, MicroSeconds, Date_Trunc`
Conversion	`SN`
Math	`Abs, Cbrt, Ceil, Degress, Exp, Floor, Ln, Log, Mod, Pi, Power, Radians, Round, Sign, Sqrt, Trunc, ACos, ASin, ATan, ATan2, Cos, Cot, Sin, Tan`
Operators	`+, -, *, /, %`
Statistical	`Sum, Avg, Min, Max, Count, UniqueCount, Stddev, Stddev_Pop, Stddev_Samp, Variance, Var_Pop, Var_Samp`
Text	`Bit_Length, Char_Length, Lower, Octet_Length, Ascii, Btrim, InitCap, Length, Lpad, Ltrim, Md5, Regexp_Replace, Repeat, Replace, Rpad, Rtrim, Split_part, Strpos, Substr, Translate`

Binning is not supported by this connector.