Databases

Scai connects to multiple SQL databases seamlessly with a click of a button. Below, you can find all the versions and the supported data types that Scai supports.

Supported databases

Database nameSupported db versionsRemarks
MySQL5.5, 5.6cannot save views/reports that contain subqueries
MySQL5.7-
MySQL8Needs an additional connector to be installed
SqlServer2012- 2017-latest-
PostGreSQL9.2-9.6, 10-
H2SQL1.4.196 +-

Supported data types

One of the advantages of using Scai is the fact that it automatically detects the data types, which makes it easy to connect and explore the data. Each of the supported databases has its own particularity and its own restrictions. We will try to document as follows, some of the data types that Scai does not support or where it makes appropriate conversions.

Legend

the data type is supported by Scai and within the particular database

the data type is not supported by Scai

the data type is not supported in the particular SQL database

Data typeMySQLPostGreSQLSqlServerH2
bigint
bigserial
bit
bool
boolean
box
bpchar
char
character
cidr
circle
clob
date
datetime
dec
decimal
double
enum
fixed unsigned
float
geometry
geometrycollection
identity
int
integer
json
linestring
longtext
longvarchar
lseg
macaddr
mediumint
mediumtext
money
multilinestring
multipoint
multipolygon
national char
nchar
nclob
number
numeric
numrange
nvarchar
path
point
polygon
real
serial
set
signed
smalldatetime
smallint
smallserial
text
time
timestamp
tinyint
tinytext
tsquery
tsrange
tstzrange
tsvector
txid_snapshot
uniqueidentifier
uuid
varbit
varchar
year
xml