Working with Reader

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 Processor is 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.

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

Confused? Ask question on our ETL Forum

  • aetl/processing_data/reader/start.txt
  • Last modified: 26/06/2015 11:50
  • by admin