Skip to main content
Nintex Community Menu Bar

SQL Service Instance connection to Azure Data Factory Sql Server

  • April 27, 2022
  • 1 reply
  • 75 views
  • Translate

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!

Did this topic help you find an answer to your question?

1 reply

  • 0 replies
  • April 28, 2022

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?

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings