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 where x 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
  1. Move the downloaded Oracle JDBC JAR file in the OpenSpirit installation folder.

  2. Copy it to the following path: %OpenSpiritHome%\v4.3\lib\3rdparty.

  3. In the %OpenSpiritHome%\v4.3\plugins\jdbc, update the JAR name in the ospplugin.xml file and add the exact JAR name in the PathElement 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 where x 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
  1. Move the downloaded SQLServer JDBC JAR file in the OpenSpirit installation folder.

  2. Copy it to the following path: %OpenSpiritHome%\v4.3\lib\3rdparty.

  3. In the %OpenSpiritHome%\v4.3\plugins\jdbc path, update the JAR name in the ospplugin.xml file and add the exact JAR name in the PathElement 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>