Information Design Tool – Create Relational Connection to SAP HANA

Once you have created a project for your universe, you can create a relational connection to the HANA database:

1. Right Click HANA Project
2. Select Relational Connection
3. Specify Unique name for the connection then click next.
4. Choose appropriate driver for the connection.
5. Click to expand SAP drivers.
6. Click to expand the SAP High Performance Analytics Appliance (SAP HANA) 1.0 drivers
7. Select JDBC Drivers then click next.
8. 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