8 {{ upvoteCount | shortNum }}
8 {{ upvoteCount | shortNum }}

Program To Centralize Databases?

by JKinakin
7 replies
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
#centralize #databases #program
  • Profile picture of the author KirkMcD
    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.
    {{ DiscussionBoard.errors[4789728].message }}
  • Profile picture of the author JKinakin
    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
    {{ DiscussionBoard.errors[4790837].message }}
    • Profile picture of the author Content Publisher
      Originally Posted by JKinakin View Post

      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
      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.
      Signature
      Follow me as I build my content publishing business from $0 to a full time income.

      "The harder the conflict, the more glorious the triumph. What we obtain too cheaply, we esteem too lightly; it is dearness only that gives everything its value." - Thomas Paine
      {{ DiscussionBoard.errors[4795302].message }}
  • Profile picture of the author SteveJohnson
    You're in custom programming territory.
    Signature

    The 2nd Amendment, 1789 - The Original Homeland Security.

    Gun control means never having to say, "I missed you."

    {{ DiscussionBoard.errors[4795247].message }}
  • Profile picture of the author lovenot
    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.
    Signature
    Want to improve your website traffic? Interested in backlinks creation, article writing/submission, autoblogging and more? Check out Licorne Solutions Ultimate SEO and Internet Marketing Software Solutions now!
    {{ DiscussionBoard.errors[4795340].message }}
    • Profile picture of the author telewarrior
      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
      {{ DiscussionBoard.errors[4880933].message }}
  • Profile picture of the author Mark Marzinzik
    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
    {{ DiscussionBoard.errors[5086547].message }}

Trending Topics