Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Netsuite Entity-Relationship Diagram
We just purchased the license for SuiteAnalytics Connect (ODBC connector), and would like to build a BI dashboard for our Netsuite reporting. Have also established the ODBC connection to Netsuite tables. However, none of our team is familiar with the DB level schema / table structure of Netsuite. Not sure how to locate & query the data we need Eg. Accounts Receivables Aging by Customer...this is the first report I need to produce in the BI system. Could I get pointers to these questions -
- Is there an Entity Relationship Diagram that is available for Netsuite?
- Is it possible to view the SQL that is generated for Searches and Reports in Netsuite?