JDBC Connector Guide

JDBC Connector Guide

JDBC Connector Processes Overview

JDBC Connector Processes Overview

You can use Process Designer in
Application Integration
to read, create, update, or delete data in databases with a JDBC type 4 driver.
In an
Application Integration
process, you can configure a JDBC connection to connect to databases with a JDBC type 4 driver. Use the connection in a process to perform multiple activities. You can specify a JDBC connection in step types such as Assignment and Create.
In a process that uses a JDBC connection, when you assign a value to a field, you can select the
Use Database-specific WHERE Clause Syntax
option to use nested queries and other database-specific querying options.

Example

As an HR administrator in an organization, you want to update the employee details when new employees join your organization. You can create an JDBC connection to the Employees table in an Oracle database. You can then design and run a process to insert the employee details from a source file object to the Employee table in the database.