Forum Discussion

msprog's avatar
msprog
Icon for Advocate III rankAdvocate III
1 year ago
Solved

Notebook connecting to SQL Server

HEy we have a onprem sql server. There is a gateway connection to the sql server.  Now i want to access this sql server via a pyspark notebook. How can i set up a connection to this please.    th...
notebook
  • msprog's avatar
    msprog
    1 year ago

    do you have a link to the announcement please?

apturlov's avatar
apturlov
Icon for Super User rankSuper User
10 months ago

msprog JibinSebastian You might be able to create a Mirrored SQL database from the on-premise SQL server using an OPDG (on-premise data gateway). It's realtively easy to try but when you are configuring the mirrored database you'd need to use a SQL server account with the admin permission so it can configure CDC. Once the mirroring is working you can create a shortcut to tables in a Lakehouse and now you have full access to the mirrored data from a Notebook.

JibinSebastian's avatar
JibinSebastian
Icon for Advocate II rankAdvocate II
10 months ago

Thank you apturlov for your response and efforts, I will  try connecting with  Mirrored SQL database into the fabric.