SAP IQ

SAP IQ

SAP IQ (known also as Sybase IQ or Sybase IQ) is a columnar, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts.

SAP IQ bases its performance on columnar data engine, like many competing solutions.

Full Convert Pro Full Convert Ultimate Omni Loader

We support SAP IQ directly. No additional drivers are required.

SAP IQ data types we support

Integral

bigint, int (integer), smallint, tinyint, unsigned bigint, unsigned int

Decimal

decimal (numeric), double, float, money, real, smallmoney

Text

char, long varchar (clob, text), varchar

Binary

binary, bit, varbinary

Date/Time

date, time, timestamp (datetime, smalldatetime)

Large objects

long binary (blob, image), long varchar (clob, text)

Other

uniqueidentifier

Export your SAP IQ database

It may make sense to migrate your data away from SAP IQ. You may want to do it permanently or just need to share your tables with a collague in a different format.

We will copy all your tables with their data and apply indexing and relationships exactly as they are in your current SAP IQ database. In a nutshell, you get exactly the same database in another database engine. Each time you run the migration, we will copy all the tables again. Of course, we have a built-in scheduler, so you can run this overnight and have a fresh database copy in the morning.

Take a look at the quick tutorials below to see how it's done using Full Convert.

Export SAP IQ to: