Skip to Content
author's profile photo Former Member
Former Member

Sybase IQ usage

Experts,

Greetings,

We have multiple SAP products like ERP, BW , PI , EP , CRM etc… and Sybase ASE 15.7.0.042 is used as database and SCC 3.2.8 to manage it. going forward will setting up DR as well. .

Confusion is where does Sybase IQ fit our environment , it is specifically for BW

If possible can you please explain

Regards

Mohammad

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 06, 2013 at 11:43 AM

    Hi Mohammad,

    IQ is a DBMS designed primarily for Datawarehousing & analytics (OLAP) and should be seen as a complementary database to ASE which is designed more for transactional processing (OLTP).

    ASE , IQ , SCC together with HANA and other SAP Database & Technology products are part of the SAP Real Time Data Platform and as such are being integrated and optimized to work together as a platform capable of supporting SAP applications as well as 3rd-party applications and custom applications.

    IQ can for example be used on its own as a DWH DB, or in solutions with other databases such as ASE or HANA. It can also be integrated as a Near Line Store for BW (IQ 15.4 ESD#3 and later).

    There are also some good guides & tutorials on the IQ Developer Center that might be of interest here.

    Hope this helps
    Kind regards,
    Andrew

    Add comment
    10|10000 characters needed characters exceeded