Need advice on making universal database solution

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
TPearl
Forum Newbie
Posts: 1
Joined: Thu May 26, 2005 4:30 pm

Need advice on making universal database solution

Post by TPearl »

Here is my situation:

I work in a call center where sales data is tracked for two different teams on two different servers, each with their own database and front end. My agent activity reports are limited to the data for each individual server. Management would like a universal report. The database and front in are both in Access. One caveat is the information is mapped to same drive letter & file names but on two different servers. I don't want to combine the data into one database becuase that amount of data would take too much space. Can this be done in PHP to where the results would not take the literally 20 mintues for access to run a query? I do not know PHP but am willing to learn if I can accomplish this task. Is this something I can construct in a month or two, or is this advanced task? I think a web-based solution would be a great way to make sure everyone has a user-friendly interface and easy access to our information. Let me know what you think, or if there is a better solution.

Thanks,


Thomas
Roja
Tutorials Group
Posts: 2692
Joined: Sun Jan 04, 2004 10:30 pm

Post by Roja »

http://adodb.sourceforge.net/ will do exactly what you need. It will allow you to connect to multiple database sources (of multiple types), and access the data in php to do with as you please.

I recently completed work connecting to access files via odbc using adodb. Of course, you could also simply use the native php odbc calls.
Simulacrum
Forum Newbie
Posts: 13
Joined: Wed Apr 13, 2005 11:58 pm

Post by Simulacrum »

You could create linked tables in Access DB1 to Access DB2. That would then let you create Access Query objects that could span both databases.

The Access report builder is also pretty good.

At the very least you could offer a simple Access report to begin with, and then look at making this available through the web later.

I wouldn't advise doing everything in PHP, unless the report requirements are very simple.
Post Reply