FundSvcs Community

Expand all | Collapse all

Linking Institution Databases

  • 1.  Linking Institution Databases

    Posted 27 days ago



    We are in the beginning stages of looking at integrating all our databases. Currently, we have separate divisions that maintain their own database of volunteers, scholars, donors, store customers...etc. Our goal is to link all these to one institution database that can coordinate all the touch points of each relationship.


    Our first reach out was to Blackbaud who immediately recommended Blackbaud CRM. However talking through our goals they realized BB CRM is much more than we would need. They recommended we use an outside database warehouse such as Microsoft or Salesforce.


    Are there any out there that are currently supporting a central database through a database warehouse? Do you have any resources that helped you with the initial integration? What staffing do you have to support this? Would love to talk to any and gather any advice you are willing to part with.


    Thank you.


    Peter Johnston

    Advancement Services Director

    The Huntington Library, Art Museum and Botanical Gardens

    1151 Oxford Road, San Marino, CA 91108


  • 2.  RE: Linking Institution Databases

    Posted 27 days ago
    Hi Peter,

    I'm not certain based on what you wrote whether you're looking for a data warehouse to centralize and sync data from several other systems, or whether you're looking for a single integrated system that can provide necessary functionality to your various divisions. The former is a more complex and powerful approach that requires a lot more ongoing maintenance and data governance work. The latter is typically easier to set up and maintain, but can be limiting in terms of functionality and process flexibility. Happy to discuss further, I'll ping you offline.

    Thank you,
    Isaac Shalev
    CRM Expert
    Sage70, Inc.
    (917) 859-0151

    Schedule a 30-minute consultation now:

  • 3.  RE: Linking Institution Databases

    Posted 27 days ago
    I agree with Issac.  I'd steer clear of building a data warehouse to connect all of your disparate systems.  It's an extremely expensive proposition - which you have to repeat every time one of those divisions changes systems.

    I'd spend my time evaluating a system that everyone can use or building interfaces to obtain needed data from other platforms to pull into your database.


    John H. Taylor
    John H. Taylor Consulting, LLC
    2604 Sevier St.
    Durham, NC   27705
    919.816.5903 (cell/text)

    Serving the Advancement Community Since 1987

  • 4.  RE: Linking Institution Databases

    Posted 23 days ago
    While a data warehouse is a great solution for something like this, as others have said it's a pretty "heavy" and expensive thing to put in and get going.  There are a number of alternative  "light footprint" front ends that are much more efficient at accessing, blending, and integrating data from multiple sources than a data warehouse.  These tend to be applications that support reporting, dashboards, and data discovery tools.  This is what our business is all about and we'd love to discuss how something like this would work and what it would take to get up and running, and then support.  Let me now if you'd like to talk.

    Doug Cogswell,
    EVP Pursuant || Founder Advizor

    Doug Cogswell
    Pursuant, Advizor Solutions