AWS Public Sector Blog

Ben Turnbull

Author: Ben Turnbull

Ben is a senior solutions architect at AWS based in Portsmouth, New Hampshire. He is energized by enabling nonprofit organizations to achieve their missions through cloud technology. His interests include data and analytics, generative AI, and Kentucky Wildcats basketball.

AWS branded background with text overlay that says "How to build API-driven data pipelines on AWS to unlock third-party data"

How to build API-driven data pipelines on AWS to unlock third-party data

The first blog post in this series outlined considerations for developing API pipelines on AWS to extract data from third-party SaaS tools. With consolidated data, public sector organizations can offer new experiences for donors and members, enrich research datasets, and improve operational efficiency for their staff. This follow-up blog post presents options for ingesting SaaS data with API requests from AWS services, methods for handling payload data from API calls, and guidance for orchestration and scaling an API data pipeline on AWS.

Unlock third-party data with API-driven data pipelines on AWS

Unlock third-party data with API-driven data pipelines on AWS

Public sector organizations often utilize third-party Software-as-a-Service (SaaS) to manage various business functions, such as marketing and communications, payment processing, workflow automation, donor management, and more. This common SaaS landscape can lead to data silos where data becomes isolated in disparate systems and difficult to centralize for business insights. If existing SaaS connectors are not available, public sector organizations can use AWS to build an API-driven data pipeline to consolidate data from SaaS platforms offering open APIs. In this post, learn how to build an API data pipeline on AWS.

Optimizing your nonprofit mission impact with AWS Glue and Amazon Redshift ML

Nonprofit organizations focus on a specific mission to impact their members, communities, and the world. In the nonprofit space, where resources are limited, it’s important to optimize the impact of your efforts. Learn how you can apply machine learning with Amazon Redshift ML on public datasets to support data-driven decisions optimizing your impact. This walkthrough focuses on the use case for how to use open data to support food security programming, but this solution can be applied to many other initiatives in the nonprofit space.