Striim 3.10.1 documentation

Installing the Microsoft JDBC driver

To read from or write to Microsoft SQL Server, Azure SQL Database, or Azure SQL Data Warehouse, the Microsoft JDBC Driver for SQL Server must be present in Striim's Java classpath.

mssql-jdbc-7.2.2.jre8.jar, the Microsoft JDBC driver for SQL Server 2012 and later, is bundled with the Striim server

That driver is not bundled with the Forwarding Agent, so to read from those sources, you must install one of the drivers.

Caution

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

For SQL Server 2008:

  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. or agent/lib.

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

For all other versions, for the Forwarding Agent only:

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

  2. Copy enu/mssql-jdbc-7.2.2.jre8.jar to agent/lib.

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