MixDEM for web integration and mashup edition

Introduction

MixDEM is a metadata driven data Integration tool which can be used to preform "Extract - Transform - Load" to build DataWarehouse or it can be used for Data Migration or mashup edition.

MixDEM is a PHP based ETL framework and can be used standalone as an application run from command line or embedded into your application. MixDEM is accompanied by MixDEM GUI Editor an AJAX development framework and a set of tools that enable developers to quickly and easily create mashup applications or performing some massive data transformation projects in a few lines of code with a really simple declarative XML tags. MixDEM have too an API web service .

MixDEM is based on the so-called Transformation Graph. Transformation Graph is a set of certain specialized components, which are interlinked via data pipes. Every such component performs certain operation (database extracts, output to Excel file, data sort, filtering, FTP transfer, etc.). Data processed by MixDEM flows through the transformation graph and is step-by-step transformed into the required format. While performing the transformation, data can be merged, sorted, split or enriched in many other ways.


Typical applications for MixDEM

  • Data migration ( Data migration is the process of transferring data between storage types, formats, or computer systems. )
  • Data collection ( Data collection is a term used to describe a process of preparing and collecting data - for example as part of a process improvement or similar project. )
  • ETL for Data Warehouses ( Extraction, Transformation and Loading. Activities required to populate data warehouses and OLAP applications with clean, consistent, integrated ... )
  • Data integration ( Data integration is the process of combining data residing at different sources and providing the user with a unified view of these data )
  • Mashup edition ( Mashup editors provide a visual interface to build a mashup, often allowing the user to drag and drop data points into a web application. )

MixDEM is a Framework