Case Study: Ad Astra achieves faster client delivery, cutting time from months to weeks with IBM StreamSets

Reducing Time to Deliver Client Results from Months to Weeks Ad Astra John Masterson Testimonial Ad Astra Logo

Ad Astra, a higher-education solutions partner serving 500+ colleges, needed a reliable way to ingest large volumes of data from disparate student information systems to avoid months‑long SLAs and downstream scheduling issues that affected students. After building an in‑house ingestion agent that couldn’t cover all clients, Ad Astra adopted IBM StreamSets’ StreamSets Data Collector to handle its data integration needs.

IBM StreamSets implemented standardized pipelines to move data from Oracle, SQL Server and other sources into Amazon S3 and Snowflake (and to write back when required), using runtime parameters and a common schema to simplify development. The outcome: maintenance of dozens of XML files was reduced to four pipelines running hundreds of jobs; new client implementation time fell from months to days; and time to deliver analysis and recommendations dropped from nearly a year to a few weeks—enabling Ad Astra to be more agile and better support student success.

Ad Astra

John Masterson

Senior Data Engineer