Hero Backgroud Elements 2
Reading Time: 10 Min

Installing an ODBC Driver for Third-Party BI Client Access

Learning Article
  • Installing an ODBC Driver is the first step towards fully utilizing SAP Data Warehouse Cloud across multiple third-party BI clients and tools. Installation is only a matter of a few clicks and find out how in a few simple steps!

     

    Please note: It is extremely important to use the 64-bit or 32-bit of the based on the version of the third-party BI tool you aim to use. (For example, MS Excel 32-bit requires the connection be installed in ODBC Manager 32-bit)

     

     

    Windows:

    Every Windows system comes pre-installed with an ODBC Manager, as shown below. Based on the version of the 3rd party BI tool you aim to use, determine whether you will use ODBC Manager 32-bit or 64-bit for the installation.

    In order to install an ODBC driver, we follow the undermentioned steps:

      

    • First, install the corresponding driver to connect to the HANA database of SAP Data Warehouse Cloud. To find your driver, navigate to the HANA developer tools website.
    • Go to the HANA tab, and then you select the corresponding client and click on Windows install.

    • Run the downloaded file hdbsetup.exe Click through the wizard, and complete the installation.

    • Now, open ODBC Data Sources on your system, and you can see the new entry HDBODBC, which can now be used to create new system and user data sources.

    You have now successfully installed an ODBC Driver in your system! To install a user or system data source, enact the following steps:

     

    • To create a new user (or system) data source, click on the User DSN tab, and click on Add.

     

    • Select the HANA Database ODBC (HDBODBC), and click on Finish.

    • Now, enter the configuration settings for the new data source. Enter the Name, Description, Host and Port Number. Make sure to uncheck the Multitenant, and Validate the TSL/SSL certificate boxes, and check the Connect to database using TSL/SSL Certificate box to securely connect to the database. Click on Ok when done.

    • You have now successfully created a User Data source, and can now use it with third- party BI tools.

    macOS:

    macOS requires that you initially install an ODBC manager. ODBC managers for macOS can be found on a variety of websites including odbcmanager.net, and iODBC.org. In this example, we use iODBC.org.

     

    • First, visit the iODBC.org website on your web browser. Go to the Downloads section, and then you select the corresponding client and download the dmg file.

    • Follow the install wizard and complete the installation of the ODBC manager on your system.

    • There exists no native macOS HANA Driver, which means that you need to install a bridge between the ODBC Manager to the HANA Driver. You can use OpenLink, ActualTech or any similar program for the same. In this example, we use OpenLink.
    • Open the OpenLink website and navigate to Downloads. Click on the Driver license tab, and specify the license type and database, along with the operating system. Type in your email ID and click on Generate a license, which will be emailed to you.

    • On receiving the details via e-mail, login to the bridge software through the page redirected to in the email, which in this case is OpenLink, and click on the Download icon to download the license.

    • Now we need to download the data access drivers. Navigate to the Data Access Drivers tab on the OpenLink website. Specify the type of database and driver type you need, which in this case is the same info you entered for downloading the license, and click on Find Downloads.

    • This gives you the link to the installer. Click on the Download icon to download the data access driver.

    • On completing the download, follow the install wizard and complete the installation on your system.
      When prompted, enter the license details that we downloaded earlier.

    • Move the downloaded jar file from the Downloads folder to
      /Library/Java/Extensions
      This is where the ODBC Manager will look for the client.
    • Now, open iODBC Administrator which we installed in the first step. Depending on whether you want to add a User Data Source or System Data Source, click on the corresponding tab, and click on Add.

    • Since we installed the ODBC Bridge, iODBC provides us with the options of choosing either OpenLink JDBC Lite Driver (Unicode) or OpenLink JDBC Lite Driver, alongside PostgreSQL Unicode which exists as default. Select OpenLink JDBC Lite Driver (Unicode), and click on Finish.Note: Ensure that the ODBC Drivers have their Version numbers specified. If unspecified, remove the ODBC Drivers and install again.

    • Enter a technical name and description for the data source, and click on Continue.

    • Now, in the JDBC Driver column, enter

      com.sap.db.jdbc.Driver
      In the URL String column, enter

      jdbc:sap//<server host>:<port>?encrypt=trueWhere <server host> is your server URL and <port> is your port number and click on Continue.

    • Now step through the rest of the wizard by clicking on Continue, and then click on We have now added a User DSN Entry, which can be used with Third Party BI Clients and Tools.

    With the installation of an ODBC Driver, we can now fully leverage the flexibility of SAP Data Warehouse Cloud, allowing you to efficiently manage and deal with your data.