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!
ODBC Netsuite2.com access to all transactions
I've created a role with these permissions (in the Setup" subtab):
"SuisteAnalytics Connect"
"SuiteAnalytics Connect - Read All"
"Analytics Administrator"
I am able to connect and run SQL queries via analytics data source Netsuite2.com, but I don't see all the tables.
For example, select * from OA_TABLES doesn't show me the "transaction" table but does show "Account" table.
I tried to find some permissions under "transactions" and "Lists" Subtabs in "Permissions" section of the Role. I've added some permissions (Sales Orders, Invoices, etc...) , but it still doesn't allow me to select from the transaction table.
I get an error: Base table:transaction not found