Use this tag for questions about the linked service which one must create to link a data store to the Azure Data Factory or Azure Synapse Workspace before a dataset is created.
Questions tagged [linked-service]
49 questions
0
votes
0 answers
How to configure the Oracle 19c database connectionstring in ODBC Linked service in Azure Data Factory
We want to connect to an Oracle 19c database on ssl connection using ODBC Linked service.
When we configure DSN on the SHIR machine - we give "DSN=oracle_service_name" in the ConnectionString field while configuring the linked service and these are…
azuresnowflake1
- 135
- 1
- 10
0
votes
1 answer
Create AKV linked service to Azure SQL Database with parameters for the database name in Microsoft adf
So in ADF, im trying to create a linked service to an Azure SQL Database where the connection string is stored in the key vault. The connection host many databases so the database name is not declared.
However, I also want to be able to add a…
jo80
- 21
- 2
0
votes
1 answer
Azure data factory Error : InvalidTemplate, ErrorMessage=The template function 'linkedService' is not defined or not valid
I need to use different Keyvaults for different environments (Dev/Test/UAT/Prod).
So, the name of the keyvault to be used is stored the Global Parameters, and is propagated from pipelines to other resources by means of parametrizing those…
Dmitriy Ryabin
- 363
- 3
- 16
0
votes
2 answers
Mapping Data Flow Azure
I am flattening a Json File to CSV file using mapping data flow in Azure data factory, the issue is that files is placed in storage container which is behind firewall. As it looks Only Auto Resolve integration runtime is supported in Mapping Data…
Anshul Dubey
- 349
- 4
- 14
0
votes
1 answer
How can i get refresh token from xero custom connetion
How can i get refresh token from xero custom connetion, when i work with previous account i could get this refresh token. but now it it now provided.now when i use this https://identity.xero.com/connect/token result is only {
"access_token":…
chamith rasintha
- 211
- 2
- 4
0
votes
1 answer
Azure linked service using python
I have created a Linked service in azure data factory using azure portal. I want to connect to this Linked service in notebook activity in synapse using python. Do we have any such api?
Please let me know.
Thanks
sac
- 175
- 2
- 14
0
votes
1 answer
Azure synapse linked service for Azure Function in Terraform
I'm writing a terraform script to create a azure synapse workspace.
I've created a linked service for Azure Function but I'm unable to use it in pipeline, where it gives me an error of missing function key.
This is what i'm using now. I'm sure the…
Ehsan
- 3
- 3
0
votes
1 answer
Setting up Azure Synapse Analytics Linked Service to ODBC linked server
A vendor provided access to their server via ODBC connector that created a SYSTEM DSN on my local machine. I would like to replicate the data in Azure Synapse data lake for analysis.
The Azure Synapse Linked Service configuration does not allow me…
Alen Giliana
- 2,144
- 3
- 17
- 30
0
votes
1 answer
How to connect to DB2 database with SSL enabled in Azure Data Factory?
I have an on-prem machine for DB2 connectivity to ADF where SHIR is installed, and I have been provided with the certificate zip file.
How to use SSL certificate for linked service of DB2 in data factory and how to get that certificate common name…
0
votes
1 answer
Azure data factory with a copy activity using a binary dataset fails to copy folder contents if parameterized
In my Azure data factory I need to copy data from an SFTP source that has structured the data into date based directories with the following hierarchy
year -> month -> date -> file
I have created a linked service and a binary dataset where the…
Necropants
- 5
- 3
0
votes
1 answer
Can you use JDBC sources via Azure Linked Services using the Azure Integration Runtime on a remote machine?
All,
We are in the process of migrating our clients to ADF using Integration Runtimes. The clients have the Azure Integration Runtime installed on an on-premise server and we are needing to pull data from a remote database through that connection. …
Brian Anderson
- 1
- 1
0
votes
1 answer
Azure data factory connecting to MongoDB via linked service connection timeout
I am trying to create a linked service in ADF to connect to a MongoDB and I am getting 30 second server timeouts.
I have the connection string and I can connect using Compass - my computer IP address is whitelisted - but I cannot connect through…
xyzzy_plover5
- 33
- 5
0
votes
1 answer
The folder name is invalid on selecting SFTP path in Azure data factory?
I am trying to create a dataset for a SFTP linked to service in the azure data factory pipeline. After selecting the path I am getting the error "The folder name is invalid".
Here is the Image
nado1122
- 19
- 1
- 3
0
votes
1 answer
Parameterize Managed Private Endpoint in Blob Linked Service ADF
I need to use multiple Blob Storage Accounts in ADF. I am trying to create a single linked service for all storages with parameters. I unable to parameterized managed private endpoint. When I hardcode storage name then managed private endpoint…
Zuberkhan Pathan
- 13
- 2
0
votes
2 answers
Can we use different run-time in Copy Activity of Azure Data Factory?
I am using Copy Activity for migrating the Data from On-premises Database to the on-cloud Database. Here I am using Self-Hosted Integration Runtime for both on-premises and on-cloud databases.
The Integration run-time is different for on-premises…
Azure Cloud Enthusiast
- 85
- 1
- 11