Netsuite database connection

trametta

I am having issues connecting to our Netsuite cloud database with SQL Developer. Has anyone had success with this? I have installed other 3rd party JDBC drivers and they all work fine in SQL Developer. For the Netsuite JDBC driver that I downloaded from Netsuite, it does not show Netsuite in the dropdown list of database types when creating the new connection in SQL Developer. I have run the sample code that is included in their JDBC driver and it works fine so I know the issue is not related to my access, permissions, or password.

Netsuite requires a custom JDBC connection string in the format below and this does not work either. I get the error "invalid connection information specified. Verify the URL format for the specified driver".

jdbc:ns://<accountID>.connect.api.netsuite.com:<port>;ServerDataSource=NetSuite.com;encrypted=1;CustomProperties=(AccountID=<accountID>;RoleID=<roleID>);NegotiateSSLClose=false

thatJeffSmith-Oracle

we don't support netsuite's jdbc driver...

trametta

Well that is indeed unfortunate since Oracle owns Netsuite so it's an incompatibility with your own product. Can anyone recommend an IDE that can interact with Netsuite or a way to query the database ad-hoc without having to code it all in Java? Thanks.

vlastimil.martinek-Oracle

afaik NS JDBC/ODBC driver is a read-only paid API. I can't recommend IDE for your queries but besides the said driver you may read NetSuite data with composing a SuiteQL query thru REST or server-side SuiteScript requests. The other options are searches thru SOAP/REST/SS but this involves a bit more coding.

User_F9WEW

I was able to get this working by purchasing a license for and installing JetBrains Datagrip. It is still a shame that this doesn't work in SQLDeveloper.

glindner

Oracle SQL Developer used to support NetSuite's ODBC, but not for many versions. I agree with trametta that it's ludicrous Oracle doesn't support one of it's own products. Sure, I can write SuiteQL, but I need to validate connections to NetSuite for clients using SuiteAnalytics Connect from other applications using either ODBC or JDBC. So, I guess it's back to Squirrel SQL...annoying--especially after spending hours trying to get a connection to work.

User_76IFG

https://community.oracle.com/tech/developers/discussion/comment/16811678#Comment_16811678

Hello there, I'm trying to set this up now. In DataGrip, did you use User & Password for Authentication or No auth?

User_F9WEW

Yes, use "User and Password" auth. You also have to assign certain roles to the NS user that you are logging in as. I think your user requires the SuiteAnalyticsConnect role.

Here is a link to setup the connection properties.

https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4425615742.html

User_76IFG

https://community.oracle.com/tech/developers/discussion/comment/16853559#Comment_16853559

Thanks for the quick reply, it is very much appreciated. I wasn't sure if NS was expecting the User and Password in the URL.

For the benefit of anyone else who ends up reading this, I was able to get this working by:

1. Following the instructions here: https://datatek.io/2018/05/07/using-datagrip-with-netsuite/
2. Replacing NetSuite.com with NetSuite2.com in the URL because our account is too new to use the NetSuite.com data source
3. Adding appropriate permissions to the role (the NetSuite2.com source does not respect the SuiteAnalytics Connect - Read All permission, so you need to grant View permission for each type of data that you want to access via SuiteAnalytics Connect)