Connecting reporting tools to SAP HANA
In this recipe, we will see how to connect different reporting tools to SAP HANA.
Getting ready
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.
How to do it…
The ODBC configuration can be completed through the following steps:
- After installing SAP HANA Clients, go to Control Panel and open Administrative Tools.
- Select Data Sources (ODBC) from the list of Administrative Tools, as shown in the following screenshot:
- Navigate to the System DSN tab and click on Add. From the list of ODBC drivers available, select...
