Advanced ETL Processor: Working with data reader

Advanced ETL Processor introduces concept of Universal Data Reader which allows using the same transformation for various data sources.

This simple tutorial demonstrates the benefits of using Universal Data Reader

---

Closed Caption:

welcome to advance ETL processor online
tutorial
today we will be talking about working
with data reader
datareader objects supports nearly two
different data sources and that number
is constantly growing
let's have a look at what we can do with
the text files
we can work with delimited or fixed with
files
we can set file encoding
1
benefits of using advanced ETL processor
that it supports multiple line
terminators that allows the user to use
same transformation to process Windows
and Unix text files
we can also spend
center and voter
of it of working with advanced ETL
processor its ability to process
multiple files and tables using masks
here we can see how many records we
would like to process and how many fears
files to read
led selected text
cell
there are several ways to
source file metadata
by default it uses automatically
generated field names same for weed
we can change it manually or we can
reformat created by using audio format
function
we can assign the fields now
here we are saying that we would like to
take field names from the line number
one
another way of changing source file
format is to edited
lets IT field legs 240 for example
or we can rename the fields
this option only works for files not the
database tables
another time saving benefit of using
advanced ETL processor is copied fields
option
it is also possible to swap the reader
and writer
as you can see the software was designed
to make life of end users easier
our competitors create separate reader
or connector for every data source
connection
that makes life easier for developers
but not for the end users
imagine the following situation
you work for a software company which
develops CRM system which works with
Oracle sequel server and my sequel
you are exporting sales data from Oracle
your boss just asked you to do the same
for MySQL
provided that field names and field
order is the same all you need to do is
to switch connection type
with our competitors solutions you would
need to delete Oracle Connection and Mya
SqlConnection and redo all the mapping
thank you for your time please visit our
website for more tips