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.
Procedure
- Define a job that includes a JDBC Connector stage.
- Define a connection to a JDBC data source.
- To set up the JDBC Connector stage as a source stage to
read data from the JDBC data source, complete the following steps:
- Configure the JDBC Connector stage as a source.
- Set up column definitions on the output link.
- To set up the JDBC Connector stage as a target stage to
write data to the JDBC data source, complete the following steps:
- Set up column definitions on the input link.
- Configure the JDBC Connector stage as a target.
- Optional: Create reject links to manage input data with errors.
- To set up the JDBC Connector stage to look up data in an
JDBC data source, complete the following step:
- Configure
normal lookup operations or configure
sparse lookup operations.
- Compile and run the job.