How to connect on-prime database using link service in spark

Suresh12 26 Reputation points

I am following the steps from this guide to connect to the on-prime database using spark.

I am following the steps from this guide to connect to the on-prime database using spark.

I am trying this connection test for two days. please anyone help me? Here are my screenshots of the linked service. I need to connect the source inside the retail database. I need to connect the retail database using link service in spark.

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.
3,570 questions
0 comments No comments
{count} vote

Accepted answer
  1. KranthiPakala-MSFT 43,602 Reputation points Microsoft Employee

    Hello @Suresh12 ,

    Thanks for the question and using MS Q&A platform.

    As per my understanding you would like to connect to On premise SQL database using Apache Spark SQL connector (SQL & Azure SQL) using linked service. Please correct me if I'm not accurate.

    If my understanding is correct:

    As per the note from the official documentation, currently, there is no linked service or AAD pass-through support with the Apache Spark SQL connector.

    Ref doc: Azure SQL Database and SQL Server connector for Apache Spark

    You may have to follow the exact connection details provided in the documentation (see image above).

    Here is existing feature request feedback logged by a user in IDEAS forum: Support on-Prem SQL connection via Azure Synapse Notebook , via linked service (created using Self Hosted IR)
    Feel free to upvote and comment on it to help increase the priority of the feature request.

    Hope this info helps


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful