Configure a generic data source - Remote Matching Service - 23.1 - 23.1 - Brainware - external - Brainware/Remote-Matching-Service/23.1/Remote-Matching-Service-User-Guide/About-configuring-data-sources/Configure-a-generic-data-source - 2024-02-05 - To configure a data source based on a database from a provider other than Microsoft SQL Server or Oracle, complete the following steps.

Remote Matching Service User Guide
Platform
Brainware
Product
Remote Matching Service
Release
23.1
License

To configure a data source based on a database from a provider other than Microsoft SQL Server or Oracle, complete the following steps.

To use such a database, you must obtain a JDBC driver for that database.

  1. Copy the JAR file containing the JDBC driver to the WEB-INF\lib\ directory used by the RMS web application on all server instances.
  2. On the Navigation pane, expand Data Sources.
  3. Right-click a data source and select Add > Generic.
  4. In the Add Data Source dialog box, in the Configuration section, complete the following substeps.
    1. In the Name field, type a name for the data source.
    2. In the Driver Class field, type the class name of the JDBC driver.

      For example, org.apache.derby.jdbc.EmbeddedDriver for an Apache Derby database

    3. In the JDBC URL field, type the URL for the JDBC driver for the data source.

      For example, jdbc:derby:databaseName for an Apache Derby database

  5. (Optional) To test the data source configuration, in the Add Data Source dialog box, in the Test Configuration section, complete the following substeps.
    1. In the User name field, type the database user name.
    2. In the Password field, type the database user password.
    3. Click Test.
      RMS tests the connection and displays a success or failure message.
  6. Click Save to create the data source with the current configuration.