300 databases. Tens of millions of records. Elections can be won or lost through the power of data. Canada’s New Democratic Party (NDP) now campaigns smarter, using CloverDX to extract maximum value from their data.
The party’s data challenges came mainly from trying to integrate many different data sources into one common database. They were working with more than 300 databases, 13 provincial membership lists and tens of millions of records of generic population data.
These data sources needed to be matched and merged, but NDP didn’t have enough manpower to do the work, and getting value from the large quantities of data was cost-prohibitive.
Matching, merging and deduplicating
NDP came to CloverDX to build a solution that would remove some of the manual effort needed to cleanse the data and then build the new centralized database in a clean, streamlined and reliable way. CloverDX can automatically handle matching, merging and deduplication of data from a huge range of sources, making the migration to the new database far easier.
More time for the 'nice to haves'
This automation has enabled NDP to focus their resources on using their data rather than spending time processing it. With CloverDX taking care of the ‘must haves’, NDP staff are able to spend time on the ‘nice to haves’, tailoring and targeting their campaigns in ways they weren't able to previously.
"It allows us to work on the nice-to-haves, while Clover does the need-to-haves.”
James Williamson, IT Coordinator, New Democratic Party of Canada
Data integration software and ETL tools provided by the CloverDX platform (formerly known as CloverETL) offer solutions for data management tasks such as data integration, data migration, or data quality. CloverDX is a vital part of enterprise solutions such as data warehousing, business intelligence (BI) or master data management (MDM). CloverDX Designer (formerly known as CloverETL Designer) is a visual data transformation designer that helps define data flows and transformations in a quick, visual, and intuitive way. CloverDX Server formerly known as CloverETL Server) is an enterprise ETL and data integration runtime environment. It offers a set of enterprise features such as automation, monitoring, user management, real-time ETL, data API services, clustering, or cloud data integration.