Library Installation

SQL Server 2014 JDBC Adapter

Required library

Driver Version

Microsoft JDBC Driver 4.0 for SQL Server

To Get the Library

Download Microsoft JDBC Driver 4.0 for SQL Server from Microsoft Download Center. (http://www.microsoft.com/en-us/download/details.aspx?id=11774)

Installation

  1. Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
  2. Copy sqljdbc4.jar to directly beneath directory $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2014_adapter.
  3. When using Integrated Windows Authentication, copy sqljdbc_auth.dll to the directory on the Windows system path of the computer on which JDBC driver is installed.
  4. Start DataSpiderServer and DataSpider Studio.

SQL Server 2012 JDBC Adapter

Required library

Driver Version

Microsoft JDBC Driver 4.0 for SQL Server

To Get the Library

Download Microsoft JDBC Driver 4.0 for SQL Server from Microsoft Download Center. (http://www.microsoft.com/ja-jp/download/details.aspx?id=11774)

Installation

  1. Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
  2. Copy sqljdbc4.jar to directly beneath directory $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2012_adapter.
  3. When using Integrated Windows Authentication, copy sqljdbc_auth.dll to the directory on the Windows system path of the computer on which JDBC driver is installed.
  4. Start DataSpiderServer and DataSpider Studio.

SQL Server 2008 R2 JDBC Adapter

Required library

Driver Version

Microsoft JDBC Driver 4.0 for SQL Server

To Get the Library

Download Microsoft JDBC Driver 4.0 for SQL Server from Microsoft Download Center. (http://www.microsoft.com/ja-jp/download/details.aspx?id=11774)

Installation

  1. Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
  2. Copy sqljdbc4.jar to directly beneath directory $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2008r2_adapter.
  3. When using Integrated Windows Authentication, copy sqljdbc_auth.dll to the directory on the Windows system path of the computer on which JDBC driver is installed.
  4. Start DataSpiderServer and DataSpider Studio.

SQL Server 2008 JDBC Adapter

Required library

Driver Version

Microsoft JDBC Driver 4.0 for SQL Server

To Get the Library

Download Microsoft JDBC Driver 4.0 for SQL Server from Microsoft Download Center. (http://www.microsoft.com/ja-jp/download/details.aspx?id=11774)

Installation

  1. Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
  2. Copy sqljdbc4.jar to directly beneath directory $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2008_adapter.
  3. When using Integrated Windows Authentication, copy sqljdbc_auth.dll to the directory on the Windows system path of the computer on which JDBC driver is installed.
  4. Start DataSpiderServer and DataSpider Studio.

SQL Server 2005 JDBC Adapter

Required library

Driver Version

Microsoft JDBC Driver 4.0 for SQL Server

To Get the Library

Download Microsoft JDBC Driver 4.0 for SQL Server from Microsoft Download Center. (http://www.microsoft.com/ja-jp/download/details.aspx?id=11774)

Installation

  1. Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
  2. Copy sqljdbc4.jar to directly beneath directory $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2005_adapter.
  3. When using Integrated Windows Authentication, copy sqljdbc_auth.dll to the directory on the Windows system path of the computer on which JDBC driver is installed.
  4. Start DataSpiderServer and DataSpider Studio.