Infosistema DMM

Stable Version 5.1.5 (O11)
Also available for 10
Published on 26 Feb (3 days ago) by 
Created on 17 November 2017

Infosistema DMM

Details
Infosistema Data Migration Manager (DMM) - With DMM you reduce costs by saving hundreds of hours building custom scripts, increase quality and allow unprecedented flexibility in managing your data. DMM enables data migration across and into OutSystems environments or servers (v9 , v10 or v11) using a simple user interface without the need of building custom scripts. It also supports features like data anonymization, data scramble and data deletion, essential to comply with GDPR.
Read More

What is Infosistema DMM?

How much can an error in production cost your company?


What if I have a mixed environment between cloud/onprem?


Why do you need DMM?

How about to stop those situations where you say  "but it worked in my dev environment - why doesn't it work in PROD?!"

  • Want to have a better Dev environment with production data so that you’re able to catch errors and problems earlier in your development cycle?
  • Need to migrate from Prod to Qual to replicate situations that need fixing (including BPT migration!) or doing some performance testing, or just saving your QA team lots of time in creating good data for QA testing?
  • Do you want to copy data from non-OutSystems apps into OutSystems apps?
  • Are you changing your OutSystems installations tech stacks (between mySQL, Oracle, SQL Server; or Java & .NET) or environments (Cloud, On-prem or hybrid) and now need to copy the data between installations?
  • Do you have GDPR/data protection issues, for example does your Data Protection Officer (DPO) requires you to guarantee the right to be forgotten for client’s data in Production? Or you cannot delete the data without major impact, and would rather encrypt or mask it?
  • Do you have a good amount of data in QA or Dev environments so your development and testing takes into account right from the start performance issues and different conditions (including BPT) similar to the PRD environment?
  • Did you upgrade servers, migrate apps or updated the Outsystems version in a parallel environment but now you need to migrate the data?
  • Need to migrate data from the Qual to Prod Environment to populate configuration or setup data?
  • Do you have a huge database on which most information is non-critical, but there is a small critical app/database that you need to have a backup frequently (for example, your DRP requires lost information to be under minutes and a full database backup is not applicable)?


Infosistema DMM Features:

Product based approach

DMM is product based, with ZERO services involved, you can download it from the Forge and try it out with free executions, and then acquire a license (trial licenses also available upon request). 

We keep continuously improving the product with feedback from all our clients and partners, so all the ecosystem benefits from the others feedback! :)

Data and BPT Migration across OutSystems Environments

Migrate both Data and BPT across different OutSystems environments (PRD, QA, DEV), different OS versions (v8 to v11), different database stacks (Oracle, SQL Server, MySQL) and architectures (cloud, on-premise,  hybrid, OutSystems PaaS), seamless and out-of-box!

Import data from non-OutSystems sources

Import into OutSystems any and all entities data from legacy solutions using DMM to guarantee the data consistency, transformation and migration speed.

Data migration in chunks with TOP SPEED

A microinstruction engine with parallel executions increases performance on large table migrations, as it allows for parallel migration in chunks, and direct connections to databases create a high performance architecture. 

DMM has been validated as the fastest solution (by an order of magnitude) for data migration available, making it the best solution for highly complex Enterprise level OutSystems installations with 100+ interlocked applications with hundreds of GB of information.

Data Manipulation - Scrambling, Anonymization, Replacing, Cleaning

This feature ensures the transformation of data during migrating to the destination or applying directly to a database of choice.

With scrambling, data will keep its semantic value but will not have a correlation to the source data, i.e. an email field will hold text that looks like email addresses, which may even be valid email addresses, but ones that will not exist in the source data. The same applies to dates, names, credit card numbers, bank account numbers, phone numbers, zip codes, etc.. This allows for the information shown in an app canvas to look “correct”, although it’s not “real”.

Using anonymization will cause the destination values to become a meaningless garbled text, which ensures the process complies with GDPR.

Exporting

You can extract data from your OutSystems environment and download it in CSV format that is ready to be used in any ETL processes you need (like automatically loading OutSystems information into an ERP or CRM platform) or simply to archive it for a DRP process.

Data Filtering

DMM allows you to define filters to apply in the executions, for example in a migration, export or deletion/cleaning process thus allowing full control of what is being done. You can clean a destination database before loading it with data from another instance source, for example.

Support for Microsoft SQL Server, Oracle and MySQL databases

You can set up your migrations between databases in different technologies. It is even possible to set up a migration from one database technology to another, SQL Server to Oracle or the other way around. 

We've added a driver to allow migrations from MySQL databases - as this technology will soon stop being supported by OutSystems with v11, we only support using the driver as a source of information. We believe it will be useful on all OutSystems installations in OS10 over MySQL that need to move to OS11.

Automatic detection of entity dependencies

At configuration time DMM will check your picks and suggest other entities that should also be migrated to guarantee data consistency. With the improved application migration support the user no longer needs to cherry-pick entity by entity which ones they need to migrate. They can now simply pick one or more applications and Infosistema DMM will automatically handle all dependencies and relations.

User Mapped Tables

This new feature allows for mapping of a unique column instead of using the ID column as a key. This lets you merge existing tables that may be referred to by entities not being migrated without impacting those entities.

Multiple Frontend Support & Secure Access

DMM works with OutSystems installations with multiple frontends, and access to the component is securely managed out-of-box.  

Execution and execution history User Interface

The separation between configuration and execution allows setting up an automation for actions you do repeatedly. The refreshed User Interface will help users to better grasp what's going on and what happened during previous executions.


Contact Information:

solutions@infosistema.com or visit DMM web page


Case Studies:

Check out how our clients are taking advantage of DMM.

https://www.infosistema.com/dmm-data-migration-manager/case-studies/


Note:

  • User Manual available here


What’s new (5.1.5)

Delta Migration (BETA): This mode allows future migrations to only update data in the destination that was changed in the source from previous delta migrations executions. All migrations must be made with this flag.
BPT Migrations: 
Infosistema DMM is now able to migrate BPT data between environments using the same User Interface. All BPTs can currently be migrated even those that are not linked to an entity.
Better and Faster: We've redone our migration engine almost from scratch, you can expect a gain up to 7x on migration speed due to those changes.
Reporting: Major improvements on the reporting page that provide better feedback on Infosistema DMM executions
Plus: some minor bug fixes and several UI improvements

Reviews (14)
2020-12-07
in version 4.3.15
DMM was the key to the success of the stack Java to .Net migration project, in which we had to migrate data in several environments (DEV, INT, QA) and merge 2 production environments (65Gb of data migrated).
2020-08-20
in version 4.0.10
DMM is a promising product that will help us during our larger OutSystems projects. Moving data back and forth, whether or not anonymized, plays an important role in these projects.
2020-04-08
in version 4.0.1
Good people behind the Technology.
Very helpful in delivering the solution to our customers.
Category
Functional libraries & utilities, Database
Tags
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from Infosistema Solutions who created this component.
Dependencies
See all 5 dependencies
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
Component Consumers
No consumers yet.
Weekly Downloads