Supported data sources and fields

Data sources connection is a crucial step in creating topics, and crystal supports many different types of data sources and data fields.

Here is the complete list of them as of today: check it to know if your data source is already supported and remember we are constantly working to enhance our product. Stay tuned to crystal’s upgrades by checking our Release notes section.

crystal Attribute Type List

Type	Notes
Categorical	Used mainly for filter dimensions. crystal will not perform calculation (e.g. Sum or average) on these formats.
Numeric	Used mainly for main entities that need aggregations and numerical filters.
Date & Time	Used for time dimension (filter entity). If not formatted accordingly, crystal will not be able to show data with a time perspective.
Boolean	Used for entities that can assume binary values

Supported formats by data source

PostgreSQL

Type	Format
Categorical	char character varying character text varchar
Numeric	bigint decimal double precision integer money numeric real smallint
Date & Time	date timestamp
Boolean	boolean

MySQL

Type	Format
Categorical	char character varchar tinytext text mediumtext longtext blob enum set
Numeric	tinyint smallint integer int bigint decimal numeric float real double precision double
Date & Time	date time datetime timestamp year
Boolean	boolean

Microsoft SQL Server

Type	Format
Categorical	char varchar text nchar nvarchar ntext uniqueidentifier
Numeric	bigint decimal int money numeric smallint smallmoney tinyint float real
Date & Time	date datetime datetime2 datetimeoffset smalldatetime time
Boolean	bit

Oracle

Type	Format
Categorical	varchar2 nvarchar2 char nchar varchar
Numeric	number float long int decimal real
Date & Time	date timestamp
Boolean	raw

IBM DB2

Type	Format
Categorical	CHAR VARCHAR CLOB BINARY VARBINARY BLOB
Numeric	SMALLINT INTEGER BIGINT DECIMAL REAL DOUBLE DECFLOAT
Date & Time	DATE TIME TIMESTAMP
Boolean	BOOLEAN

Amazon Redshift

Type	Format
Categorical	char nchar bpchar character varchar nvarchar character varying text
Numeric	int2 int int4 int8 numeric float4 float8 float bigint decimal double precision integer numeric real smallint
Date & Time	date timestamp
Boolean	boolean bool

SAP Hana

Type	Format
Categorical	nvarchar varchar shorttext alphanum
Numeric	bigint integer smallint tinyint decimal smalldecimal double real float
Date & Time	date time timestamp seconddate
Boolean	boolean

Azure Synapse

Type	Format
Categorical	char varchar nchar nvarchar
Numeric	bigint decimal int money numeric smallint smallmoney tinyint float real
Date & Time	date datetime datetime2 datetimeoffset smalldatetime time
Boolean	bit

MongoDB

Type	Format
Categorical	string
Numeric	double decimal int long
Date & Time	date timestamp
Boolean	boolean

Google BigQuery

Type	Format
Categorical	string
Numeric	integer float numeric bignumeric
Date & Time	date datetime
Boolean	boolean

We hope this article was helpful! Check out Data preparation: what you need to know to get the best out of crystal for more information on how to handle your data.