# Looking for advice in how to build this project

**URL:** <https://www.ruby-forum.com/t/looking-for-advice-in-how-to-build-this-project/91354>\
**Category:** Rails\
**Created:** [April 7, 2007, 8:22am UTC](https://www.ruby-forum.com/t/looking-for-advice-in-how-to-build-this-project/91354 "2007-04-07T08:22:10Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jsn1](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/7ea924/32.png) [@jsn1](https://www.ruby-forum.com/u/jsn1)\
**Post date:** [April 7, 2007, 8:22am UTC](https://www.ruby-forum.com/t/looking-for-advice-in-how-to-build-this-project/91354/1 "2007-04-07T08:22:10Z")

</div>

Hi all,

I need some ideas for designing a solution for the following project.  
There are 10 applications developed in Ms Access, Ms SQL, and Oracle.  
All of them are stand-alone applications that use their own tables and  
do not share anything with any other application. Some of the tables  
used in these applications are very similar, and some of the information  
is duplicated.

The project goal is to integrate these 10 databases/applications. To  
make them share data, in a way that a user could get a summary report  
with data from 3 applications, etc.

How will you do that?

Thanks