Extract Information to DataWareHouse and DataLake

As you know, NetSuite has diferents way to get information, I mean directly database(ODBC), and API (using workbook)

1.- What could the better way to get information, Database or API(across workbook)?,

2.- Database ODBC, has all tables to build a report as Estado de Resultados?,

I’ll appreciate a lot your guide …

Rookie Asked on February 22, 2022 in SuiteAnalytics.
Add Comment
1 Answer(s)


There is probably not much difference but some of the latest changes to ODBC have made it a little more difficult as you now need to generate a token to use NetSuite2.com alongside the built-in Data Warehouse role.

I’ve not seen anyone do it via API. I assume you would want to use SuiteQL via REST Web Services? If so, I’d watch our for any limits on returned records and how difficult it may be to set up an appropriate role.



Advanced Answered on February 25, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor