Skip to Content
avatar image
Former Member

install SYBASE IQ as hana dynamic tiering

I want to install SYBASE IQ as Hana dynamic tiering.

Could you please tell where to download the software.

I already put the standalone SYBASE software in the right directory but hdblcm

cannot recognize it. So there is a SYBASE for DT?

Helpful links and blogs appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 27, 2017 at 10:16 AM

    Hi Qiyong,

    Good questions.

    Is there a Sybase for DT?

    No. To avoid any misunderstandings about naming, let's first state that all Sybase products have been rebranded to SAP for some time now. Sybase IQ would refer to the versions from 2016 and older.

    For more information about SAP IQ, see

    Where to download? You can download SAP IQ from the same location where you would download any SAP software:

    Dynamic Tiering (DT) versus Intelligent Query (IQ)?

    The concept of extended storage for SAP HANA using Sybase IQ technology goes back to around SAP HANA 1.0 SPS 07, if not mistaken, and you still might find a note or how-to for a Do-It-Yourself DT recipe. Spoiler alert: it is not all that easy.

    Fortunately, since, IQ technology has been completley integrated with SAP HANA for extended storage and this is what is labeled Dynamic Tiering. In other words, Dynamic Tiering is an SAP HANA option that integrates IQ technology (former Sybase, now SAP). Today, the integration is very complete: single installer, single administration tools, etc. Only under the hood, you would find what technology is being used; just as many other technologies have been leveraged and implemented in SAP HANA: Netweaver, MaxDB, etc.

    To learn more, see

    There is also a great tutorial series on the SAP HANA Academy, see

    Does this answer your question?


    Denys / SAP HANA Academy

    Subscribe to our YouTube Channel
    Join us on LinkedIn
    Follow us on Twitter
    Github code samples

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 27, 2017 at 05:59 AM

    To my knowledge there is not option to use Sybase IQ aka SAP IQ for HANA Dynamic Tiering.

    I think what you mean is using SAP IQ as Near-Line Storage Solution, which is used for BW Systems (check configuration details here).

    But as you have not provided any details which scenario you have, we cannot decide here if it would fit your requirement.


    Add comment
    10|10000 characters needed characters exceeded