Merging/mapping and or integrate on database level
From: OSteine <osteine_at_gmail.com>
Date: Thu, 3 Mar 2011 00:07:10 -0800 (PST)
Message-ID: <96c6703d-72fc-42e9-b5c3-1a2e9502aa57_at_p24g2000vbl.googlegroups.com>
I've got the following scenario:
Date: Thu, 3 Mar 2011 00:07:10 -0800 (PST)
Message-ID: <96c6703d-72fc-42e9-b5c3-1a2e9502aa57_at_p24g2000vbl.googlegroups.com>
I've got the following scenario:
Two applications with their own database needs to be integrated on some common basic data (let's say person data). When the ApplicationA enters a new users, this user should also be available in ApplicationB.
Using a replication method, I've completed the flow of data between the databases, so that all tables are available in the database schema for ApplicationB.
personA [id_person {int}, sur_name {varchar40}, last_name{varchar40}]
- table definition
personB [id {char10}, fullname{varchar60}, lastname{20}, surname{40}]
- table definition
What would be the best approach to share the data between the two application?
- Adjust (if possible) ApplicationB to use the personA table?
- Use a interface table int_person which may be used to map and distribute data between the tables
- Other solutions???