Create EXTERNAL DATA SOURCE to Azure SQL Database from Synapse

Waleed Ebrahiem 31 Reputation points
2021-05-04T08:49:15.577+00:00

Hi

I have azure data warehouse, I need to create external data source with a azure sql server (RDBMS).

I am using SSMS to create it.

When I use the normal statement to create the external data source like below:

CREATE EXTERNAL DATA SOURCE [****_Internal] WITH (TYPE = RDBMS,
LOCATION = N'*******.database.windows.net', CREDENTIAL = [****User], DATABASE_NAME = N'****_NDW_TEST')

I got this message:

Msg 103010, Level 16, State 1, Line 2
Parse error at line: 1, column: 61: Incorrect syntax near 'RDBMS'.

I am not sure if the listed statement works with data warehouse or not!

Any advice please.

Regards

Waleed

Azure SQL Database
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.
4,396 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,891 Reputation points MVP
    2021-05-18T16:45:02.283+00:00

    Hey,
    External data source of type=rdbms is supported in Azure SQL databases for elastic queries and unfortunately as mentioned by others,it is still not supported in Azure synapse or formerly SQL database house.
    You can upvote for that request in Azure feedback for this feature.

    1 person found this answer helpful.
  2. Olaf Helper 40,901 Reputation points
    2021-05-04T11:19:38.537+00:00
    0 comments
  3. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-05-04T11:28:52.22+00:00

    @Waleed Ebrahiem Thank you for reaching out.
    From Azure Synapse Analytics (formerly Azure SQL DataWarehouse), you can connect to the below external data sources:

    • Azure Data Lake Store Gen 1
    • Azure Data Lake Store Gen 2
    • Azure V2 Storage account

    Using an Azure SQL Database as an external data source is currently not supported.

    However, you can use Azure Data Share to share data from your Azure SQL Database to a Data Lake or blob storage in CSV or parquet formats and then consume the snapshot as an External Data Store.

    ----------

    If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.

    0 comments