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.