accessing NetSuite using Suite Analytics Connect JDBC driver

[gibbyj]

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 that I should probably use JDBC for this.  I do know how to install and use the Suite Analytics Connect JDBC driver, since I'm using it for DBeaver access to NetSuite database.  Am I on the right track, to follow directions (from ChatGPT) to use SuiteAnalytics Connect JDBC driver in my Fabric environment, so I can run queries against NetSuite tables from my Notebook?  This will involved putting the jar driver file in our Lakehouse and accessing it from there in the Notebook code.  Thanks.

[v-zhouwen-msft]

Hi gibbyj ,

No documentation was searched for the moment, and the authenticity of Chatgpt's answer should be considered.

Best Regards

[gibbyj · Accepted solution]

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.

[gibbyj]

I'm trying this JDBC approach; getting this error: