cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase IQ usage

mqaiser
Explorer
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

mqaiser
Explorer
0 Kudos

Hi Andrew,

Good information  Thanks ..... So I can install  BW on Sybase ASE with IQ as additional Component or BW on Sybase IQ only ...

If we are using ASE and IQ on ECC and BW , does any separate configuration are required on DB or Application level please ?

we have a system already on Sybase ASE can we migrate to Sybase IQ

We are no where near HANA as of now ...

Please advise

Regards

Mohammad

Former Member
0 Kudos

Hi Mohammad,

Yes, you could potentially install BW on ASE, with IQ as the NLS, however normally BW on HANA with IQ as NLS is a more common scenario.


For further details on using/configuring IQ as NLS for BW , see : SAP NetWeaver BW Near Line Storage solution (NLS) based on Sybase IQ.

Regarding migrating an ASE server to IQ, that is another question really. Both DBMS's are quite different, you might want to engage with Consulting to identify what the most appropriate solution would be (e.g.: ASE + IQ, or HANA + IQ).

Kind regards,
Andrew

markmumy
Advisor
Advisor
0 Kudos

IQ cannot be the main BW store.  SAP BW requires Oracle, SQL Server, ASE, DB2, or HANA as the engine.  IQ is only certified as the near line store under BW (SAP BW NLS on IQ).

Using ASE as the main store, though, seems a waste.  As Andrew mentions HANA is usually the BW engine due to performance.  If you put ASE as the BW store it is quite likely that IQ will outperform ASE on queries. That doesn't make sense as IQ is the near line store meant for archival data and really should not be faster than the main BW store.  That is why we see more BW on HANA than anything else.  It gives much better performance than any other database.

The second fit for IQ is under the Suite of products (ERP, CRM, etc).  There is an option to Suite called Information Lifecycle Management (ILM).  This, like BW NLS, uses IQ as the store.  The purpose of ILM is to put archived business data into IQ so that the primary source databases (HANA, ASE, etc) are kept smaller and only have relevant, active Suite data.

Lastly, IQ could be a good fit for your Big Data and data consolidation needs.  We have tools like Data Services (ETL), Sybase Rep Server, and SAP LT Replication Server (http://www.saphana.com/docs/DOC-2116) that can move data out of Suite and into IQ.  From there, we could then bring in data from other sources (non-SAP, HADOOP, streaming, etc) and have an Enterprise Data Warehouse to store all corporate data in a single reporting location.

Mark

mqaiser
Explorer
0 Kudos

Thanks Mark for details

Answers (0)