Download Microsoft JDBC Driver 8.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#84).
Installation procedure
Stop DataSpiderServer and DataSpiderStudio if they have been launched.
Copy mssql-jdbc-8.4.<version>.jre8.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/amazon_rds_sqlserver2017_adapter directory.
Start DataSpiderServer and DataSpider Studio.
Amazon RDS for SQL Server 2016 Adapter
Required library
mssql-jdbc-8.4.<version>.jre8.jar
Driver version
Microsoft JDBC Driver 8.4 for SQL Server
How to get library
Download Microsoft JDBC Driver 8.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#84).
Installation procedure
Stop DataSpiderServer and DataSpiderStudio if they have been launched.
Copy mssql-jdbc-8.4.<version>.jre8.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/amazon_rds_sqlserver2016_adapter directory.
Start DataSpiderServer and DataSpider Studio.
Amazon RDS for SQL Server 2014 Adapter
Required library
mssql-jdbc-8.4.<version>.jre8.jar
Driver version
Microsoft JDBC Driver 8.4 for SQL Server
How to get library
Download Microsoft JDBC Driver 8.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#84).
Installation procedure
Stop DataSpiderServer and DataSpiderStudio if they have been launched.
Copy mssql-jdbc-8.4.<version>.jre8.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/amazon_rds_sqlserver2014_adapter directory.
Start DataSpiderServer and DataSpider Studio.
Amazon RDS for SQL Server 2012 Adapter
Required library
mssql-jdbc-6.2.<version>.jre8.jar
Driver version
Microsoft JDBC Driver 6.2 for SQL Server
How to get library
Download Microsoft JDBC Driver 6.2 for SQL Server from Microsoft Download Center (https://www.microsoft.com/en-us/download/details.aspx?id=55539).
Installation procedure
Stop DataSpiderServer and DataSpiderStudio if they have been launched.
Copy mssql-jdbc-6.2.<version>.jre8.jar to $DATASPIDER_HOME/server/plugin/data_processing/modules/amazon_rds_sqlserver2012_adapter directory.