Azure Synapse Analytics

Azure Synapse Analytics is a powerful Big Data service from Microsoft. Evolved from Analytics Platform System (Parallel Data Warehouse), it is designed to bring highly scalable data warehousing solution to the cloud.

Synapse allows the same SQL engine and capabilities one would expect from a single SQL Server instance, but in a massively parallelized cloud solution. Tables can be use columnar or row indexes.

Omni Loader is carefully optimized for Azure Synapse Analytics.

We employ all the best practices to bring even the world's largests databases to Azure Synapse Analytics quickly and easily.

Azure Synapse Analytics

data types we support

Integral
bigint (int8)
int (integer, int4)
smallint (int2)
decimal
decimal (dec, numeric, fixed)
double precision (double, float8)
float
money
real (float4)
text
char (bpchar, character)
text
varchar (character varying)
Binary
bit
Date/Time
date
time (timetz, time without time zone)
timestamp (timestamp without time zone, timestamp(2) without time zone)
timestamptz (timestamp with time zone, timestamp(2) with time zone)
Large objects
bytea
geography
geometry
text
xml
Other
array
boolean (bool)
cidr
citext
enum
hstore
inet
interval
json
jsonb
macaddr
oid
uuid
varbit (bit varying)