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