Executing SQL query to retrieve and insert data

This example pipeline demonstrates how to execute a SQL query to retrieve data from a database and insert the retrieved data into the target database table.

• Generic JDBC - Execute
• Generic JDBC - Insert

Read and Sort Records by Age

This example pipeline demonstrates how to read data from a database, sort the data, and insert it into an Oracle database.

• Generic JDBC - Select
• Oracle - Insert

Update data in an SQL database

This example pipeline demonstrates how to update the data in the SQL database

• Mapper
• Generic JDBC - Update

JDBC Schema Migration to MySQL

The following example pipeline demonstrates how to retrieve all the schemas for the selected account.

• Generic JDBC - Schema List

MySQL Numeric Data Extraction and Load

The following example pipeline demonstrates how to retrieve all the tables for the selected schema.

• Generic JDBC - Table List