data-migration-manager-dmm
Web icon

Data Migration Manager (DMM)

Stable version 8.3.1 (Compatible with OutSystems 11)
Other versions available for 10
Uploaded on 17 Apr (20 hours ago) by 
4.7
 (79 ratings)
data-migration-manager-dmm

Data Migration Manager (DMM)

Details
Data Migration Manager is a robust, cost-efficient, and intuitive data management solution.
DMM - Data Migration Manager enables you to reduce costs by saving hundreds of hours that were spent in building custom scripts, allowing you to increase quality and unprecedented flexibility and speed in managing your data.
DMM enables data and BPT migration across/into/out of OutSystems environments (onPrem, Hybrid, Cloud, PaaS), databases (mySQL, Oracle, SQLServer) and OS versions (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 other's 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 - NOW FREE!

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


Release notes (8.3.1)

NEW DMM FEATURES:

in v8.3.1 – Hotfix for Export and Migration features.

in v8.3.0 – Performance Improvements, AO count reduction, and more (see Captain's Log for details). Also check out the new DMM Quality Assurance!

in v8.2.0 – New features of automatic setting User Mapped Tables using the entity's unique indexes; new automatic tenant selection filtering; more corner cases supported, minor feature improvements and bug fixes

in v8.1.1 – Hotfix for Migration by module feature.

in v8.1.0 – Performance improvements in the application migration interface and in Oracle database migrations, update World Lookups by entity, new corner cases supported and bug fixes

in v8.0.1 – Hotfix for Export feature.

in v8.0.0 – New solution World Lookups, to help your development team! Now you can use DMM to populate common lookups in this new Forge component World Lookups!

Please check the detailed version change log in DMM's Online Manual


You have in DMM's free version features like the:

- DATA DELETION (NEW in the FREE VERSION; you can now BULK DELETE for FREE!),

- DATA COMPARATOR,

- PLATFORM HEALTH CHECK,

DATA ANONYMIZATION & more!


DMM - Data Migration Manager 


Detailed version change log in DMM's Online Manual

RUN EXPORTS & MIGRATIONS WITH SCHEDULED TIMERS OR BY API CALLS: You can now schedule executions (migrations & exports) either using OutSystems Timers (use the demo app) or through an external scheduler solution making calls to DMM's WAPI.

MIGRATE OUTSYSTEMS SITE PROPERTIES! With lots of OutSystems clients going to the PaaS Cloud, moving between datacenters or simply segregating pipelines, we've received several requests to augment DMM to be able to migrate also OutSystems Site Properties - you can do it now just as easily as migrating the data!

EXPORT DIRECTLY TO NON-OUTSYSTEMS DATABASES! With DMM you can now export data from OutSystems directly into any SQLServer/AzureSQL database, DMM will create and maintain the needed database structure and connections. Get your OutSystems data, even from the PaaS, into your analytics or data lake directly!

COMPARATOR: Now you can use this feature for FREE to get a comparison report between 2 different OutSystems databases. You can see the counts of total records per entity; data schema comparisons; relationships/FKs comparisons.

HEALTH CHECK: Now you can perform for FREE a health check on your OutSystems environment, validating the metadata and physical table structures, with 8 separate checks!

AUTOMATIC TENANT FILTERING: You can quickly and visually filter the data to be migrated/deleted by tenant without the need to specify filters in each entity.

SMART USER MIGRATION: Now you can choose if you want to migrate only users that are linked to data that is being migrated (instead of all users, as in previous versions).

MULTI-COLUMN USER MAPPED TABLE: If your database connection doesn't allow for identity insert (changing data IDs), DMM allows you to define the entity keys for the migration operation.

EMAIL MIGRATION: When migrating BPTs, you can tell DMM to also migrate all your emails in the OutSystems environment!

BULK DATA IMPORT: Use DMM to import data into OutSystems from external sources – get all those legacy apps data into OutSystems without any worries!

DELTA/INCREMENTAL MIGRATION: This mode allows migrations to only update data in the destination that was changed (added, deleted or updated) in the source since previous delta migrations executions!

BPT MIGRATION: Infosistema DMM can migrate BPT data between environments using the same User Interface. All BPTs can be migrated, even those that are not linked to an entity.

DASHBOARD: DMM offers an entry dashboard with relevant insights about your OutSystems database - please do give us feedback! :)


Better and Faster: We've upgraded our migration engine, improving performance in several additional use-cases - DMM reinforces its position as the only available solution for Enterprise grade highly complex and high volume data migrations!

Plus: DATA EXPORT (either to import into an OutSystems environment, or a "clean" export to an external solution like data warehouse/data lake); DATA DELETION (with any filters); DATA BROWSING (including metadata information); FREE DATA ANONYMIZATION

License (8.3.1)

This is a proprietary solution, not open-source. 

So neither the source nor binaries can be redistributed. 

It isn't allowed to execute reverse engineering in the solution also.

Reviews (29)
by 
28 Feb
in version 8.2.0
Excellent Data Migration tool for my DBAs who love it... but the offline licensing process is one of the worst I've used.  Very buggy and probably doesn't need much work but it's like they want to force you to online (which will never be an option for us due to regulation).  
Answer from the owner
28 Feb
in version 8.2.0
  Dear Jon,
  Thank you for your evaluation and feedback!

  Please reach out to our DMM support, reporting any UX improvements you feel are needed on the DMM activation process for offline/off-grid OutSystems environments.

  I know we added some explaining text in the screens of that DMM offline activation process not long ago.
  We do not have many clients were their OutSystems platform doesn't have internet access and can't access our license control server (doing a simple 1-time process of online activation of DMM licenses), so we're interested in hearing your take on alternatives/improvements you feel could be made to the offline activation process.

Thanks!
by 
2023-04-04
in version 6.7.1
Excellent migration tool for OutSystems platform.  Reduces complex migration from weeks to days and hours. Proactive and prompt support 
by 
2023-04-04
in version 6.7.1
Good job. Very flexible, a very wide range of possible connection ways. User friendly, perfect statistics. And a very good support.
Team