to read, create, update, or delete data in databases with a JDBC type 4 driver.
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.
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.