Read/Write Data to/from Azure SQL database(s)

[spartan27244]

We have been in azure for quite some time and we have quite a number of Azure SQL databases. We are looking to start processing our incoming data in Fabric and have the results pushed to our SQL database(s). We also want to replace some of our long running stored procedures with PySpark processing which will require reading in data and posting the results back to the SQL databases. The thing I cannot figure out is how to connect to the database(s). I created a connection in the settings-> Connections and Gateways but apparently you can only use these in a pipeline. I have also tried a JDBC connection in PySpark, but cannot get that to work. So how do I get this to work?

[v-sathmakuri · Accepted solution]

Hi @spartan27244 ,

Thank you for reaching out to Microsoft Fabric Community.

A similar issue has already been discussed in the Fabric Community Forum. Please try the suggested solution in the following thread and let us know if it resolves your issue:

https://community.fabric.microsoft.com/t5/Data-Engineering/Error-connecting-to-SQL-Database-using-Fa... 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you!!