SAP IQ

SAP IQ
Database background

SAP IQ (also known as Sybase IQ) is a columnar, petabyte-scale relational database system designed for business intelligence, data warehousing, and data mart environments.

SAP IQ achieves its performance through a columnar data engine, similar to many modern analytical database solutions.

SAP IQ data types we support

Integral:
bigintint (integer)smallinttinyintunsigned bigintunsigned int
Decimal:
decimal (numeric)doublefloatmoneyrealsmallmoney
Text:
charlong varchar (clob, text)varchar
Binary:
binarybitvarbinary
Date/Time:
datetimetimestamp (datetime, smalldatetime)
Large objects:
long binary (blob, image)long varchar (clob, text)
Other:
uniqueidentifier