Advanced-etl-processor
Working with Reader
About 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.
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.
Video Tutorials
For more technologies supported by our ETL Software see Advanced ETL Processor Versions