Data ServicesAdd a JDBC Driver

Java Database Connectivity (JDBC) API drivers for Oracle 19c, PostgreSQL 14.4 to 15 for Linux, and PostgreSQL 14.4 to 15 for Windows Server, are installed with Loftware Enterprise SP. To enable Loftware Enterprise SP to connect to another type of database, you must install a third-party JDBC driver for that type of database on the computer where Loftware Enterprise SP is installed. A JDBC driver is not required for File data services or HTTP data services.

To add a third-party JDBC driver to Loftware Enterprise SP, use this procedure.

  1. Download a JDBC driver for your type of database from the database company's website or another source.
  2. Review the documentation for the JDBC driver that you downloaded to obtain the package and class name for the driver.
  3. Copy the driver JAR file to the following location. <LOFTWARE_HOME> represents the folder on the Loftware Application Server in which the Loftware Enterprise SP application is installed.
    <LOFTWARE_HOME>\product\endorsed
  4. Open the following file in a text editor:
    <LOFTWARE_HOME>\product\conf\jdbc.properties
    1. Add the following line to the file. <PackageName> and <ClassName> represent the package name and class name for the driver that you downloaded.
      external.jdbc.drivers=<PackageName>.<ClassName>

      Tip: If you are using more than one third-party JDBC driver, separate the entries with a colon:
      external.jdbc.drivers=<PackageName1>.<ClassName1>:<PackageName2>.<ClassName2>

      Example

      In the following example, two third-party JDBC drivers are used.

      external.jdbc.drivers=com.mysql.jdbc.Driver:com.microsoft.sqlserver.jdbc.SQLServerDriver

    2. Save and close the file.
  5. In the Windows Server Control Panel, open the Services console and restart the Loftware Spectrum service.

A Data Service AdministratorClosed A local administrator who creates and configures data services for use by Designers who configure Database data sources and Alternate data sources. can now create JDBC data services that use this JDBC driver.