Receiving the above error. We have confirmed the Netsuite connection string is correct and that the .jar file is in the userlib/database folder in the atom dir.
Hi Adam - thanks for the response. We could out that the user did not have permission to the SuiteAnalytics. Once this was granted we were able to connect successfully.
An update to this - we resolved this issue - we needed to update the NetSuite URL. We are now seeing the error:
"Error retrieving db [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine] You do not have permission to use SuiteAnalytics: Connect Service"
We verified that the user does have permission to this.
I've not run into that error before. To help troubleshoot do you have the ability to try connecting from another JDBC client outside of Boomi to confirm the permissions are configured correctly for comparison?
Retrieving data ...