Creating a relational connection to Hana
The BI 4.0 BusinessObjects Business Intelligence Platform can provide reporting and application tools for the new SAP Hana platform. Possible connections include relational and olap connectivities. This discussion is limited to the relational connection for Web Intelligence.
The purpose of this document is to provide a resource for universe designers to create a relational connection to the new Hana platform for SAP BusinessObjects for the semantic layer and the reporting tools that utilize a universe layer, such as Web Intelligence, Crystal Reports Enterprise and Dashboards.
Hana can be used as a logical relational reporting database. The high capacity in memory storage is transparent to the universe designer. The data is queried as rows and columns as standard databases.
The two types of relational connections include the Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC)
ODBC – Open DataBase Connectivity
Microsoft-driven specification for relational reporting
Database requests are made via SQL (Structured Query Language)
Heavily adopted in industry
No longer Microsoft-centric - Unix and Linux drivers exist for ODBC
JDBC – Java DataBase Connectivity
Relational reporting drivers specified by the Java community. Popular on Unix platforms.
Install the JDBC or ODBC Driver
Use JDBC or ODBC Driver
- The driver must be installed on the client machine where Information Design Tool is running and BI 4.0 server
- JDBC driver is installed in the folder : <install_folder>\dataAccess\connectionServer\jdbc\drivers\newdb
- Launch the Information Design Tool
- Log into the Repository Resources
- Select the Connections Folder
- Right Click and insert Relational Connection
- Expand the SAP High-Performance Analytic Server Appliance (SAP HANA) 1.0
- Select JDBC or ODBC
- Define Parameters:
- Authentication Mode
- User Name / Password
- Server hostname and port number as
- <hostname>:<port> where <port> is
- the port number (3xx15 where xx is the instance number)
- Set Disconnect after each Transaction
Additional tuning parameters can be defined for database connections to IMCE
Set Arrary Fetch Size – This refers to the number of rows retrieved at a time. Increasing this value can improve query performance for universes built on tables and information models. The higher the number the bigger the memory consumption on the machine processing the query (the BI platform server or the client tool) Setting this to 1000 can provide good response times, with the exception of blob objects or long text objects. These will depend on the average size of those fields. This parameter has to be set in the connection definition (CNX) file
Disconnect after each transaction is the recommended setting for the conneciton pooling.
- Next create an IDT Project
- Create a shortcut connection an put in the new Project
- Create the Data Foundation for a single or multi source universe.
- Maps tables and views the universe will be based on Defines joins, reporting contexts
- Can define level list of values and parameters based on table fields
- The universe allows relational reporting on HANA
- Attribute, Analytic and Calculation Views can be accessed in a relational (SQL) manner by using Column Views from the _SYS_BIC schema .
- Create a Business Layer on the Hana Data Foundation.
- Publish the connection and the business layer to the BI 4.0 repository
The universe can now be consumed by client tools such WebIntelligence, Dashboards or Crystal Report for Enterprise.
This becomes a relational universe that BI clients will build queries from the Query Panel against this universe and it will appear like any other relational universe.
Related Content (Size: Heading 1)
Related Documents (Size: Heading 2)
Insert SAP Help links, links related to your component area or other WIKI content (TINY LINK). You should hyperlink the title of the related document.
Example: Explanation about how to create a WIKI page
Related Notes (Size: Heading 2)
Insert links to any related Notes or KBAs that support your topic or are related. You should hyperlink only the Note number or KBA number.
Example: SAP Note 83020: What is consulting, what is support