In this recipe, we will see how to connect different reporting tools to SAP HANA.
With different reporting tools available to consume data on top of SAP HANA, these are connected in different ways. As discussed earlier, all middleware drivers are provided by SAP in the form of SAP HANA Clients. This has to be installed in order to configure additional settings so that the SAP BO tools can be connected to SAP HANA.
As a prerequisite, we need to install SAP HANA Clients to proceed in order to create connections. We will see connection configurations for ODBC and SAP BO Explorer.
The ODBC configuration can be completed through the following steps: