What is DMM

Infosistema Data Migration manager is the product that solves the problem of Data Migration within OutSystems environments

DMM enables data migration across OutSystems environments or servers. It is an engine, built from scratch in C#.Net that exposes its functionality over a well-defined API. Since the engine itself does not have any user interface we also distribute several applications to leverage its usage. The most common of these is the forge component that lets users start migrating data with a minimal amount of setup.

In its most basic concept, the DMM just needs two connection strings and a migration configuration file in order to move data from the source database to its destination.

DMM architecture

DMM, as the engine that handles all of the heavy lifting, is at the center. It connects to two databases: the source and the destination database. Both major database technologies are supported—Microsoft SQL Server and Oracle Database. MySQL is also supported but only as a source of information. DMM needs a connection with “read” permissions on the source database and "write" permissions on the destination database.

There are four distributed applications that use DMM to produce and execute data migrations:

  1. OutSystems component, made for OutSystems, is installed from the forge into our customer’s OutSystems environment. It is the simplest way to start producing and executing data migrations.
  2. IIS Web Site with WAPI, distributed directly by Infosistema, allows DMM to be installed in a Windows server machine. In this scenario, DMM is completely independent of the customer’s OutSystems installation.
  3. Windows application is a Windows form that executes a previously saved migration configuration.
  4. Console application executes a previously saved migration configuration. It is very useful in scripting or chain migration scenarios.