NetSuite Data Pipeline: Surprising API Challenges & ODBC Solution

The Dashboard Effect

Innhold levert av Brick Thompson, Jon Thompson, Caleb Ochs, Landon Ochs, Brick Thompson, Jon Thompson, Caleb Ochs, and Landon Ochs. Alt podcastinnhold, inkludert episoder, grafikk og podcastbeskrivelser, lastes opp og leveres direkte av Brick Thompson, Jon Thompson, Caleb Ochs, Landon Ochs, Brick Thompson, Jon Thompson, Caleb Ochs, and Landon Ochs eller deres podcastplattformpartner. Hvis du tror at noen bruker det opphavsrettsbeskyttede verket ditt uten din tillatelse, kan du følge prosessen skissert her https://no.player.fm/legal.

1M ago 7:22

MP3•Episoder hjem

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!

142 episoder

#Business #Brick Thompson Jon Thompson And Caleb Ochs #Brick Thompson #Caleb Ochs #Jon Thompson #Data #Analytics #Private Equity #Business Intelligence #Data Analytics #Dashboard #Blue Margin