Skip to Content
Author's profile photo Tammy Powlas

Brief summary – SAP IQ Roadmap Webcast – a Companion SAP Product

SAP has set up open product roadmap webcasts Technology Product Road Map Series for ASUG as a result of a successful ASUG CEI project.

Below is a brief summary of today’s webcast.  The usual disclaimer applies that things discussion in the future are subject to change.


Figure 1: Source: SAP

SAP IQ (formerly known as Sybase IQ) was one of the first commercial columnar databases.  It handles high data volume.  It offers more integration with BI and HANA


Figure 2: Source: SAP

Figure 2 positions SAP IQ as an analytics platform, with integration to Hadoop.


Figure 3: Source: SAP

Figure 3 shows that SAP IQ is a companion product for SAP.

“SAP IQ is an enhanced solution for warm and cold data archiving capabilities for BW, suite and HANA”.


Figure 4: Source: SAP

Figure 4 shows the history of SAP IQ

This year SAP IQ is moving to SP’s, to align with SAP and HANA and in the same time frame

There will be two SP’s a year –same time as HANA

SAP IQ is an open EDW but will be a close companion to HANA

It will offer extended storage for SAP HANA

IQ is offering a new shared nothing architecture – cost conscious for customer’s move to cloud


Figure 5: Source: SAP

SP8 is planned for mid year

SP9 is planned at end of year

Extreme data


Figure 6: Source: SAP

Figure 6 shows an extended table in HANA

Using an IQ instance you create connection in HANA

You do not care where data is kept – this is an “evolution for transparency”


Figure 7: Source: SAP

Figure 7 shows the PSA, which is data read in from data sources before transformed

From corporate memory to restore BW environment can be done with SAP IQ

You can put NLS and extended in SAP IQ SP8


Figure 8: Source: SAP

Figure 8 is the overall planned roadmap

Question & Answer

Q: SCC not bad, but is there any plans to integrate IQ (manage and develop) with HANA Studio?

A: Yes, you will be able to define extended tables through HANA studio.  BW cockpit enhanced

Q: VLDB licensed by TBs – is there any plans to remove strange this limitations?

A: Looking at simplifying licensing around IQ

Q: Hana uses special coding and views etc. will IQ support those application development.

A: Yes, HANA extended views will be used over time – not sure if it will make it in SP8

Q: How about IQ and DS integration

A: IQ can be a data source or target


Join us in June for ASUG Annual Conference, where SAP IQ will be covered, and how it can be a “companion” product to SAP.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      HI, Tammy.

      Nice to hear that IQ still in the game,

      IQ is very fast and stable DBMS.

      By license policies.... VLDB and UDA options must be include in Enterprise Edition as well.

      Author's profile photo Former Member
      Former Member

      By the way -

      SAP HANA, Runtime DB Edition for SAP NetWeaver BW licensed by SAP Maintenance Base Value.

      Unless otherwise agreed by SAP, HANA DB for BW includes licenses for SAP Near-line storage for SAP BW (NLS for BW). NLS for BW includes a runtime license of Sybase IQ Enterprise Edition, Sybase IQ Enterprise Edition-Very Large Database Management Option and Sybase IQ Enterprise Edition-Unstructured Data Analytics Option which may solely be used with SAP BW.

      So if you have this type of BW on HANA licenses - you get NLS as well.