RDB

• Deploying a Third-Party JDBC Driver
• Creating an RDB Connection
• Setting RDB Connection Properties

Deploying a Third-Party JDBC Driver

Follow the procedure below to deploy the driver JAR to the server:

1. Obtain a JDBC driver for your database.
2. Deploy the JDBC driver: Copy the driver JAR files into [DATA_DIR]/system/lib/drivers.
3. Restart the Flow Service to load the new driver.
4. Create a connection in the Flow Designer or management console.

Creating an RDB Connection

In the Flow Designer, click the icon in the Connection pane, select RDB, and enter a name for the connection. Enter the connection properties in the inspector. The logged-in user owns these connections.

You can create system or user connections in the management console: click Settings > Connection > RDB > New.

Setting RDB Connection Properties

Property	Description
Connection Name	Enter a unique name.
Database Type	Select a database. This prepopulates the Driver and URL fields. Or, select Other to connect using another JDBC driver.
Driver	Enter the JDBC driver's class name.
URL	Enter the JDBC URL. Replace the placeholders in brackets with the connection parameters to your database.
User	Enter the username to authenticate with.
Password	Enter the password to authenticate with.
Schema	Enter the database schema in the box. The SQLBuilder and table lists are restricted to this schema.
Use Connection Pool	Select whether to enable connection pooling. true Enable connection pooling (default). false Disable connection pooling. For an overview of connection pooling in the Flow Service, see Using Connection Pooling in Designing Flows > Flow Elements > Connections.
XA	Select whether to use XA (two-phase commit). If you enable XA for a database that doesn't support it, an exception will be thrown. false Don't use XA (default) true Use XA
Dynamic	Enable this option to use the DynamicConnection component to change the connection definition. false Disable dynamic connections (default). true Enable dynamic connections.