1

I tried it via SSMS, but i don't see the linked server folder in object explorer.

Tried creating via T-sql stored procedure, but the sp_addlinkedserver (and also other linked server related) does not exist.

I cannot see it in the SP section at all, cannot see it in master DB too. I am using, Azure sql server ADW on cloud, do not see many of the SPs that are other wise available as part of SQL server.

softwares and their versions------->>

  1. SQL server version 2019 microsoft sql server 2012 native client

  2. installed microsoft odbc driver 17 for sql server installed SQL

  3. Server Management Studio (SSMS) 15.0.18206.0 Microsoft Analysis

  4. Services Client Tools 15.0.1567.0 Microsoft Data Access

  5. Components (MDAC) 10.0.18362.1 Microsoft MSXML 3.0 6.0

Can anyone tell me what I am doing wrong here??

I have been trying to find the definition of the SP sp_addlinkedserver but unable to find it. IF i find this, i will myself add it in the DW. Please help me. Thanks

Improve this question
7
  • You can't.. and you shouldn't. I suggest you use a more enterprise grade integration method such as ADF Commented Mar 19, 2020 at 12:11
  • Can you clarify exactly what SQL Server you are using? SQL Server in an Azure VM? SQL PaaS? SQL data warehouse? (Synapse). Commented Mar 19, 2020 at 12:12
  • azure sql server ( cloud) Commented Mar 19, 2020 at 12:44
  • using ADF by creating a linked service is another alternative. But i want to query directly. Commented Mar 19, 2020 at 12:45
  • Azure SQL Server doesn't support linked servers. I think there are workarounds with OPENQUERY but it's a bad idea. Commented Mar 19, 2020 at 13:22

1 Answer 1

Reset to default
0

Azure SQL DW doesn't support linked server:

enter image description here

If you want copy data between Azure DW and MongoDB, Maybe you can try Data Factory. Reference:

  1. Copy data from MongoDB using Azure Data Factory.
  2. Copy and transform data in Azure Synapse Analytics (formerly Azure SQL Data Warehouse) by using Azure Data Factory

Hope this helps.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.