I have given the following permissions in a role , assigned that rorle to an employee. And trying to query using jdbc/odbc connection. While doing the queries it says record not found error. If i add Custom Record Entries permission, I am able to fetch custom record data. But still unable to fetch data for tables like transaction, employee, customer, etc.

This is apparently doesn't work on the Netsuite2.com datasource? Which seems fun since the netsuite.com datasource is depricated

I was told once by NS Support that the native Data Warehouse Integrator role gives basically Read-Only All access. Even though if you look at the role, it looks like it has access to basically nothing. I never actually tried it because I didn't want/need our integration to have access to everything. Also fun fact about NS2.com versus NS1.com, I didn't realize that NS1 really wasn't respecting field-specific security. NS2 very much does and so I had to go update a couple dozen fields to be visible to the role I was using for NS2.

NetSuite2.com data source requires role access permissions. User can only query records that can be accessed trough UI with that specific role. If you need to bypass this, you require to have the Data warehouse Integrator role but this role requires you to connect using TBA.

@Alejandro Camacho will i need to customize that role and add in all the transaction and entity record access to it. Since I don't see it there.

If you use Data Warehouse integrator no need. If you use a custom role you can need to add the transactions and entities permissions to the role.

I will check that out then, Thanks

I don't, sorry