Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,574 questions
1 answer
Can we execute a Stored procedure(Azure SQL DB) through synapse Notebook??
I have created stored Procedure which has Merge Statement to perform slowly changing dimension, I would like to execute this Stored procedure from synapse notebook. Is there any way to perform this ?
Azure Synapse Analytics
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2022-08-23T10:54:48.037+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 52%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
Heta Desai
337
Reputation points
answered
2026-11-13T10:51:29.5633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 94%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
mouza mohammed
0
Reputation points
1 answer
Azure Data Factory Linked Service settings for SQL is not consistent when deployed via CI/CD
In the development Azure Data Factory (ADF) the linked sql connection's Authentication Type is set as System Assigned Managed Identity. As shown in the image bellow. The ADF is connected to Azure Repo and when deployed via ARM template in CI/CD…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2022-08-11T08:23:33.71+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 62%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDF%3C/text%3E%3C/svg%3E)
Desmond Fernando
11
Reputation points
edited an answer
2026-11-13T05:16:16.4033333+00:00
Desmond Fernando
11
Reputation points
0 answers
Data Modeling in Azure
Hi All, I would really appreciate if someone please help me with Data Modeling books within Azure scope that entails various techniques such as dimensional modeling , data vault. Any good links would be also a great help. Thanks in advance.
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,576 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,574 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2021-12-03T12:23:03.003+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 12%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Samy Abdul
3,356
Reputation points
0 answers
Index Out of Range Error When Creating SnowFlake Linked Service
I have tried several times to create a SnowFlake linked service. Every time I try I receive the same error. The portal offers no other information on what is happening. Found someone else on SO having the same issue. Can anyone help with this? The…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2020-08-06T14:29:09.89+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 61%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Albert, Christopher
1
Reputation point
0 answers
Oracle connection string in Azure Key Vault
How does one specify an Oracle connection in key vault? the connection type is a service name Unfortunately there is no information on this page: https://learn.microsoft.com/en-us/azure/data-factory/connector-oracle?tabs=data-factory So it needs…
Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,524 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2021-10-04T10:39:33.01+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 11%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
John Connor
301
Reputation points
2 answers
Data-Factory: Snowflake Linked Service KeyVault
Currently the implementation of KeyVault inside the linked service template for Snowflake is not properly done. Even when keyVault is referenced for the password I am getting the following message: It would be helpful if the the…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2020-06-29T12:01:46.277+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 57.00000000000001%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Patrick Doerig
31
Reputation points
edited an answer
2026-11-13T04:33:25.5333333+00:00
Patrick Doerig
31
Reputation points
0 answers
Can I use a KeyVault Connection String with the Azure Data Factory Mysql Linked Service Driver v2.0?
Hi all, I currently use a V1.0 MySQL linked services as part of my Azure Data Factory setup. I use a secret connection string stored in Azure Key Vault. I am being asked to upgrade the linked service driver to 2.0, but it seems this does not support the…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2025-07-02T08:34:26.1233333+00:00
Peter Rush
41
Reputation points
3 answers
Need help on parameterization of Integration Runtime and Azure Key vault Secrets on link service in Azure Data Factory pipeline
Hi, I have to migrate 90 clients database from Azure Managed Instances databases to Azure VM Data Servers. For the above requirement, I have created the below resources * 90 Azure Data Factory Pipelines * 90 self-hosted integration runtime as each…
Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,524 questions
Azure Database Migration Service
Azure Database Migration Service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
369 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,786 questions
asked
2020-12-29T17:41:43.283+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 57.00000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH0%3C/text%3E%3C/svg%3E)
HemantSudehely-0557
246
Reputation points
edited an answer
2026-11-13T04:20:30.61+00:00
HemantSudehely-0557
246
Reputation points
0 answers
Error in Web Activity - Data Factory
Need your assistance, Guys. I am building a pipeline in Azure Data Factory which will do the following steps: Query the Azure Sql DB to get list of unique email addresses (lookup1 activity) For each email address the Store Procedure will…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2020-12-23T17:17:39.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 26%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
braxx
421
Reputation points
0 answers
Not able to parameterized the linked service for Azure Batch in ADF
I want to create a parameterized linked service in Azure data factory for Azure Batch Account. But it's not giving option for adding dynamic content. So I referred the below link for supported linked services.…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2025-05-21T14:34:59.26+00:00
Rahul Gosavi
181
Reputation points
0 answers
Azure Data Factory: How to stop/start triggers in ADF environments using CI/CD release pipeline?
We would like to stop all triggers in our dev ADF environment after deploying to production. I've seen the below script being used: task: AzurePowerShell@4 displayName: 'Data Factory: Stop all triggers' inputs: azureSubscription: '${{…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2025-01-30T13:27:11.65+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 9%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Reyshma Sekar
20
Reputation points
0 answers
ADF SFTP Linked Service Error code 9978: Access to sftp(configured on one of Azure VM) is not allowed on Azure integrate runtime.
we are having issue while creating(test connection) SFTP linked service from ADF. SFTP configured in one of Azure VM. Error code 9978 Error: Access 'XXXXXXXX.corp.XXXXX.net' is not allowed on Azure integrate runtime. please suggest .
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2024-11-07T06:51:05.0366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 37%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Pamidi, Venkateswarlu
20
Reputation points
1 answer
Issues Upgrading linked service for PostgreSQL - Data Factory
I´m using the legacy LS for Postres SQL (SHIR) and the connection is working fine, with no issues until today. I need to update the linked service (MS recomend to do it until 31/10/2024) but I´m receiving an error while testing the connection for the new…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 35%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
0 answers
Linked Services for Salesforce in Azure Data Factory
I am having issue creating linked Service in Azure Data Factory to Salesforce. I get following error Unable to establish connection to the Salesforce environment using provided client id and client secret, please verify the details. Error message:…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2024-08-12T21:37:58.96+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 52%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Neha Ganatra
0
Reputation points
0 answers
Securing args of the Python script in Azure Data Factory Custom Azure Batch Activity
Hi, Imagine running a simple ADF Pipeline that consists of 2 steps: Fetching a sensitive value - like Storage Account URL - from Azure Key Vault Executing a Python script with argsparse where this value is set as an argument with the command …
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2024-07-29T07:58:14.4633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 20%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E14%3C/text%3E%3C/svg%3E)
11-4688
191
Reputation points
0 answers
How to connect and query with MySQL server using Azure Machine Learning
Hi, I am currently working on a project where I need to connect to an Azure Database for MySQL using Azure Machine Learning (AML) and Python scripts. However, I want to use AML resources such as Datastore and Dataset for the connection rather than…
Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
3,673 questions
Azure Storage
Azure Storage
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,843 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
1,249 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
2,084 questions
asked
2024-07-23T07:30:11.6466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 33%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Nguyễn Thanh Tú
150
Reputation points
0 answers
I wan use Show billing report by pipeline in ADF, and enabled this via CI/CD
I want enabled the feature "Show billing report by pipeline " in azure Data Factory, but I don't know how can I enabled this via Terraform deployment or ARM template deployment. How Can I do that ?
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2024-07-03T15:15:45.9433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 9%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Benjamin Baele
5
Reputation points Microsoft Employee
0 answers
How to create service principal, link to the azure sql database in the azure portal.
I want to know how to create service principal to connect to azure SQL server database. (I tried by creating user assigned identity. But this also not succeeded.) The user assigned manage identity is configured by, *create user assigned manage identity…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2024-05-12T04:20:51.1966667+00:00
Athula Chandrawansha
20
Reputation points
0 answers
Copy files from Sharepoint into Azure Data Lake Store Gen 2 using ADF linked services ?
I have to copy files from Sharepoint into Azure Data Lake Store Gen 2 using ADF linked services
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,576 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
Microsoft 365 and Office | SharePoint | For business | Windows
Microsoft 365 and Office | SharePoint | For business | Windows
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
30,083 questions
asked
2024-02-28T13:23:10.42+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 96%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Jaydeep Kumbhar
20
Reputation points
1 answer
Excel or CSV file to XML - ADF
Hi, I want to convert excel/csv file into XML format. This xml is used as a body text for a rest api. Basically i need to send excel data to a REST API using ADF. Rest API accepts xml format. excel file is present in storage container. What are the…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
Microsoft 365 and Office | SharePoint | For business | Windows
Microsoft 365 and Office | SharePoint | For business | Windows
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
30,083 questions
asked
2024-02-26T06:42:22.1933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Santhi Dhanuskodi
345
Reputation points
edited an answer
2026-11-13T03:56:24.8566667+00:00
Santhi Dhanuskodi
345
Reputation points