When setting up a Universe that connects to SAP HANA, you must first create a relational connection to the HANA database using JDBC or ODBC drivers. Once the connection is created, you can publish it to the repository to create a secured connection shortcut, and then use it to build the data foundation for your universe.
Once you have created a project for your universe, you can create a relational connection to the HANA database:
- Right Click HANA Project
- Select Relational Connection
- Specify Unique name for the connection then click next.
- Choose appropriate driver for the connection.
- Click to expand SAP drivers.
- Click to expand the SAP High Performance Analytics Appliance (SAP HANA) 1.0 drivers
- Select JDBC Drivers then click next.
- Enter the appropriate credentials for the HANA database and test the connection then click next.
Note* When creating the connection the most important setting is the array fetch size, which controls how many lines are retrieved each time the client tool connects to the database. Increasing the value enables the system to make fewer trips to retrieve the full datasets. The default is 10, but it can be increased to a maximum of 1000 for better performance. Higher values run faster queries, but require more memory on the client tool that is running the query.
- Increase the value to 1000 then click finish.
The connection has been configured with an array fetch size that maximizes the speed of queries. If you want to publish your universe to the repository, you must first publish the connection and create a secured connection shortcut. You have now created a relational connection to SAP HANA
Relational Connection to SAP HANA
Information Design Tool – Create a data foundation using SAP HANA tables
Once a relational connection has been created in SAP HANA, the next step is to create a data foundation for the universe. When connecting SAP HANA, you can build your data foundation by selecting the appropriate tables and creating joins between them, or you can build your data foundation directly on a pre-existing analytics or calculation view.