Authentication type missing from linked service in Azure Data Factory when

Ashish Ruparel 0 Reputation points
2024-04-15T12:18:05.4833333+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,681 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
258 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,441 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.

  2. 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

  3. 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

  4. Pinaki Ghatak 4,290 Reputation points Microsoft Employee
    2024-05-20T08:37:24.49+00:00

    Hello @Ashish Ruparel

    This could be due to a number of reasons, but let's try to troubleshoot this together.

    Firstly, can you confirm that you are using the latest version of the Azure PowerShell module? You can check this by running the following command in PowerShell: 

    Get-Module -ListAvailable Az.DataFactory

    If you are not using the latest version, please update to the latest version and try deploying the linked service again.

    If you are already using the latest version, can you please provide us with the PowerShell command that you are using to deploy the linked service? This will help us understand the issue better and provide you with a more accurate solution.

    Thank you.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.