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).
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.
Copy the
t4sqlmx.jar
file from the untarred directory tostriim/lib
.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.
Download
mariadb-java-client-2.4.3.jar
from http://downloads.mariadb.com/Connectors/java/connector-java-2.4.3.Copy that file to
striim/lib
.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.
On Striim servers, delete
striim/lib/mssql-jdbc-7.2.2.jre8.jar
.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.
Copy
enu/jre8/sqljdbc42.jar
tostriim/lib
.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.
Download the Connector/J 8.0.30 package from https://downloads.mysql.com/archives/c-j/ and extract it.
Copy
mysql-connector-java-8.0.30.jar
tostriim/lib
.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.
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.
Edit
Striim/conf/startUp.properties
and add theNATIVE_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
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.
Download the JDBC 4.1 driver from http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html#download-jdbc-driver.
Copy the .jar file to
striim/lib
.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.
Download the JDBC 2.4.62 package from store.sap.com and extract it.
Copy ngdbc-2.4.62.jar file to
striim/lib
.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.
Download the Teradata JDBC .tgz or .zip package from http://downloads.teradata.com/download/connectivity/jdbc-driver and extract it.
Copy
tdgssconfig.jar
andterajdbc4.jar
tostriim/lib
.Stop and restart Striim (see Starting and stopping Striim Platform).