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