Connecting to an API With SSIS

Amanda Ward and Manoj Kommagiri discuss the integration of APIs with ETL processes at ODOT, emphasizing the importance of real-time data processing and the transition from traditional database connections to API-based systems. They highlight the benefits of using ETL for data quality and consistency, and the role of Python in handling API interactions and data transformations. The session also covers challenges such as API authentication, batching, and JSON schema validation, while introducing the concept of Model Context Protocol (MCP) servers for enhanced AI interactions. Generated by Enghouse AI.

Travis Knight

1/6/2026 5:52:58 PM