Drag and drop the following components from the Palette: a tFileList, a
tFileInputDelimited, a tMap, a tMysqlConnection, a tMysqlCommit and two tMysqlOutput.
Connect tMysqlConnection to tFileList using an OnComponentOk link.
Connect tFileList to tMysqlCommit using an OnComponentOk link.
Connect the tFileList component to the
input file component using an Iterate link
as the name of the file to be processed will be dynamically filled in from
the tFileList directory using a global
variable.
Connect the tFileInputDelimited component
to the tMap and dispatch the flow between
the two output Mysql DB components. Use a Row link for each for these connections representing the
main data flow.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
