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 …
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.