Infosistema DMM

Stable Version 4.3.3 (O11)
Also available for 10
Published on 19 Nov (5 days ago) by 
Created on 17 November 2017
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 and data scramble, 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?

  • Do you want to copy data from non-OutSystems apps into OutSystems apps?
  • 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?
  • Did you upgrade servers, migrate apps but now you need to migrate the data?
  • 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 data from the Qual to Prod Environment to populate configuration or setup data?
  • Need to migrate from Prod to Qual to replicate situations that need fixing or doing some performance testing?
  • 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 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?


Infosistema DMM Features:

Support for Microsoft SQL Server and Oracle Database (and MySQL)

You can set up your migrations between databases in both technologies. It is even possible to set up a migration from one database technology to another, SQL Server to Oracle or on the other way around. We've added a new driver to allow migrations from MySQL databases. As this technology will soon stop being supported by OutSystems, 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.

Scrambling and Anonymization

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 or simply to archive it.

Data source Filtering

DMM allows you to define filters to apply during migration thus allowing full control of what is migrated between environments.

Automatic detection of table 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.

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.

Data migration in chunks

A brand new microinstruction engine with parallel executions will increase performance on large table migrations, as it will allow for parallel migration in chunks.

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.


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:

  • Ensure that IIS user has read and write permissions on the folder:  "C:\Program Files\OutSystems\Platform Server"
  • User Manual available here


What’s new (4.3.3)

BPT Migrations (Beta): 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: you can expect a gain up to 7x on migration speed due to internal engine changes.

Plus: Bug fixes on the scramble engine, minor UI improvements, more accurate log messages 


We recommend Oracle customers to skip this version

Reviews (13)
20 Aug
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.
8 Apr
in version 4.0.1
Good people behind the Technology.
Very helpful in delivering the solution to our customers.
18 Mar
in version 3.3.2
I recommend it! Definitely something to use if you're in need of data management in OutSystems! You can do all tasks visually, no need for any coding or scripting, the component does it all for you.
Category
Applications, Developer Tools
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 6 dependencies
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
Component Consumers
No consumers yet.
Weekly Downloads