Download Oracle JDBC driver 18.3 from “JDBC Drivers” page of the Oracle download site (http://www.oracle.com/technetwork/indexes/downloads/index.html).
Installation procedure
Stop DataSpiderServer and DataSpider Studio.
Copy the required libraries under $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle18c_adapter directory and $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle18c_adapter directory.
Start DataSpiderServer and DataSpider Studio.
Oracle 12cR2 Adapter
Required library
ojdbc8.jar
Driver version
Oracle JDBC Driver 12.2.0
How to get library
Download Oracle JDBC driver 12.2 from “JDBC Drivers” page of the Oracle download site (http://www.oracle.com/technetwork/indexes/downloads/index.html).
Installation procedure
Stop DataSpiderServer and DataSpider Studio.
Copy the required libraries under $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle12cr2_adapter directory and $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle12cr2_adapter directory.
Start DataSpiderServer and DataSpider Studio.
Oracle 12c Adapter
Required library
ojdbc7.jar
Driver version
Oracle JDBC Driver 12.1.0
How to get library
Download Oracle JDBC driver 12.1 from “JDBC Drivers” page of the Oracle download site (http://www.oracle.com/technetwork/indexes/downloads/index.html).
Installation procedure
Stop DataSpiderServer and DataSpider Studio.
Copy the required libraries under $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle12c_adapter directory and $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle12c_adapter directory.
Start DataSpiderServer and DataSpider Studio.
Oracle 11gR2 Adapter
Required library
ojdbc6.jar
Driver version
Oracle JDBC Driver 11.2.0
How to get library
Download Oracle JDBC driver 11.2 from “JDBC Drivers” page of the Oracle download site (http://www.oracle.com/technetwork/indexes/downloads/index.html).
Installation procedure
Stop DataSpiderServer and DataSpider Studio.
Copy the required libraries under $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle11gr2_adapter directory and $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle11gr2_adapter directory.
Start DataSpiderServer and DataSpider Studio.
Oracle 11g Adapter
Sales and support for Oracle 11g Adapter are finished.
Required library
ojdbc6.jar
Driver version
Oracle JDBC Driver 11.1.0
How to get library
Download Oracle JDBC driver 11.1 from “JDBC Drivers” page of the Oracle download site (http://www.oracle.com/technetwork/indexes/downloads/index.html).
Installation procedure
Stop DataSpiderServer and DataSpider Studio.
Copy the required libraries under $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle11g_adapter directory and $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle11g_adapter directory.
Start DataSpiderServer and DataSpider Studio.
Oracle 10gR2 Adapter
Sales and support for Oracle 10gR2 Adapter are finished.
Required library
ojdbc14.jar
Driver version
Oracle JDBC Driver 10.2.0
How to get library
Download Oracle JDBC driver 10.2 from “JDBC Drivers” page of the Oracle download site (http://www.oracle.com/technetwork/indexes/downloads/index.html).
Installation procedure
Stop DataSpiderServer and DataSpider Studio.
Copy the required libraries under $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle10gr2_adapter directory and $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle10gr2_adapter directory.
Start DataSpiderServer and DataSpider Studio.
Oracle 10g Adapter
Sales and support for Oracle 10g Adapter are finished.
Required library
ojdbc14.jar
Driver version
Oracle JDBC Driver 10.2.0
How to get library
Download Oracle JDBC driver 10.2 from “JDBC Drivers” page of the Oracle download site (http://www.oracle.com/technetwork/indexes/downloads/index.html).
Installation procedure
Stop DataSpiderServer and DataSpider Studio.
Copy the required libraries under $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle10g_adapter directory and $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle10g_adapter directory.
Start DataSpiderServer and DataSpider Studio.
Oracle 9.2.0 Adapter
Sales and support for Oracle 9.2.0 Adapter are finished.
Required library
ojdbc14.jar
Driver version
Oracle JDBC Driver 10.2.0
How to get library
Download Oracle JDBC driver 10.2 from “JDBC Drivers” page of the Oracle download site (http://www.oracle.com/technetwork/indexes/downloads/index.html).
Installation procedure
Stop DataSpiderServer and DataSpider Studio.
Copy the required libraries under $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle920_adapter directory and $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle920_adapter directory.
Start DataSpiderServer and DataSpider Studio.
Oracle 9.0.1 Adapter
Sales and support for Oracle 9.0.1 Adapter are finished.
Required library
ojdbc14.jar
Driver version
Oracle JDBC Driver 10.1.0
How to get library
Contact Oracle corporation.
Installation procedure
Stop DataSpiderServer and DataSpider Studio.
Copy the required libraries under $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle901_adapter directory and $DATASPIDER_HOME/server/plugin/data_processing/modules/xa_oracle901_adapter directory.
Start DataSpiderServer and DataSpider Studio.
Oracle OCI Adapter
Required library
Oracle Database Client
JDBC driver
11g Release 2(11.2)
ojdbc6.jar
Driver version
It depends on the Oracle client version to use.
How to get library
It is usually placed in jdbc\lib directory under the directory where your client tool is installed.
In the case of Oracle 11g Release 2, it is placed at Oracle\product\11.2.0\Client_1\jdbc\lib\ojdbc6.jar.
Installation procedure
Stop DataSpiderServer and DataSpider Studio.
Copy the required libraries under $DATASPIDER_HOME/server/plugin/data_processing/modules/oracle_oci_adapter directory.
Sales and support for Oracle 11g Adapter are finished.