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

SQL Flow handles automatically

The software does the migration work.

  • SQL Flow selects provider-aware reading, type handling, and loading behavior.
  • Supported capabilities and prerequisites are matched to the chosen database.
  • Database-specific differences are applied without rebuilding the migration.

You choose

Keep control of the decisions that matter.

  • Choose the source and target database.
  • Select among available full-load and CDC modes.
  • Choose type mappings and target creation policy.