title: Create external data source in Azure Synapse Analytics (Azure SQL Data warehouse) to Oracle
body: <p>I am trying to create external data source in Azure Synapse Analytics (Azure SQL Data warehouse) to Oracle external database. I am using the following code in SSMS to do that:</p>
  
  <pre><code>CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'myPassword';
  CREATE DATABASE SCOPED CREDENTIAL MyCred WITH IDENTITY = 'myUserName', Secret = 'Mypassword';
  CREATE EXTERNAL DATA SOURCE MyEXTSource
  WITH (
  LOCATION = 'oracle://&lt;myIPAddress&gt;:1521',
  CREDENTIAL = MyCred
  )
  </code></pre>
  
  <p>I am getting the following error:</p>
  
  <pre><code>CREATE EXTERNAL DATA SOURCE statement failed because the 'TYPE' option is not specified. Specify a value for the 'TYPE' option and try again.
  </code></pre>
  
  <p>I understand from the below that TYPE is not a required option for Oracle databases.</p>
  
  <p><a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=azure-sqldw-latest" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=azure-sqldw-latest</a></p>
  
  <p>Not sure how what the problem is here, is this feature still not supported in Azure Synapse Analytics (Azure DW) when it is already available in MS SQL Server 2019? Any ideas are welcome.</p>