Symptom
An error occurs when attempting to pull a table from a schema using an Azure Synapse SQL (serverless) endpoint in a data flow. Error message: "Get metadata request could not be performed due to an error returned by DS-Lite (MDS): FUNCTION object_schema_name is not supported. Statement(s) could not be prepared."
Environment
SAP Datasphere
Reproducing the Issue
- Configure a data flow to connect to an Azure Synapse serverless SQL endpoint.
- Attempt to browse or pull a table from a schema.
- Observe the error: "Get metadata request could not be performed due to an error returned by DS-Lite (MDS): FUNCTION object_schema_name is not supported. Statement(s) could not be prepared."
Cause
The SQL metadata function object_schema_name is not supported in DS-Lite, causing metadata retrieval to fail. Azure Synapse SQL endpoints are not currently supported in SAP Datasphere/Data Intelligence; only Microsoft Azure SQL Database is supported via the Microsoft SQL Server connection type.
Resolution
- Connect to a supported source: use Microsoft Azure SQL Database or Microsoft SQL Server connection type and re-run the data flow.
- If Azure Synapse SQL endpoint connectivity is required, submit an enhancement request and track it through the SAP Influence portal
See Also
- KBA: 3332382 - How to create an enhancement request for SAP Datasphere?
- SAP Help: Microsoft Azure SQL Database Connections
- SAP Help: SQL Server Log Reader (SDI)
- SAP Community: Data Federation Between SAP Datasphere and Azure Synapse
- SAP Help: Microsoft SQL Server Connections
Keywords
object_schema_name, FUNCTION object_schema_name is not supported, DS-Lite, Get metadata request could not be performed, Statement(s) could not be prepared, Datasphere data flow, Azure Synapse SQL, serverless endpoint, metadata retrieval error, table pull failure, connector not supported, Azure SQL Database, Microsoft SQL Server connection, SDI DP Agent, data federation , KBA , DS-DI-DF , Data Flows , Problem
SAP Knowledge Base Article - Public