How to Connect SAP BusinessObjects 4.2 Web Intelligence to an SAP HANA Database Using Direct and Online Access Methods
Learn about two new data access options, SAP HANA Direct Access and SAP HANA Online, introduced with SAP BusinessObjects 4.2 for SAP HANA. Learn a step-by-step procedure for creating connections between Web Intelligence with SAP HANA views using these new options.
A Universe is the semantic layer that resides between the database and end user, providing business representation to the technical data structures. A Transient Universe is the Universe automatically created by Java Business Intelligence Consumer Services (BICS) based on the source data structure.
With the release of SAP BusinessObjects 4.2, Web Intelligence can now connect to SAP HANA in two ways. These options are:
- SAP HANA Direct Access
- SAP HANA Online
SAP HANA Direct Access
SAP HANA Direct Access allows you to use SAP HANA views as the data source for creating Web Intelligence documents without having to create a universe on top of the SAP HANA view. SAP HANA Direct Access can be created on SAP HANA using secured relational or Online Analytical Processing (OLAP) connections defined in the SAP BusinessObjects system. These connections allow you to use either the Multi-Dimensional Expression (MDX) script language (in OLAP connections) or SQL (in relational connections). This data access also allows parallel refreshing of queries.