The Text File source driver can import .csv format files.
Connecting to CSV and Text Files
Currently, these must be comma delimited text files, with the first row with Column headers.
If you haven’t installed ETL+ yet: ETL+ Deployment Instructions.
Login to ETL+ (help here).
Add new .csv files: Select Add Source > Text on the Source Objects panel.
Maintain a text source: Right-click the text source object > Properties.
On the Text File page:
Alias will be automatically populated, but you can customize it.
Enter a local file path containing the .csv or .txt files or …
use Browse or …
enter a internet URL address.
Supported Excel formats: TXT, CSV.
You’ll get back to the ETL page and see tables under the selected text source on the left panel.
Mapping and Loading Tables
To view tables available from a text source on the left panel, right-click the text source →
To map a text table to the data warehouse,
double-click its nameon the left panel, or right-click on it →
You’ll now see the table added/mapped to the center panel.
To preview its data, right-click the table on the center panel →
To load its data to the data warehouse, right-click the table on the center panel →
Logicon (top right) to view data load results. Log page help here.
Schedule the Data Load
On the ETL main page, click
Refresh Batch(top right icon on the center panel).
Select a Refresh Batch or create a new one to load your text data on a schedule (help here) → on the right panel, be sure the text tables to load have their boxes checked and in the desired load order.
To load them now, click the
Refresh Batch Now(play icon) on the left panel for the desired Refresh Batch.
To schedule the data load:
WTS Settings-> enter the WTS parameters →
This step might require you to run ETL+ app as “Run as administrator” in Windows.
After ETL+ has loaded your text files, this is to check if the data extraction process finished successfully and row count per extracted table matches with your text tables.