Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OAC fails to connect Azure SQL Data Warehouse (Synapse)

Summary
OAC can connect to Azure SQL server not SQL datawarehouse (Synapse)
Content
OAC is not able to connect Azure Synapse data warehouse either through direct connection or through data gateway.
With direct connection by white listing IP, we get following error
[ODBC SQL Server Wire Protocol driver][SQL Server]Setting QUOTED_IDENTIFIER to 'OFF' is not supported..
With data gateway log level high, we get error like ..
020-04-30 19:15:52 FATAL datasource:141 - FAILED_TO_PARSE_TOKEN [JDSError : 4103] 4103 : Failed to parse the security token:
Cause - 4103 : Failed to parse the security token:
Action - 4103 : Failed to parse the security token:
oracle.bi.datasource.service.adf.security.BIADFTokenParser.parse(BIADFTokenParser.java:110)
oracle.bi.datasource.service.adf.server.DatasourceServlet.dumpRequest(DatasourceServlet.java:221)
oracle.bi.datasource.service.adf.server.DatasourceServlet.doGet(DatasourceServlet.java:429)
oracle.bi.datasource.service.adf.server.DatasourceServlet.doPost(DatasourceServlet.java:740)
javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
Version
Data gateway 105.5
Answers
-
As per the OAC documentation whilst Azure SQL Server is a supported data source Azure SQL datawarehouse (Synapse) is not.
0 -
To add, the message is clear:
QUOTED_IDENTIFIER to 'OFF' is not supported
This is not supported by DV connections
Set QUOTED_IDENTIFIER to 'ON'0