3252534 - IDT Connection to Azure Synapse with Single Sign On Integrated Security

• Create a connection in Information Design tool to Azure Synapse Active Directory returns errors:
• If integratedSecurity = True Cannot set "Authentication" with "IntegratedSecurity" set to "true".
• If IntegratedSecurity=False getting below error: The driver could not establish a secure connection to SQL Server by using Security Sockets Layer(SSL) encryption. Error:"java.security.cert.CertificateException: Failed to validate
  the server name in a certificateConnectionId:792dfa92-bfaa-4365-b537-7beba01e6df8

• SAP BusinessObjects Business Intelligence platform 4.x
• Information Design Tool (IDT)
• Universe Design Tool (UDT)
• Web Intelligence (WEBI)
• Microsoft Azure Synapse
• Microst Azure Active Directory V2

For assistance with Authentication issues, please open a case with the Authentication team. Microsoft Sql Server Database Authorization , KBA , BI-BIP-IDT-CX , Connection Layer , Problem