Set up Data Source

An ETL file supports using the database table and the text file as data source. Follow the directions to set up the data source:

Database Table

  Connect to a database through Tool -> Connect to Data Source, and all tables in the database will be automatically listed on the right panel. To connect to the built-in demo source, for example:

To add data to the ETL interface, select a database table and drag it directly to the right panel. To use EMPLOYEE table, for example:

Below is data in the EMPLOYEE table:

Text file

You can also use a text file of txt/csv format as the data source in the ETL interface. Set up the file path under Data Path and then drag it to add file data to the ETL panel. To use department.txt as the source, for example:

Below is data in department.txt:

When there are multiple source tables in the ETL interface, you can change their positions through Edit menus or click buttons () on the toolbar, or delete a selected source table using  button.