Extract
the process of extracting,reading or getting data from a variety of data source like database, file, stream or even programmatically generated memory data.
the process of converting the extracted data from its previous form into the one it needs to be in so that it can be transferred or stored into other data store. Generally, transformation are done by using defined rules. These rules can be for simply migrating data from one source to another or for building up a whole new data by combining multiple data sources with complex converting business logic.
Data Sync Manager™ (DSM) is the outcome of our unique approach
to accommodate not only traditional ETL functions but also demanding requirement of modern data integration, analytics
and business intelligence projects.
Throughout data integration projects of various IT organizations, we have been able to prove DSM can seamlessly handle
data integration, migration and BI analytics problems.
Scalability and cost-effectiveness have not been considered in conventional ETL,
which becomes important factors in a distributed and multi hetero-geneous system environment.
Even though, it is possible to process the Big Data using the conventional ETL tool previously mentioned,
there are tools designed to fit into it like Hadoop which provides more cost-effectiveness, scalability
while dealing with storages of massive information in a variety of forms of data.
From ETL's perspective,