Skip to main content

Striim Platform 5.0 documentation

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 Db2 JDBC driver in a Striim server

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

  1. Download db2jcc4.jar version 4.33.31 from DB2 JDBC Driver Versions and Downloads and copy it to striim/lib.

  2. Copy db2jcc_license_cu.jar from your Db2 installation to striim/lib.

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

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 host environment of every Striim server that will run OJet.

  1. For Linux, download the client from https://download.oracle.com/otn_software/linux/instantclient/216000/instantclient-basic-linux.x64-21.6.0.0.0dbru.zip.

    For Microsoft Windows, download the client from https://download.oracle.com/otn_software/nt/instantclient/216000/instantclient-basic-windows.x64-21.6.0.0.0dbru.zip.

  2. For Linux: install the Instant Client as described in Installing Oracle Instant Client.

    For Microsoft Windows: install the Instant Client as described in "Instant Client Installation for Microsoft Windows 64-bit" at the bottom of the page Oracle Instant Client Downloads for Microsoft Windows (x64) 64-bit.

  3. 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.6:

    NATIVE_LIBS=/usr/local/instantclient_21.6 

  4. 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).

In this section: