Forum Discussion
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 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.
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.
3 Replies
I'm trying this JDBC approach; getting this error:
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.
