JDBC Connector Guide

Back Next

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.

JDBC Connector Processes

Download Guide

Watch

Comments

Cloud Application Integration Homepage