ETL+ Source Driver for Text Files (.CSV)

Creates and manages Source Objects that connect to CSV files. The CSV files can be on a local folder or on a web page.

Text File Page

• Alias. The name for the source object shown on the Source Objects panel. Unless customized the name will be automatically generated based on the last folder (directory) in File Path.

• Schema. Inactive.

• File Path. Enter a local file path containing the .csv or .txt files, a internet URL, or IP address.

  • The driver selects all files in the File Path with .csv or .txt extensions.

  • The driver treats files with .txt extensions as csv files.

  • To connect to files on a network see also Source Driver File Path for Network Files.

• Browse. Browser function to local the File Path.

• Delimiter. Always dimmed.

• First Row has Column names. Checkbox is always dimmed but always selected.

• Back. Leave the page without saving or attempting to connect.

• Connect. Connect to the Text File source. Same function as Refresh.

	Help
	Change DataSource. Only shown when opened by Properties.

Examples

The .csv files recognized by the driver are based on the File Path. In this example the File Path C:\Users\Public\ETL+ Beta\CWTests contains the files csv1.csv and csv2.csv.

Connecting to the csv1.csv file

How to Add Connections to .CSV Files

1. Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.

2. Select Add Source > Text File

For more see the Text File Page section above.

How to Maintain Text File Connections

1. Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.

2. Select a Text File based Source Object on the Source Objects panel.

3. Select Properties

For more see the Text File Page section above.

CSV Data Format

A CSV (Comma-Separated Values) file is a simple and widely used file format for storing tabular data, such as spreadsheets and databases, in a plain text format. CSV files are commonly used to exchange data between different software applications, databases, and platforms due to their simplicity and ease of use.

Related ETL+ Pages

• ETL+ for CSV and Text Files

• Text & .CSV Data Sources Technical Details The version of SQL to use on the Extract SQL Statement panel with data accessed with the ETL+ Source Driver for Text Files.

• Source Objects panel

• Target Objects panel

• Extract SQL Statement panel

• https://dataself.atlassian.net/wiki/spaces/DS/pages/edit-v2/1928527873 - Date() and other SQL expressions supported

• ETL+ Design Page

• Source Driver File Path for Network Files To connect to network drives or files.

Position in the ETL+ Interface

• Extract, Transform and Load (ETL) page

  • Source Objects panel

    • Add Source, Properties or Refresh buttons