Forum Stats

  • 3,874,599 Users
  • 2,266,752 Discussions
  • 7,911,910 Comments

Discussions

Netsuite database connection

trametta
trametta Member Posts: 2 Green Ribbon

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

Comments