question

WaleedEbrahiem-7274 avatar image
0 Votes"
WaleedEbrahiem-7274 asked NandanHegde-7720 commented

Create EXTERNAL DATA SOURCE to Azure SQL Database from Synapse

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-databaseazure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered KalyanChanumolu-MSFT edited

@WaleedEbrahiem-7274 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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NandanHegde-7720 avatar image
1 Vote"
NandanHegde-7720 answered NandanHegde-7720 commented

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hey,
Did any of the replies answered your query?
If yes, then please accept it as answer as it would benefit other community members

0 Votes 0 ·