Forum Discussion

gibbyj's avatar
gibbyj
Regular Visitor
1 year ago
Solved

accessing NetSuite using Suite Analytics Connect JDBC driver

We're using Suite Analytics Connect successfully - mostly with ODBC DSN installed on Gateway server.  But I'm now trying to access NetSuite tables using pyspark in a Notebook.  I learned from ChatGPT...
  • gibbyj's avatar
    gibbyj
    1 year ago

    We submitted a ticket to Microsoft and this issue is solved. The learning that I got from ChatGPT was ultimately correct. However, my Notebook still didn't work due to a known issue with the spark session create method. The jar file for the JDBC driver just wasn't accessible by the notebook. The solution was to use %%configure, a Magic configuration feature, to add the driver jar file into the configuration/path.