Skip to main content

Installing third-party drivers in Striim Platform

This section describes installation of the third-party drivers required to use some adapters and other Striim Platform features.

Install the HP NonStop JDBC driver for SQL/MX in a Striim server

This driver must be installed in every Striim server that will read from or write to HP NonStop SQL/MX tables using Database Reader or Database Writer.

Caution

Do not install drivers for multiple versions of SQL/MX on the same Striim server. If you need to write to multiple versions of SQL/MX, install their drivers on different Striim servers and run each version's applications on the appropriate Striim server(s).

  1. Follow the instructions in the "Installing and Verifying the Type 4 Driver" section of HPE NonStop JDBC Type 4 Driver Programmer's Reference for SQL/MX for the SQL/MX version you are running to copy the driver .tar file from the HP NonStop system with the tables that will be read to a client workstation and untar it. Do not install the driver.

  2. Copy the t4sqlmx.jar file from the untarred directory to striim/lib.

  3. Stop and restart Striim (see Starting and stopping Striim Platform).

Install the MariaDB JDBC driver in a Striim server

This driver must be installed in every Striim server that will read from or write to MariaDB.

  1. Download mariadb-java-client-2.4.3.jar from http://downloads.mariadb.com/Connectors/java/connector-java-2.4.3.

  2. Copy that file to striim/lib.

  3. Stop and restart Striim (see Starting and stopping Striim Platform).

Install the MemSQL JDBC driver in a Striim server

MemSQL uses MySQL's JDBC driver. See Install the MySQL JDBC driver in a Striim server.

Install the Microsoft JDBC Driver for SQL Server 2008 in a Striim server

The JDBC driver for Microsoft SQL Server 2012 and later, Azure SQL Database, and Azure Synapse is bundled with the Striim server.

To read from or write to SQL Server 2008, you must install an older driver.

Caution

Do not install both versions of the driver in the same Striim server.

  1. On Striim servers, delete striim/lib/mssql-jdbc-7.2.2.jre8.jar.

  2. Download the Microsoft JDBC Driver 6.0 for SQL Server .gz package from https://www.microsoft.com/en-us/download/details.aspx?id=11774 and extract it.

  3. Copy enu/jre8/sqljdbc42.jar to striim/lib.

  4. Stop and restart Striim (see Starting and stopping Striim Platform).

Install the MySQL JDBC driver in a Striim server

This driver must be installed in every Striim server that will read from or write to MySQL.

  1. Download the Connector/J 8.0.30 package from https://downloads.mysql.com/archives/c-j/ and extract it.

  2. Copy mysql-connector-java-8.0.30.jar to striim/lib.

  3. Stop and restart Striim (see Starting and stopping Striim Platform).

Install the Oracle Instant Client in a Striim server

The Oracle Instant Client version 21c must be installed and configured in the Linux host environment of every Striim server that will run OJet.

  1. Download the client from https://download.oracle.com/otn_software/linux/instantclient/211000/instantclient-basic-linux.x64-21.1.0.0.0.zip and follow the installation procedure provided by Oracle for the operating system of the Forwarding Agent host.

  2. Edit Striim/conf/startUp.properties and add the NATIVE_LIBS property to specify the Instant Client path. For example, if the Instant Client is installed in /usr/local/instantclient_21.1:

    NATIVE_LIBS=/usr/local/instantclient_21.1 

  3. Stop and restart Striim (see Starting and stopping Striim Platform).

Install the Redshift JDBC driver

This driver must be installed in every Striim server that will read from or write to Redshift.

  1. Download the JDBC 4.1 driver from http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html#download-jdbc-driver.

  2. Copy the .jar file to striim/lib.

  3. Stop and restart Striim (see Starting and stopping Striim Platform).

Install the SAP HANA JDBC driver

This driver must be installed in every Striim server that will write to SAP HANA.

  1. Download the JDBC 2.4.62 package from store.sap.com and extract it.

  2. Copy ngdbc-2.4.62.jar file to striim/lib.

  3. Stop and restart Striim (see Starting and stopping Striim Platform).

Install the Teradata JDBC driver in a Striim server

This driver must be installed in every Striim server or that will read from Teradata.

  1. Download the Teradata JDBC .tgz or .zip package from http://downloads.teradata.com/download/connectivity/jdbc-driver and extract it.

  2. Copy tdgssconfig.jar and terajdbc4.jar to striim/lib.

  3. Stop and restart Striim (see Starting and stopping Striim Platform).