aetl:processing_data:reader:start

Working with Reader

The Reader extracts data from various data sources.

Every Transformation created must have one or more reader object. 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 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 user has to recreate the mapping for new files/databases.

  • aetl/processing_data/reader/start.txt
  • Last modified: 26/06/2015 11:50
  • by admin
{"cc_re__cc_re__cc_by_sa_4_0": ["          </div>\n\n            </article>\n\n            \n        </div>\n\n    </main>\n\n    <footer id=\"dw__footer\" class=\"dw-container pt-5 dokuwiki container\">\n        <!-- footer -->\n<div class=\"navbar navbar-inverse footer-fixed-bottom\">\n    <div class=\"dw-container container\">\n\n        <div class=\"small navbar-text\">\n\n            \n            \n            <div class=\"footer-license row\">\n\n                <div class=\"col-sm-6\">\n                                        <p>\n                        <a href=\"http://creativecommons.org/licenses/by-sa/4.0/\" title=\"CC Attribution-Share Alike 4.0 International\" target=\"\" itemscope itemtype=\"http://schema.org/CreativeWork\" itemprop=\"license\" rel=\"license\" class=\"license\"><img src=\"https://www.etl-tools.com/wiki/lib/tpl/bootstrap3/images/license/cc.png\" width=\"24\" height=\"24\" alt=\"cc\" /> <img src=\"https://www.etl-tools.com/wiki/lib/tpl/bootstrap3/images/license/by.png\" width=\"24\" height=\"24\" alt=\"by\" /> <img src=\"https://www.etl-tools.com/wiki/lib/tpl/bootstrap3/images/license/sa.png\" width=\"24\" height=\"24\" alt=\"sa\" /> </a>                    </p>\n                    <p class=\"small\">\n                        Except where otherwise noted, content on this wiki is l", "lib/tpl/bootstrap3/images/license/cc.png\" width=\"24\" height=\"24\" alt=\"cc\" /> <img src=\"https://www.etl-tools.com/wiki/lib/tpl/bootstrap3/images/license/by.png\" width=\"24\" height=\"24\" alt=\"by\" /> <img src=\"https://www.etl-tools.com/wiki/lib/tpl/bootstrap3/images/license/sa.png\" width=\"24\" height=\"24\" alt=\"sa\" /> </a>                    </p>\n                    <p class=\"small\">\n                        Except where otherwise noted, content on this wiki is licensed under the following license:<br/><a href=\"http://creativecommons.org/licenses/by-sa/4.0/\" title=\"CC Attribution-Share Alike 4.0 International\" target=\"\" itemscope itemtype=\"http://schema.org/CreativeWork\" itemprop=\"license\" rel=\"license\" class=\"license\">CC Attribution-Share Alike 4.0 International</a>                    </p>\n                                    </div>\n\n                <div class=\"col-sm-6\">\n                                    </div>\n\n            </div>\n\n        </div>\n\n    </div>\n</div>\n<!-- /footer -->\n<!-- cookie-law -->\n<div id=\"cookieNotice\" class=\"navbar navbar-inverse navbar-fixed-bottom\">\n    <div class=\"container\">\n        <div class=\"navbar-text navbar-left\">\n            \n<i class=\"mdi mdi-information text-primary\"></i>"]}