Database merging

Issues:

Database merges happen when two organizations —banks, firms, institutions, private health insurance companies— merge and have their own databases, which are hosted on the same or different applications.

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

  • reassign ID numbers in order to make them consistent and unique.
  • standardize settings
  • deduplicate people, companies, third parties…

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

In many cases, it is also necessary to take into account the ‘private gardens’ or application features of each organization

Our Offer:

Our industrial approach makes it possible to formalize the fusion rules in an exhaustive and consistent way and then to generate the programs from these data transformation and fusion rules.

The finished product is more reliable and available more quickly.

The rules can be adjusted or modified independently of one another and without questioning the general schedule of the project.

Our Tools:

Our way of approaching Projects with the decision of providing them with strong tools, allows us to move towards the automation of a large number of operations.

To do this we rely on the modules of our RECODE DATA suite, which allow in particular to audit data, to increase the control of the perimeters to be treated and to provide data recovery (multiple indicators allowing to measure the progress of sites and to highlight anomalies, etc …), all of these things are essential to the successful completion of the Projects.

Applications:

Information system convergence

Reduction in the number of IT production corridors

Lower IT costs

Merger of operational or legal entities

Environments:

We work in all kinds of IT environments.

Operating systems (OS): MVS, DOS VSE, VM, GCOS 7, GCOS 8, VMS, UNIX, AS400, WINDOWS, HP3000…

Database Management systems (DBMS): DB2, ORACLE, SYBASE, SQLserver, SQL, INFORMIX, DL1, IDMS, IDS2, ADABAS, DATACOM, IMAGE…

We have strong functional skills in Banking, Insurance, Life insurance, Pension systems, Retail, Human Resources…

Business Cases

Business Cases

MACIF
IBM Mutual Migration to Cegedim Activ Infinite
Learn more
Logo Banque Populaire (Rectangle)
Banque Populaire
Migration and Mergers Service Center
Learn more
ANFH
Migration and Deduplication of the Agent repository
Learn more
Logo ACOSS
ACOSS (French Central Agency for Social Security Organizations)
Webservices Migration
Learn more