Working with Data Reader

Advanced ETL Processor Reader object  extracts data from various datasources.

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 Files
   Loading Data from Dbf or FoxPro Files
   Loading Data from ODBC Datasource
   Loading Data from MS SQL Server 6-2008 database

About Advanced ETL Processor

Advanced ETL Processor is a Codeless ETL Tool.
It is designed to automate extracting data from ANY database, transform, validate it and load into ANY database .

Users can create Data transformations and Sql scripts add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis

By combining simple Package actions together Advanced ETL Processor helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.

Feel free to try Advanced ETL Processor today. All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

Watch Online Flash Demo
Download Advaced ETL Processor now