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:
Related concepts
Related information