Wyn Enterprise Administration Guide

Wyn Enterprise: Install Drivers Manually

In Wyn Enterprise, several data sources like Elasticsearch, Hive, and Hana require manual installation of drivers. To perform such installation, refer to the following sections.

Install Hive Driver

The following section describes the steps to install the driver for Hive data provider.

  1. Download the corresponding version of the JDBC driver from https://wyntools.blob.core.windows.net/dbdrivers/hive/2.0.0/hive.zip.

  2. Unzip the downloaded hive.zip file. You will have a new hive folder.

  3. Copy the new Hive folder to the Wyn Enterprise DataSource Service directory - C:\Program Files\Wyn Enterprise\DatasourceService\third-party-drivers.
    Run the application file for SAP Hana Client

    Now you can use Hive like other data sources.

Note: Hive is based on Hadoop and its driver contains more than 100 jar files. To avoid package conflicts, we provide the Hive 2.0 version of the driver with resolved conflict. If you need other driver versions, please contact us.

Install ElasticSearch Driver

The following section describes the steps to install the driver for ElasticSearch data provider.

  1. Download the corresponding version of the JDBC driver from https://www.elastic.co/downloads/past-releases#jdbc-client. For example, if you have installed the Elasticsearch version 7.10.0, then you need to download the JDBC Client version 7.10.0.
    Run the application file for SAP Hana Client

  2. Create a new folder namely elasticsearch in the Wyn Enterprise DataSource Service directory, that is, C:\Program Files\Wyn Enterprise\DatasourceService\third-party-drivers and then place the downloaded driver in the new folder.
    Run the application file for SAP Hana Client

    Now you can use Elasticsearch like other data sources.

Install Hana Driver

The following section describes the steps to install the driver for Hana data provider.

  1. Download the SAP Hana client from the following link - https://tools.hana.ondemand.com/#hanatools.

  2. Unzip the downloaded folder and double-click the application file to install SAP Hana Client on your system.

    Run the application file for SAP Hana Client

    It will take few seconds for the installation process to complete.

  3. Copy the Sap.Data.Hana.Core.v2.1.dll file from the following (default) location - C:\Program Files\sap\hdbclient\dotnetcore\v2.1 to the Wyn Enterprise Dataset plugin directory - C:\Program Files\Wyn Enterprise\Plugins\DataSet.

    Paste the dll file in the Wyn Enterprise dataset plugin directory

  4. Restart the Wyn Enterprise service.

In order to use Hana as a dashboard dataset, you must perform the following steps on every machine with the installed cot-worker.

  1. Download and install the Hana driver as described above.

  2. Copy the Sap.Data.Hana.Core.v2.1.dll file from the following location - C:\Program Files\sap\hdbclient\dotnetcore\v2.1 to the Wyn Enterprise CotWorker directory - C:\Program C:\Program Files\Wyn Enterprise\CotWorker.
    Paste the dll file in the Wyn Enterprise cotworker directory

  3. Restart the Wyn Enterprise service.