Every Advanced ETL Processor Transformation must have one reader object. Reader connects to the Data source and extracts data from it. Depending of Data source type some options may not be available. To change Reader properties click or double click on the Reader object.
Universal Data Reader
One of the benefits of using Advanced ETL Processor is a concept of Universal Data Reader
Consider following scenario:
You have several extracts from your accounting system
Text files
Excel Files
Access Databases
All files have 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 connection type no mapping will be lost.
Other tools use different connector for different databases and some of then even sell separate licences for them. That mean that user have to recreate mapping for new files/ databases.
Loading Data from Text Files Loading Data from MS Access or Excel File Loading Data from Dbf File Loading Data from ODBC Datasource Loading Data from MS Excel Database
