Does anyone know what permissions (or lack of permission) would allow a role to connect to the NetSuite.com schema only, but not to the NetSuite2.com schema? I have one role that is able to connect to the older data source, but with the new one gets the error:

You do not have permission to use SuiteAnalytics: Connect service.  Please contact your administrator for assistance.

For Netsuite2 you either need to give a role permission to each record type that it needs access to OR you can give it a dataware house role but that requires a different type of authorization in JDBC/ODBC with tokens. https://system.netsuite.com/app/help/helpcenter.nl?fid=section_3998867068.html#subsect_162885566786

Permissions > Setup (on the role record) make sure you have these: • SuiteAnalytics Connect • SuiteAnalytics Connect - Read ALL

@eminero Those don't apply to Netsuite2.com schema (or at least the Read All)

Ha! I'm not an expert but the other day I was able to read data using the Microsoft Developer tool setting ODBC using a role with those permissions and I setup Netsuite2.com as a data source. I might be wrong but it worked to me.

"It is not applicable to the analytics data source, also known as NetSuite2.com. The analytics data source applies role-based access restrictions. Users can query only data that they can access in the NetSuite user interface." - from the page that I linked.

I see. Well I might need to test it again without those permissions.

In the end, I took a different working role and modified a copy of it, and it works. So, I guess that solves my problem for now, at least.