Working with Reader

About Reader

The Reader extracts data from various data sources.

Reader Options

Every Transformation created must have one or more reader objects. The Reader connects to the Data source and extracts data from it. Depending on the Data source type some options may not be available. To change the Reader properties double-click on the Reader object. Readers are executed sequentially.

Universal Data Reader

One of the benefits of using Advanced ETL Processoris a concept of Universal Data Reader

Consider the following scenario:

You have several extracts from your accounting system

  • Text files
  • Excel Files
  • Access Databases

All files have the same format such as:

  • Same field’s order
  • Same field’s names
  • Same date and number formats

Provided that you are using Advanced ETL Processor all you need to do is to change the connection type no mapping will be lost.

Other tools use a different connector for different databases and some of them even sell separate licenses for them. That means that the user has to recreate the mapping for new files/databases.

Reader Data Sources

Video Tutorials

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum
Last updated: September 17, 2022