Parametrization for connection string is not working in linked service

Question

Hi there,

I have solution - data pipeline in Synapse taking data from mysql database. I need to parametrize it to be able run process across many environemnts (CI/CD). I set many linked services with code referencing on variable in yml file in style like this

"url": "#{SYNW.adlsaaa}#"

It was still working and after my CD run it promoted correct value from yml file to dev/test/stage branch withou any issues. When I try to do the same thing within linked service referencing to mysql - it will promote changes to dev/test/stage from my main branch - but it will break the main branch and getting errormessage:

"Could not load resource 'ls_mysql_empadm_aaa'. Please ensure no mistakes in the JSON and that referenced resources exist. Status: Connection String Syntax Error, Position: 23, Possible reason: Connection String Syntax Error, Position: 23"

This is my code

{

	"name": "ls_mysql_empadm_aaa",
	"type": "Microsoft.Synapse/workspaces/linkedservices",
	"properties": {
		"connectVia": {
			"referenceName": "AutoResolveIntegrationRuntime",
			"type": "IntegrationRuntimeReference"
		},
		"type": "AzureMySql",
		"typeProperties": {
			"connectionString": "#{SYNW.mysqlstringaaa}#",
			"password": {
				"secretName": "mysql-empadm",
				"store": {
					"referenceName": "ls_kv_master",
					"type": "LinkedServiceReference"
				},
				"type": "AzureKeyVaultSecret"
			}
		},
		"annotations": []
	}
}

Answer 1

Hello @Peter Michalik

It seems like there is a syntax error in the connection string of your linked service. The error message suggests that the error is at position 23. To parametrize the connection string in your linked service, you can use the following syntax:

{
"connectionString": { "value": "@{linkedService().connectionString}", 
"type": "Expression" 
}

Replace the connectionString property in your code with the above syntax and try again.

Make sure to replace the linkedService().connectionString with your own variable name. Also, make sure that the variable SYNW.mysqlstringaaa is defined and has a valid connection string value.

I hope this helps.

Answer 2

Hi @Pinaki Ghatak ,

thanks for your answer. The syntax you provided with me was working from the "syntax" perspective and also after running my CD pipeline I was able to see correct connection strings values per einvironemnt in my repos - dev string for dev environment, test for test env etc...The issue is within the synapse it did not fill that string to linked service setup -see picture.