Read data from files in an FTP server and store it in a MySQL database.
Read data from files in an FTP server folder and store it in a table in a MySQL database.
Variables
Credentials to use to access the FTP Server.
Path to the folder containing files to load.
Enable to load files within subfolders under the Source Folder.
Number of load records to examine, from most recent and going backwards, when comparing to determine which files have not yet been loaded. If no value is specified, all load records will be examined.
Number of files to include in each load.
Format of the data in the files to load.
Number of rows to ignore at the beginning of files with delimited data format.
Character used to separate data values in files with delimited data format.
Specify the character used to enclose string data values in files with delimited data format.
Characters used to represent a null value in files with delimited data format.
Character used to represent an escaped value in files with delimited data format.
Characters used to represent the end of a line in files with delimited data format.
MySQL database where the data from the files will be loaded.
Table name, in schema.table format, where the data from the files will be stored.
Column within the Target Table where the path to the file that was the source of the data will be stored.
Mapping between the source file columns or JSON paths and MySQL columns.