Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
OAC fails to connect Azure SQL Data Warehouse (Synapse) — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OAC fails to connect Azure SQL Data Warehouse (Synapse)

Received Response
17
Views
2
Comments
edited May 14, 2020 4:15PM in Oracle Analytics 2 comments

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!