Connecting Synapse to Experian
So I am trying to connect Experian to Azure Synapse to get DQ result. So I have tried using the JDBC SQL Server Driver (SQL Server 6.0) and in addition to this changing the customer connection string to change the Select Method from cursor to direct. However when I test connection all I get as a debug on the UI is "Failure"
Any ideas on how best to connect to synapse?
Would be much Appreciated!