Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Netsuite database connection

tramettaMay 26 2021

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

Post Details

Added on May 26 2021
8 comments
1,265 views