Help using JDBC with Excel on Macintosh?

I have a client using Excel for the Macintosh, who wants to automate loading datasets directly from NetSuite. It appears that the only direct connection for the Mac is JDBC (no ODBC driver provided by NetSuite). We have two questions we need help with:

A. NetSuite provides a ZIP file with the JDBC driver for the Mac, but give essentially no information about how to install it on a Mac. Can anyone provide (or refer us to) a good description of how to install a driver on a Mac?

B. Once we do manage to get the JDBC driver installed, does anyone know for sure whether Excel for the Mac will be able to use it to auto-load datasets from NetSuite? It would be very valuable to know for whether whether or not it will be worth the effort to install the JDBC driver.

Any help/perspective will be greatly appreciated.

Rookie Asked on December 2, 2022 in SuiteAnalytics Connect.
Add Comment
1 Answer(s)

Hi,

I did once manage to get the driver installed and working via the command line but I never got it to work with Excel.

Have you followed all the instructions here?

https://suiteanswers.custhelp.com/app/answers/detail/a_id/38941

I think you may end up spending a lot of time here and never getting as far as it working in Excel.

Chris

 

Intermediate Answered on December 14, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor