Using shared Data Sources with DB components in Jobs with tRouteInput

Using shared Data Sources with DB components in Jobs with tRouteInput - 7.3

Route

Version

7.3

Language

English

Product

Talend Data Fabric

Talend Data Services Platform

Talend ESB

Talend MDM Platform

Talend Real-Time Big Data Platform

Module

Talend Studio

Content

Data Governance > Third-party systems > Route components

Data Quality and Preparation > Third-party systems > Route components

Design and Development > Third-party systems > Route components

Last publication date

2024-02-21

This scenario describes the usage of Data Sources with DB components in Jobs containing tRouteInput, which can be started only from a Route using the cTalendJob component.

The following procedure shows how to use shared Data Sources with the tJDBC* components as an example. The same rules are valid for all DB components that support Data Sources.

For more technologies supported by Talend, see Talend components.

Procedure

Use the tPrejob to initialize the DB connection with tJDBCConnection.
Configure the tJDBCConnection for the Data Source by specifying the Data Source alias created on the Talend Runtime side.
Use the tPostjob to close the Data Source connection with tJDBCClose.

This is not valid for Data Service operation Jobs that contain the tESBProvider* or tRESTRequest component. In these kind of Jobs it’s not recommended to use the close connection components like tJDBCClose, because closing Data Source connection is implemented in the tESBProvider* or tRESTRequest component directly.
In the main part of the Job use commit or rollback components to control the transaction to the connected DB.
Use the existing connection configuration for all DB components in the Job.
tJDBCRow:

tJDBCCommit:

tJDBCClose: