NGP VAN is the leading technology provider to progressive political campaigns and non-profit organizations, offering clients an integrated platform of the best fundraising, compliance, field, organizing, digital, and social networking products. Nearly every major Democratic campaign in America is powered by NGP VAN, including the Obama campaign’s voter contact, volunteer, fundraising and compliance operations in all 50 states. The organizers, fundraisers, and strategists that use NGP VAN tools to advance important causes and elect inspiring leaders, like President Barack Obama and Senator Elizabeth Warren. From equality + reproductive rights to education + climate change, the passions of these leaders and organizations are shaping a brighter future - and we’re passionate about offering them the technology they need to bring their goals to life.
As Chief Database Architect at NGP VAN, Christopher Porter needs to deliver data in multiple formats and into various platforms to his client base, while being adaptable to their specific service-level agreements (SLAs). The on-premises data resides in an SQL Server database and in the cloud, different client data sets are delivered to both the Amazon Web Services and Microsoft Azure public cloud platforms. The data delivery use cases include “lift and shift” migrations and near real-time data replication, with some clients preferring complete datasets or data filtered for their specific needs.
The team at NGP VAN started looking at Amazon Redshift, a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze all your data using your existing business intelligence tools. Once they decided on Amazon Redshift, they needed a way to migrate their data from SQL Server to Amazon Redshift and they began looking at Attunity Replicate, a software solution with an intuitive user interface, change data capture (CDC) technology and in-memory transaction streaming for real-time data warehousing accelerate your enterprise journey to real-time analytical insights.
Because some clients preferred to work with Microsoft Azure, NGP VAN uses Attunity Replicate to move data to Azure as well. Azure is a growing collection of integrated cloud services—analytics, computing, database, mobile, networking, storage, and web. NGP VAN customers are using Attunity Replicate to migrate data from SQL Server to the Azure SQL Data Warehouse quickly easily and affordably.