Using Different Data Drivers for Installation
You can use the following drivers for installation:
Using Oracle JDBC Driver
An Oracle JDBC driver JAR file is required after the installation and master configuration is completed.
Before you begin
-
You must purchase the driver directly from Oracle. The driver is represented by the
ojdbcx.jar
file wherex
represents a variable that must change according to the Oracle version you are using, for example,ojdbc8.jar
,ojdbc7.jar
.-
You can obtain this file from an Oracle client installation, which is required when you use Studio, Openworks, PPDM data stored in Oracle.
-
You can find this file in the top-level folder of an Oracle instant client installation, or in the
jdbc/lib
subfolder within a full Oracle client installation.
-
-
You can also download the Oracle driver from Oracle website.
- Procedure
-
Move the downloaded Oracle JDBC JAR file in the OpenSpirit installation folder.
-
Copy it to the following path:
%OpenSpiritHome%\v4.3\lib\3rdparty
. -
In the
%OpenSpiritHome%\v4.3\plugins\jdbc
, update the JAR name in theospplugin.xml
file and add the exact JAR name in thePathElement
qualifier as shown in the example.<PluginDescriptor> <PluginIdentity> <Name>OracleConnectionFactoryPlugin</Name> <Provider>OpenSpirit Corporation</Provider> <Type>ConnectionFactoryPlugin</Type> </PluginIdentity> <Property> <Name>DbUrl</Name> <Value>jdbc:oracle:thin:</Value> </Property> <Property> <Name>JdbcDriver</Name> <Value>oracle.jdbc.driver.OracleDriver</Value> </Property> <JavaImpl> <ClassName>com.openspirit.spi.jdbc.DefaultConnectionFactoryPlugin</ClassName> <ClassPath> <PathElement>./lib/3rdparty/ojdbc8.jar</PathElement> </ClassPath> </JavaImpl> </PluginDescriptor>
Using SQLServer JDBC Driver
A SQLServer JDBC driver JAR file is required after the installation and master configuration is completed.
Before you begin
-
You must require the driver directly from Microsoft. The driver is represented by the
mssql-jdbc-x.jre8.jar
file wherex
represents a variable that must change according to the SQLServer version you are using, for example:mssql-jdbc-12.4.1.jre8.jar
.-
You can obtain this file from an SQLServer client installation that is required when you use Studio, PPDM data stored in SQLServer.
-
You can find this file in the top-level folder of an SQLServer instant client installation, or in the
jdbc/lib
subfolder within a full SQLServer client installation.
-
-
You can also obtain the SQLServer driver by downloading it from the Microsoft website.
- Procedure
-
Move the downloaded SQLServer JDBC JAR file in the OpenSpirit installation folder.
-
Copy it to the following path:
%OpenSpiritHome%\v4.3\lib\3rdparty
. -
In the
%OpenSpiritHome%\v4.3\plugins\jdbc
path, update the JAR name in theospplugin.xml
file and add the exact JAR name in thePathElement
qualifier as shown in the example.<PluginDescriptor> <PluginIdentity> <Name>SqlConnectionFactoryPlugin</Name> <Provider>OpenSpirit Corporation</Provider> <Type>ConnectionFactoryPlugin</Type> </PluginIdentity> <Property> <Name>DbUrl</Name> <Value>jdbc:sqlserver:</Value> </Property> <Property> <Name>JdbcDriver</Name> <Value>com.microsoft.sqlserver.jdbc.SQLServerDriver</Value> </Property> <JavaImpl> <ClassName>com.openspirit.spi.jdbc.DefaultConnectionFactoryPlugin</ClassName> <ClassPath> <PathElement>./lib/3rdparty/sqlserverjdbc.jar</PathElement> </ClassPath> </JavaImpl> </PluginDescriptor>