Strategy Integration with SAP HANA
The Strategy Secure Enterprise Platform supports integration with SAP HANA as a data warehouse with Strategy Intelligence Server running on Windows and Linux operating systems.
About SAP HANA
SAP HANA is a relational database management system providing many data structures that are commonly used in other relational database management systems, such as schemas, tables, procedures, views, etc. Additionally SAP HANA offers data structures supporting OLAP analysis at the database engine level, including business logic/modeling, such as Attributes, Measures, Hierarchies, Calculated columns, Information Views, etc.
Strategy implements relational OLAP (ROLAP) providing a logical data model in its metadata that map to relational data structures. To take advantage of the OLAP data structures offered by SAP HANA Strategy performs a mapping of SAP HANA objects to objects in the Strategy metadata.
SAP HANA is used as a standalone database; in this case, there are ETL processes that move data into SAP HANA, and this data is consumed by multiple clients, either SAP applications (BICS and MDX) or other third-party clients like Strategy through SQL for example.
