Library Installation

Oracle 12c Adapter

Required library

Driver Version

Oracle JDBC Driver 12.1.0

To Get the Library

Get drivers from the following site.(http://www.oracle.com/technetwork/indexes/downloads/index.html)

Installation

  1. Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
  2. Copy the necessary libraries to directly under the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle12c_adapter and the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle12c_adapter.
  3. Start DataSpiderServer and DataSpider Studio.

Oracle 11gR2 Adapter

Required library

Driver Version

Oracle JDBC Driver 11.2.0

To Get the Library

Get drivers from the following site.(http://www.oracle.com/technetwork/indexes/downloads/index.html)

Installation

  1. Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
  2. Copy the necessary libraries to directly under the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle11gr2_adapter and the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle11gr2_adapter.
  3. Start DataSpiderServer and DataSpider Studio.

Oracle 11g Adapter

Sales and inquiry support for Oracle 11g adapter has ended.

Required library

Driver Version

Oracle JDBC Driver 11.1.0

To Get the Library

Get drivers from the following site.(http://www.oracle.com/technetwork/indexes/downloads/index.html)

Installation

  1. Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
  2. Copy the necessary libraries to directly under the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle11g_adapter and the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle11g_adapter.
  3. Start DataSpiderServer and DataSpider Studio.

Oracle 10gR2 Adapter

Sales and inquiry support for Oracle 10gR2 adapter has ended.

Required library

Driver Version

Oracle JDBC Driver 10.2.0

To Get the Library

Get drivers from the following site.(http://www.oracle.com/technetwork/indexes/downloads/index.html)

Installation

  1. Stop DataSpiderServer and DataSpider Studio.
  2. Copy the necessary libraries to directory under the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle10gr2_adapter and the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle10gr2_adapter.
  3. Start DataSpiderServer and DataSpider Studio.

Oracle 10g Adapter

Sales and inquiry support for Oracle 10g has ended.

Required library

Driver Version

Oracle JDBC Driver 10.2.0

To Get the Library

Get drivers from the following site.(http://www.oracle.com/technetwork/indexes/downloads/index.html)

Installation

  1. Stop DataSpiderServer and DataSpider Studio.
  2. Copy the necessary libraries to directory under the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle10g_adapter and the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle10g_adapter.
  3. Start DataSpiderServer and DataSpider Studio.

Oracle 9.2.0 Adapter

Sales and inquiry support for Oracle 9.2.0 has ended.

Required library

Driver Version

Oracle JDBC Driver 10.2.0

To Get the Library

Get drivers from the following site.(http://www.oracle.com/technetwork/indexes/downloads/index.html)

Installation

  1. Stop DataSpiderServer and DataSpider Studio.
  2. Copy the necessary libraries to directory under the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle920_adapter and the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle920_adapter.
  3. Start DataSpiderServer and DataSpider Studio.

Oracle 9.0.1 Adapter

Sales and inquiry support for Oracle 9.0.1 has ended.

Required library

Driver Version

Oracle JDBC Driver 10.1.0

To Get the Library

Contact Oracle Corporation.

Installation

  1. Stop DataSpiderServer and DataSpider Studio.
  2. Copy the necessary libraries to directory under the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle901_adapter and the directory $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle901_adapter.
  3. Start DataSpiderServer and DataSpider Studio.

Oracle OCI Adapter

Required library

Oracle Database Client JDBC Driver
11g Release 2(11.2) ojdbc6.jar

Driver Version

Depends on the Oracle client version used.

To Get the Library

Usually locatable under jdbc\lib directory within the installation directory of the client tool.
In case of Oracle11g Release 2, it is locatable as Oracle\product\11.2.0\Client_1\jdbc\lib\ojdbc6.jar

Installation

  1. Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
  2. Copy the necessary libraries to directly under the $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle_oci_adapter directory.
  3. Start DataSpiderServer and DataSpider Studio.