This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Has anyone extracted netsuite to a data warehouse? Running into pretty major roadblocks where revenueplan, revenuearrangement, and revenueelement can't accessible via n/query or through suitetalk.

<@U01CHP8AH7S> I'm able to get data via these queries:
```SELECT * FROM RevenuePlan WHERE ROWNUM = 1
SELECT * FROM RevenueElement WHERE ROWNUM = 1
SELECT * FROM Transaction WHERE Type = 'RevArrng' AND ROWNUM = 1```
Could it be a permissions issue?

Have you looked at the ODBC driver?  You can query the NetSuite database over ODBC.

From the the Helpcenter: /app/help/helpcenter.nl?fid=section_3990584734.html

I've seen it used where a datawarehouse was synced with NetSuite every night using ODBC.

<@U01CHP8AH7S>, touch base with <@UUJSAJX16>.... He'll help you out

<@U01CHP8AH7S> i'll direct message you - we have a pre-built netsuite data warehouse solution that implements in less than 2 weeks.