Free cookie consent management tool by TermsFeed Custom JDBC Connected System [Connected Systems]

Share your feedback in the Appian Documentation 2024 User Survey today!

Custom JDBC Connected System

Overview

The custom JDBC connected system allows you to connect to unsupported databases that support the JDBC protocol. Providing an alternative to using HTTP integrations or third-party plug-ins, this connection uses a SQL integration object to exchange data with your business data source through SQL statements.

Any database that is not in this list is considered an unsupported database.

This page provides details about custom JDBC connected system properties. For information that pertains to all connected systems, see Connected System Object.

To use the custom JDBC connected system, you will need to do the following:

  1. Deploy a driver.
  2. Create the new connected system.
  3. Create a SQL integration object.

Deploy a driver

The process for deploying a driver differs based on your Appian installation.

If you are an Appian Cloud customer

Open an Appian Support case to request the deployment of your driver. You will need to attach the .jar file for the desired JDBC driver to the support case.

If you are a self-managed customer

To deploy the desired driver to your site, run the creation script found in <APPIAN_HOME>/_admin/_scripts/tools/jdbc/create-jdbc-driver-plugin.sh. You will need to input the following information to run the script:

  • File path to the .jar file.
  • Driver class name (-driverClass).
  • Plug-in name (-name).
  • Plug-in key (-key).
    • The key will be displayed in the custom JDBC connected system configuration properties.
  • Plug-in version (-version).
    • We recommend that you use the same plug-in version as the driver .jar file version.

Properties

After you have deployed a driver to your site, you can create your new connected system. Configure the following properties to create the connected system.

Field Description
Name The name of the connected system. Use a name that will uniquely identify this connection to the external database.
Description Supplemental information about the connected system that is displayed in the objects grid of some Designer views and when selecting the system in an integration object.
Database The unsupported external database that you are connecting to. If you have deployed a single driver, this should be pre-populated with the name of the database driver you have deployed. If you have deployed multiple drivers, there will be a dropdown menu to select your driver.
Connection URL The URL for the data source. Should include: the hostname, port, and database name of the data source. The exact syntax will vary by database type, but the connection URL should always be prefixed by jdbc.
Username The username for connecting to the database.
Password The password for connecting to the database.
Maximum Connection Pool Size

The maximum number of active connections to the database that can be allocated from this data source at the same time. The default is 20.

Since there is a limited number of connections that applications can make to the database, this field prevents one connected system from using the entire connection pool. You can raise or lower this number to control the number of connection pools for a data source.

For example, if you have a data source for an application with low usage, you can lower this number to further limit the number of connection pools for the application. This would prevent the application from taking up too many resources.

Transaction Isolation Level

The degree of isolation or concurrency control applied to transactions in a database system. This determines how transactions interact with each other and how they access and modify data concurrently. There are four transaction isolation levels available in the JDBC API. It's important to note that not all database vendors support all four levels.

  • TRANSACTION_READ_UNCOMMITTED: This is the lowest isolation level where it allows dirty reads, non-repeatable reads, and phantom reads.
  • TRANSACTION_READ_COMMITTED: A transaction can only read data that has been committed by other transactions. It prevents dirty reads. But non-repeatable reads and phantom reads can occur.
  • TRANSACTION_REPEATABLE_READ: Ensures that within a transaction, the same query will always return the same results. This prevents dirty reads and non-repeatable reads. But phantom reads can still occur.
  • TRANSACTION_SERIALIZABLE: This is the highest isolation level, providing strict data consistency. This ensures that concurrent transactions behave as if they are executed serially, preventing dirty reads, non-repeatable reads, and phantom reads.

The create new custom JDBC connected system screen

Next steps

After you have deployed a driver and set up your connected system, you will need to create a SQL integration object.

Open in Github Built: Wed, Feb 21, 2024 (06:04:27 PM)

Custom JDBC Connected System

FEEDBACK