Show TOC

Procedure documentationSetting Up the Connection to the SAP HANA Database

Procedure

Install SAP HANA Studio

  1. Install the SAP HANA Studio.

    For more information, see http://help.sap.com/saphelp_hana/sap_hana_studio_installation_update_guide_en.pdfInformation published on SAP site.

  2. Install the SAP HANA Client for Microsoft Excel.

    For more information, see http://help.sap.com/hana/SAP_HANA_Client_Installation_Update_Guide_en.pdfInformation published on SAP site.

ODBC Data Source Administrator

To configure the 32-bit ODBC data source in the ODBC Data Source Administrator, proceed as follows:

  1. Navigate to the Windows/SysWOW64 directory and start the tool odbcad32.exe.

    The ODBC Data Source Administrator appears.

  2. In the ODBC Data Source Administrator, choose the System DSN tab and click the Add pushbutton.

    The dialog box for selecting the driver appears.

  3. Choose the entry SAP HANA for MS Excel as the driver and configure the data source to be able to connect to the HANA server.

  4. Confirm by choosing OK.

    The SQL server is then displayed on the System DSN tab and can be selected on the Configuration tab in the PCo Management Console.