The Reader extracts data from various data sources.
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.
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
All files have the same format such as:
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.