Authentication type missing from linked service in Azure Data Factory when

Ashish Ruparel 0

Hi,

MS released a new connector for PostgresSQL in Linked Services of Azure Data Factory v2. We could create a new linked service in the development branch that worked ok. But when we deploy the linked service to the ADF (connected to Git), the "authenticationtype" property does not get created and the pipelines fail to authenticate against the data source and it fails. The pipelines work good in the debug mode, from the dev branch.

I have included 2 images, one that has the property in the dev branch and the other without the property from the ADF live mode.
User's image

User's image

The property is skipped by the powershell command, Set-AzDataFactoryV2LinkedService, when it tries to deploy the LS. How do we resolve this issue ?

Kind Regards,

Ashish

ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2024-04-16T16:45:07.7266667+00:00

Hi Ashish Ruparel,

Thank you for posting query in Microsoft Q&A Platform.

Little confused here. You published the linked service, which you created in Dev branch right? Where PowerShell is coming into scenario here? Could you please elaborate more on this?

I tried my end its working fine actually. Thank you.
Ashish Ruparel 0 Reputation points

2024-04-17T11:07:25.2233333+00:00

Hi,

The data factory is configured to use Git repository. So, the linked service is deployed to Azure Data Factory Live mode using the CI/CD pipeline, which uses Powershell commands.

Kind Regards,

Ashish
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2024-04-30T17:06:10.48+00:00

Hi Ashish Ruparel, Just checking if below answer helps. If yes, please consider hitting Accept Answer button. Accepted answers help community as well. Please let me know if any further queries. Thank you.

3 answers

ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2024-04-18T05:20:09.9666667+00:00

Hi Ashish Ruparel,
Than you for sharing details, Why we are using powershell here to create linked serive? CI/CD ideally should take linked service details from one environment to other environment automatically from ARM templates.

Could you please elaborate, why its not the case?

Please check below video of CI/CD, there i am moving linked services directly using ARM templates. Ideally it should be same. Kindly fellow the same.

CI/CD in Azure data factory

Hope this helps. Please let me know how it goes.
Please sign in to rate this answer.
Ashish Ruparel 0 Reputation points

2024-04-18T09:28:09.2966667+00:00

Hi,

Thanks for the link. My environment is an old school one and the CI/CD does use the powershell and currently I am not in a position to change it.

The deployment was working good, till I planned to upgrade the LS and it works fine after I reverted my changes. So it does look like the powershell commands are not updated to handle the new Linkedservice and it's properties properly.

Kind Regards,

Ashish

Ashish Ruparel 0 Reputation points

2024-04-18T09:30:09.8433333+00:00

ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2024-04-24T13:44:16.4666667+00:00

Hi Ashish Ruparel, I would suggest to avoid using PowerShell for LS creation. Also, consider using fresh CI/CD process may be. That helps to easy maintenance.

Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.
Sign in to comment
Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more
Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more