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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

OAC fails to connect Azure SQL Data Warehouse (Synapse)

Received Response
21
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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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