Program To Centralize Databases?

by 7 replies
8
I have a client who want to centralize the data from
3 sites I built for them.

The First site is the main domain and it sells products and services.

The second site is an add-on domain and it is a public info site
for a health niche. It also has a database of 500 doctors with
their address and website location on a Google Maps applidation.

The third site is a paid membership site in a sub-diectory under the
add-on site. It also has a forum.

All 3 sites are on Wordpress with a seperate admin in each.

My client wants to be able to have on centralized area where she
can look at the data (tracking sales, doctor information, membership
expiry and renewal) from that one place and edit that data.

Is there such a program/software/application to tie all 3 together?

I very much appreciate any help

Thanks
Jack
#programming #centralize #databases #program
  • Since it seems like they will all be on the same server and assuming you are using cPanel, you can access the data through phpMyAdmin.
    Now since everything they want is really a custom display of the data, you'll need to write something because WP doesn't normally track anything that you mentioned.
    • [ 1 ] Thanks
  • Thank you for that information. It narrows it down now.

    Would you know off hand if there's a piece of software
    or script that would piece this together without having to
    personally code or program this?
    I'm more of a site designer and not a programmer. I could
    have it outsourced, but if there's a solution through a
    script program, that would help me to customize it if the
    client wants to have it customized her way.

    Thanks
    • [1] reply
    • I really wouldn't imagine so (that there's a program out there that does this). At the end of the day it's just data in databases; a general program would have to be very poweful to tie them altogether magically.

      In short, it sounds like you would need custom programming.
  • You're in custom programming territory.
  • Considering the limitations of Wordpress, no. There are currently no plugins which does this. The closest would be WPMU which allows multiple sites in one but it is pointless for the amount of customizations necessary for your stuffs to work.

    Perhaps switch to a different framework? Joomla would be better for content management.
    • [1] reply
    • Hi,

      I agree with the database answer above, but for medical sites the regulations around the patient data can be formidable from both a security and regulation standpoint (e.g. HIPAA, Gramm–Leach–Bliley Act, etc.).

      Even if the WP sites are stand alone, combining data from several databases can be done outside of WP. There is nothing to say that WP cannot access several databases for specialized reasons, but performance issues may arise if you lean on WP too much for additional processing. I'd try to avoid cross platform issues by staying in the same DB as WP.

      Consider a stand alone "database roll-up" program that shares the combined/cleaned/massages result as a report. I'd bet that there is a plugin that can display MySql data in table. In more mainstream databases, there is normally a "business logic" middle-ware layer that would handle the arrangements in conjunction with the database.

      Hope that helps,

      Brett

      BSIT .Net 2010
      Linux on the 'Net before 1994
      Recovering HMO client-server programmer
  • I could do this for you. What you are asking for would take a good deal of time and be quite expensive. Depends on what kind of budget your client has. I could see this costing between 10 and 20K
Join the discussion

Next Topics on Trending Feed