Merging databases or migrating multiple databases into a single database

Issue

Merging databases happen when two organizations —banks, companies, institutions, private healthcare companies— merge but still have their own databases hosted on the same or different applications.

All databases have to be merged, which technically requires to:

  • Update ID numbers
  • Standardize parameter setting
  • Deduplicate natural persons or legal entities, third parties, etc.

If management systems are different, it is necessary to previously migrate data to a shared system.

In most cases, it is also necessary to take the ‘private gardens’ or special applications of each organization into account.

 

Methodology

We standardize the delivery and management of IT services. As operations are automated, it is possible to write out merging rules in a coherent and exhaustive way, then generate programs on the basis of the overhaul and merging rules.

The end product is more reliable and more quickly available.

The rules can be refined or altered independently of one another and without questioning the general schedule.

 

Environments

We can work in all IT environments with our technology:

Operating systems: MVS, DOS VSE, VM, GCOS 7, GCOS 8, VMS, UNIX, AS400, WINDOWS, HP3000, etc

Database Management systems: DB2, ORACLE, SYBASE, SQLserver, SQL, INFORMIX, DL1, IDMS, IDS2, ADABAS, DATACOM, IMAGE, etc.

We have strong functional skills in banking, insurance, life insurance, pension planning and funding, retail, human resources, etc.

 

References

Banque Populaire, Caisse d’Épargne, Crédit Agricole, etc.