Skip to Content
0
Former Member
Jul 20, 2009 at 11:54 AM

Extracting data from several different applications to one central location

18 Views

Dear Experts,

Greetings!!!!!

I am in process of desiging solution for a requirement. The requirement is as follows.

Requirement:- Currently, I have 20 different applications running on 20 different servers, of which only 3 to 4 of them are integrated with each other and rest of them are running as stand alone. All these applications are running on platforms with OS Windows, Linux, solaris with database in Oracel 9i, 11i, SQL 200, 2005 and some proprietary databases with most of the applications developed on JAVA, .NET, ASP.NET, Weblogic, VC++, Oracle forms 6i

Now, what I want is that data stored in all these 20 different databases to be brough in to one central location or server. Next, we will install one separate server with SAP CRM 2007 with Marketing and data extracted from all 20 application in to central location should be pulled or connected to SAP CRM system. Also, based on data extracted to central location we want to design reports.

Hence request you to kindly suggest how to go about it.

Thanks & Regards

Sharath