Library Installation

Amazon RDS for SQL Server 2022 Adapter

Required library

Driver version

Microsoft JDBC Driver 12.8 for SQL Server

How to get library

Download Microsoft JDBC Driver 12.8 for SQL Server from Microsoft SQL Docs (https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver15#128).

Installation procedure

  1. Stop DataSpiderServer and DataSpiderStudio if they have been launched.
  2. Copy mssql-jdbc-12.8.<version>.jre8.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/amazon_rds_sqlserver2022_adapter directory.
  3. Start DataSpiderServer and DataSpider Studio.

Amazon RDS for SQL Server 2019 Adapter

Required library

Driver version

Microsoft JDBC Driver 12.4 for SQL Server

How to get library

Download Microsoft JDBC Driver 12.4 for SQL Server from Microsoft SQL Docs (https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver15#124).

Installation procedure

  1. Stop DataSpiderServer and DataSpiderStudio if they have been launched.
  2. Copy mssql-jdbc-12.4.<version>.jre8.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/amazon_rds_sqlserver2019_adapter directory.
  3. Start DataSpiderServer and DataSpider Studio.

Amazon RDS for SQL Server 2017 Adapter

Required library

Driver version

Microsoft JDBC Driver 12.4 for SQL Server

How to get library

Download Microsoft JDBC Driver 12.4 for SQL Server from Microsoft SQL Docs (https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-2017#124).

Installation procedure

  1. Stop DataSpiderServer and DataSpiderStudio if they have been launched.
  2. Copy mssql-jdbc-12.4.<version>.jre8.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/amazon_rds_sqlserver2017_adapter directory.
  3. Start DataSpiderServer and DataSpider Studio.

Amazon RDS for SQL Server 2016 Adapter

Required library

Driver version

Microsoft JDBC Driver 12.4 for SQL Server

How to get library

Download Microsoft JDBC Driver 12.4 for SQL Server from Microsoft SQL Docs (https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-2016#124).

Installation procedure

  1. Stop DataSpiderServer and DataSpiderStudio if they have been launched.
  2. Copy mssql-jdbc-12.4.<version>.jre8.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/amazon_rds_sqlserver2016_adapter directory.
  3. Start DataSpiderServer and DataSpider Studio.