Data Warehousing

Your organization’s donor data lives in a lot of places. It’s smart to use the best fundraising tools for the job, but you need to be able to analyze and query your data across tools and platforms. Our integration technology constantly monitors your data sources for new and modified data and then replicates that data to a secure data warehouse tailored to your organization's unique needs.

How It Works

We perform an audit of your fundraising operations to better understand the tools and systems in which your donor data lives. We'll be looking at:

  • Your CRM platform and any add-ons or third-party apps you've installed with it
  • Digital marketing tools used to send emails, text messages or online advertisements to your donors and prospects
  • Credit card processing providers
  • Systems used by third-party service providers (call centers, cagers, creative agencies, etc.)

We design the schema for your organization's raw donor data and build your DMI Data Warehouse on a high-resource PostgreSQL server in our private datacenter.

We have built cutting-edge data infrastructure that provides low-latency pipelines between all of your organization's data sources (from step one) and the DMI Data Warehouse. These pipelines acquire data using any of the following processes:

  • Read-only Direct database access using SQL
  • Read-only REST or SOAP API interaction
  • Bulk export API interaction
  • Perpetually-monitored FTP-prompted ingestion

Access to your organization's DMI Data Warehouse is IP-limited and requires dual-factor authentication. Administrators at your organization will be able to:

  • Provide read-only, direct SQL access to new users
  • Revoke access for existing users
  • Limit the data sources that individual users can access
  • Export data

In addition to granting the access above, DMI can assist with connecting any business intelligence and query tools to the data warehouse.

All DMI Data Warehouses are continuously monitored for availability, resource capacity, and DDoS attacks. Additionally, phone and email support are provided during regular business hours.

Learn how DMI takes data warehousing a step further with managed databases.

Get a Free Consultation
WHAT YOU CAN EXPECT
RELIABLE SYNCHRONIZATION
LOW-LATENCY
ACTIVE MONITORING & SUPPORT

Integrations Catalog

We've integrated our data warehousing platform with dozens of popular marketing tools, CRMs, and fundraising platforms. We're adding new integrations every month, too.

Salesforce
bbCRM
Mailchimp
MobileCause
Frontstream
Stripe
PayPal
Authorize.net
CharityEngine
Redshift
MySQL
PostgreSQL
DonorDrive
WealthEngine
DonorSearch
Foundation Center
Delivra
Paya
WooCommerce
Zapier