SQL Service Instance connection to Azure Data Factory Sql Server

  • 27 April 2022
  • 1 reply
  • 60 views

  • Anonymous
  • 0 replies

Hello all, I'm attempting to make a connection from the K2 management to azure data factory sql database. The database is a synapse sql in data factory and i'm getting an error when attempting to make the service instance:

Validation 'OBJECT_DEFINITION' is not a recognized built-in function name

 

I have a firewall in place on the factory and used the lookup feature in the servers section of the management area to get the IP address

22807iB35C625EA3478DEE.png

I'm sure the IP is not static so not sure if there is a way to manage that or not. Any help on understanding how this configuration is supposed to be done would be extremely helpful. 

 

Thank you!


1 reply

An update to this question. I was able to successfully connect to a basic SQL DB on the Azure SQL Server in the cloud. The issues seems to be related to accessing a dedicated SQL Pool Database. Any thoughts about how I might get this connected?

Reply