How to connect to NetSuit database from Azure synapse spark notebook using pyspark ?

heta desai 252 Reputation points
2022-05-02T11:45:25.413+00:00

I want to connect to the NetSuit database from Azure synapse spark notebook using pyspark. While using the below command it throws an error.

jdbcDF = spark.read.format("cdata.jdbc.netsuite.NetSuiteDriver") \
    .option("url", url) \
    .option("user", user) \
    .option("password", password) \
    .option("query",query) \
    .load()

Error: Py4JJavaError: An error occurred while calling o649.load.
: java.lang.ClassNotFoundException: Failed to find data source: cdata.jdbc.netsuite.NetSuiteDriver. Please find packages at http://spark.apache.org/third-party-projects.html

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,036 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.