Talend component to parse a SQL script.
You can define the SQL script inside the component SQL field or read the script from a file.
Use the Iterate flow from the component to trigger the run for the statements (statement by statement) in a tDBRow component. The tDBRow component can take the current single statement from a return value of the component.
Very simple example:
Example with prepared statements (setup the parameter value happen in the tPostgresRow component):
Better design with a separate connection component and a proper transaction handling:
Here a design of a generic job running SQL scripts:
