I am unable to connect to SuiteAnalytics Connect both via ODBC and JDBC connections. Has this happened to anyone else?
I'm stuck in NetSuite Support hell with a case that's not moving forward and its a significant impact to our business.
The last successful use of SuiteAnalytics Connect was Saturday, May 7th. Since Monday, May 9th, all of our data refresh processes, both automated and manual, have failed to connect to NetSuite. I traced it back to the ODBC and JDBC driver connections, which both return "TCP/IP error, connection timed out" errors.
I assume it is related to the "Required Update of SuiteAnalytics Connect Drivers" update (linked below), but I have updated all attributes and drivers according to the documentation. I've tested it on the work network and also my home network and receive the same error, reducing the likelihood of firewall interference.
https://community.oracle.com/netsuite/discussion/4475487/final-reminder-verify-your-suiteanalytics-connect-drivers-and-attributes
I updated the ODBC driver to version 8.10.143.0 (following the recommended instructions), verified the ODBC configuration, but all attempts to test the connection fail with a "TCP/IP error, connection timed out".
I tested the JDBC connection (I added the "NegotiateSSLClose=false" parameter, and it failed with the error message "[2022-05-16 13:59:47] com.netsuite.openaccess.net.oar: Error establishing socket to host and port: 5239644.connect.api.netsuite.com:1708. Reason: Connection timed out: connect"
I verified with our IT team, and they made no IT changes to the network firewall during this time. We checked the firewall and it did not block any connections to NetSuite or port 1708. The service host and port did not change - so why would connection attempts all of a sudden fail when they've always been previously successful?
I'm totally lost because it seems like I've done everything right according to the documentation, but SuiteAnalytics Connect isn't achieving a connection on the NetSuite end. Has anything like this happened to anyone else?
Specific places where the connection was tested and failed (using Windows 10):
- ODBC Data Source Administrator (64-bit)
- PyCharm IDE (uses the JDBC connection)
- Matillion (AWS ETL tool uses the JDBC connection)
- Microsoft Excel (uses the ODBC connection)