Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Netsuite database connection
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
-
we don't support netsuite's jdbc driver...
-
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.
-
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.
-
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.
-
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.
