bhickok
Rookie

SQL Service Instance connection to Azure Data Factory Sql Server

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

bhickok_0-1651076746081.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!

Labels: (1)
0 Kudos
Reply
1 Reply
bhickok
Rookie

Re: SQL Service Instance connection to Azure Data Factory Sql Server

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?

0 Kudos
Reply