Extract Transform Load

“ Extract-Transform-Load ” is known under the term LTE (or sometimes: datapumping ). It is about a data-processing technology Intergiciel it (to include/understand Middleware ) making it possible to carry out massive synchronizations of information of a Database towards another. According to the context, one will translate by “food”, “extraction”, “transformation”, “constitution” or “conversion”, often combined.

It rests on connectors being used for exporting or importing the Donnée S in the applications (Ex: connector Oracle or SAP…), of the transformer which handle the Donnée S (aggregations, filters, conversions…), and of the put in correspondence ( mappings ). The objective is the integration of the company by its Donnée S.

In the beginning, the solutions of LTE appeared for the regular loading of Donnée S incorporated in the warehouses of data (or datawarehouse ), before diversifying towards the other software fields. These solutions are largely used in the banking and financial world, like in industry, within sight of the multiplication of the many interfaces.

Complementary technologies appeared thereafter: EAI ( Integration of applications of company ), then ESB ( Enterprise Service Drunk ).

There exist also solutions of LTE of contents making it possible to handle data not structured such as the files and the documents. These solutions are used for projects of migration of documents. For example, during migration of documents that an application GED towards another. Their field of application can also extend to projects from electronic Archivage.

See too

Random links:Motazilism | Alain Chartrand | Agila Ier | The Eternal Idol | Synagog Beth-El (Pensacola, Florida) | Calwa,_la_Californie