SAP IQ

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

Export 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.

Import data into SAP IQ Database

Additionally, if you want to import data on a regular basis and do not want to recreate the whole target database from scratch every time, but rather do tiny targeted sync of only changes since the last run, please use Full Convert Pro or Ultimate.

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