Designing jobs with JDBC Connector stages

You can use JDBC Connector stages in your jobs to read data from the JDBC data sources or write data to JDBC data sources in the contexts of those jobs.

Before you begin

Set up the driver configuration file.

Procedure

  1. Define a job that includes a JDBC Connector stage.
  2. Define a connection to a JDBC data source.
  3. To set up the JDBC Connector stage as a source stage to read data from the JDBC data source, complete the following steps:
    1. Configure the JDBC Connector stage as a source.
    2. Set up column definitions on the output link.
  4. To set up the JDBC Connector stage as a target stage to write data to the JDBC data source, complete the following steps:
    1. Set up column definitions on the input link.
    2. Configure the JDBC Connector stage as a target.
    3. Optional: Create reject links to manage input data with errors.
  5. To set up the JDBC Connector stage to look up data in an JDBC data source, complete the following step:
    1. Configure normal lookup operations or configure sparse lookup operations.
  6. Compile and run the job.