Close





Lost Password?
No account yet? Register
Increase font size Default font size Decrease font size Narrow screen resolution Wide screen resolution Auto adjust screen size default color red color blue color yellow color orange color

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.

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

 
 

Testimonials

My boss told me to keep looking for a more expensive application, assuming Visual Importer ETL couldn't be very good because the price was just too low.  After testing several imports I convinced him that Visual Importer did everything we want so there was no need to pay for a more expensive solution.

Ron Bradshaw,
IT Reporting Manager,
ConAgra Foods / Lamb Weston
 

Free Newsletter

Please provide your Name and Email address so that we can tell you about latest releases, new features and free offers.






b.150.100.16777215.0..Screenshots.AdvancedETLPro.Advanced_ETL_Processor_Pro.jpg
DB Software Laboratory - Intel Software PartnerDB Software Laboratory - My SQL Ready Partner
DB Software Laboratory Embacadero Technology Partner