Currently MicroStrategy supports 24 out of 41 data types which is 55% of the data types in SQL server.
Supported data types:
Teradata Data type | MicroStrategy Datatype |
DATE | DATE |
TIME | TIME(6) |
TIMESTAMP | TIMESTAMP(7) |
SMALLINT | INTEGER(5) |
BIGINT | BIGINT(19) |
INTEGER | INTEGER(10) |
BIGINT | INTEGER(19) |
DECIMAL (n,m) | DECIMAL(10,10) |
REAL | REAL |
DOUBLE | DOUBLE |
FLOAT | DOUBLE |
VARCHAR(n) | VARCHAR(n) |
BLOB (n) | Long VarBin(0) |
CLOB (n) | Long VarChar(0) |
Starting with Teradata 14.0, there is a NUMBER (n,m) datatype.
Unsupported data types:
- BYTE(n), BYTEINT, CHARACTER(n), VARBYTE(n), UDT, INTERVAL and ARRAY
- JSON, XML, Time with Time Zone, Timestamp with Time Zone, ST_Geometry, CLOB, BLOB, Graphic, VarGraphic, MBR (minimum bounding rectangle), MBB (Minimum bounding box ) , Interval Data To Second, Interval Year to Month
