NetSuite Data Pipeline: Surprising API Challenges & ODBC Solution

The Dashboard Effect

Contenuto fornito da Brick Thompson, Jon Thompson, Caleb Ochs, Landon Ochs, Brick Thompson, Jon Thompson, Caleb Ochs, and Landon Ochs. Tutti i contenuti dei podcast, inclusi episodi, grafica e descrizioni dei podcast, vengono caricati e forniti direttamente da Brick Thompson, Jon Thompson, Caleb Ochs, Landon Ochs, Brick Thompson, Jon Thompson, Caleb Ochs, and Landon Ochs o dal partner della piattaforma podcast. Se ritieni che qualcuno stia utilizzando la tua opera protetta da copyright senza la tua autorizzazione, puoi seguire la procedura descritta qui https://it.player.fm/legal.

5M ago 7:22

MP3•Pagina principale dell'episodio

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 episodi

#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