Striim 3.9.7 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. Perform the following steps on each Striim server or Forwarding Agent that will read from or write to SQL Server, Azure SQL Database, or Azure SQL Data Warehouse.

Caution

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

For SQL Server 2008:

  1. 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.

  2. Copy enu/jre8/sqljdbc42.jar to striim/lib. or agent/lib.

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

For all other versions:

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

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