Data Reader

About Reader

The Reader is responsible for extracting data from a variety of data sources.

Each transformation must include at least one Reader object. The Reader connects to the data source and extracts data. Depending on the type of data source, some options might not be available. To modify the Reader properties, simply double-click on the Reader object. Readers execute sequentially.

Universal Data Reader

One key advantage of Advanced ETL Processor is the concept of the Universal Data Reader.

Example

You have multiple data extracts from your accounting system, such as:

Text files
Excel files
Access databases

If all files share the same format, including:

Identical field order
Identical field names
Uniform date and number formats

You can use Advanced ETL Processor to switch the connection type without losing any mapping.

Benefits

Unlike other tools that require separate connectors for different databases—and may even sell separate licenses for them—this solution ensures that users do not need to recreate mappings for new files or databases.