NetSuite Data Pipeline: Surprising API Challenges & ODBC Solution

The Dashboard Effect

内容由Brick Thompson, Jon Thompson, Caleb Ochs, Landon Ochs, Brick Thompson, Jon Thompson, Caleb Ochs, and Landon Ochs提供。所有播客内容（包括剧集、图形和播客描述）均由 Brick Thompson, Jon Thompson, Caleb Ochs, Landon Ochs, Brick Thompson, Jon Thompson, Caleb Ochs, and Landon Ochs 或其播客平台合作伙伴直接上传和提供。如果您认为有人在未经您许可的情况下使用您的受版权保护的作品，您可以按照此处概述的流程进行操作https://zh.player.fm/legal。

5M ago 7:22

MP3•单集首页

In this episode of The Dashboard Effect, Brick chats with Landon, Director of Solutions at Blue Margin, about a surprising challenge faced while extracting data from NetSuite. Despite NetSuite’s well-developed API, handling massive datasets proved problematic. Landon shares how they solved the issue using an unexpected solution—the ODBC connector.

They discuss the limitations of the API, how ODBC outperformed it for large data sets, and the unconventional yet effective workaround using a virtual machine. If you’re working with NetSuite or other cloud-based systems and experiencing similar challenges, you’ll want to hear this episode.

Key Takeaways:

Why NetSuite’s API struggled with millions of records
How ODBC became the unexpected hero for pulling large data sets
The importance of getting creative with data extraction

Listen in for tips and insights that can help with your own data pipeline challenges!

150集单集