EN
Search…
⌃K

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.
If you have any questions about crystal’s features, you have encountered a problem or you would like to share your feedback, contact us using this form.