azyure synapse Integration using mule4
Hi Community,
I am trying to ingest the metadata from azure synapse to DGC due to some customization I may have to develop a custom template using mulesoft 4.4
I am approaching it as below :
Setting by a generic Database connector with the below URL :
jdbc:sqlserver://${mssql.server}:${mssql.port};databaseName=${mssql.database};user=${mssql.user};password=${mssql.password} .
com.microsoft.sqlserver.jdbc.SQLServerDriver
Does any one have tried it before does it works and allows us to fetch the metadata from azure synapse.
Any lead will be much appreciated ?
Regards,
RC
integrationdev_rohit
Posted 4 years ago · Edited 2 years ago·Last reply 3 years ago
5 comments
integrationdev_rohit
OP3 years ago · EditedHi Islam,
Could you share the connection string you are using for the authentication in Purview.
Did you tried getting it authenticated through tools like POSTMAN ?
Warm Regards,
Rohit Chandra
islamwael
·3 years ago · Edited@rohit.chandra.1 Can you please mention the steps on how you logged in to Synapse SQL pools? I keep getting an error when I use the marketplace connectors whether for synapse or SQL server jdbc drivers.
Much appreciated,
Thanks
ahmadalqinneh
·4 years ago · EditedHello @rohit.chandra.1 - What error are you seeing? As per Microsoft’s documentation it looks like you have at least one incorrect parameter in your connection string (database). You can certainly connect to Synapse via JDBC on whatever platform and Mule is no exception. Hope this helps
Microsoft Docs:
integrationdev_rohit
OP4 years ago · EditedHi @ahmad.alqinneh.collibra.com ,
I was able to connect to synapse using JDBC connection but we are not proceeding with this approach. I am working on the Azure purview spring boot integration but getting error in that .
Have you used the marketplace azure purview spring boot integration ?
Can you help here ?
https://datacitizens.collibra.com/forum/t/azure-purview-to-collibra-spring-boot-integration-build-error/1884
Warm Regards,
Rohit Chandra
Alexandra Jorgenson
Admin4 years ago · Edited@rohit.chandra.1 I spoke with your CAD @ashok.balusu.collibra.comwho mentioned that you are using a template on our Marketplace built by one of our Partners. Ashok tells me that we have asked that Partner for help and as soon as we get you that solution, we’ll be sure to document it here.