SAP Knowledge Base Article - Preview

3557031 - User can not add views to an Universe based on Azure Synapse Analytics using ODBC connection.

Symptom

When trying to add views to the data foundation layer, (add a view to the Universe)  connected to Azure Synapse Analytics DB, using ODBC connection, with Native driver Microsoft ODBC Driver 17, the following error message is displayed: 

"Microsoft [ODBC Driver 17 for SQL Server] [ SQL Server] store procedure sp_ddopen does not exist or is not supported"


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4.3 SP3 and above
  • MS SQL Server 2022
  • Azure SQL Data Warehouse -10.0.33051.0
  • Data Source: Microsoft Azure Synapse  
  • Azure Active Directory Password Authentication using User and Password informed by user.

Product

SAP BusinessObjects Business Intelligence platform 4.3

Keywords

IDT, ODBC, Azure Synapse Analytics, Microsoft ODBC Driver 17 for SQL Server, sp_ddopen, UNX, universe, views, Azure Active Directory,  Authentication, username, password, JDBC. , KBA , BI-BIP-IDT , Information design tool , BI-BIP-SL , Semantic Layer , BI-BIP-UDT , Universe Design Tool , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.