Skip to Content

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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.