Example CSV File Source

(1) Specifies where the source data comes from (file, database, clipboard, custom). Important note: The source data is always read in line by line.

(2) This allows later sources (in subsequent tasks) to access files created here.

(3) The absolute path of the source is expected here. A dynamic path can be created with the help of the ETL/ELT system variables BASE_PATH or TEST_PATH and self-created ETL/ELT variables. Important note: Please note the procedure when using a remote server!

(4) Marks that the header row contains column names. This way the first row will not be used in actions.

(5) Here you can specify a search term (regular expressions are allowed) to filter rows. If the search term matches a line, this line will be used, otherwise not. Note: Specify test data (in the field below) and execute a query to test your search term.

Example SQL Database Source

(6) The alias of the database source. You can use the SQL console button to execute an SQL query on the it. Important note: Please note the procedure when using a remote server!

(7) With the help of the wizard you can select tables and fields of the selected database and have an SQL query generated, which can be customised if necessary.