Wednesday 26 May 2021

SAP IQ

 

SAP IQ

What is SAP IQ?

SAP IQ (Intelligent Query) is a high-performance decision-support server designed specifically for mission-critical business intelligence, analytics, and data warehousing. Component Integration Services within SAP IQ provide direct access to relational and non-relational databases on mainframe, UNIX, or Windows servers.

At the foundation of SAP IQ lies a column store technology that allows for speed compression and ad-hoc analysis. SAP IQ has an open interface approach towards its ecosystem. SAP IQ is also integrated with SAP's Business Intelligence portfolio of products to form an end-to-end business analytics software stack, and is an integral component of SAP's In-Memory Data Fabric Architecture and Data Management Platform.


SAP IQ is a fully ACID-compliant database with guaranteed data integrity regardless of whether your database (or dbspace) is created on raw devices or file system files. Multiplex implementations support GPFS and NFS; simplex implementations support any file system. Both simplex and multiplex support raw devices