3734407 - Analytic Model missing from JDBC/ODBC tables list

• The Analytic Model is not listed as a table or view when accessed via a JDBC/ODBC connection.
• The same Analytical Model is accessible and works in SAP Analytics Cloud (SAC).
• No error messages are shown.

• SAP Datasphere

1. Deploy an Analytical Model in the Data Builder.
2. Verify the model is accessible in SAC.
3. Connect to the space/database via JDBC/ODBC and browse tables/views; the Analytical Model does not appear.

• This is expected behavior: only views exposed for consumption are visible via JDBC/ODBC connections.
• Analytical Models are not exposed via SQL/ODBC and should be consumed via OData.

1. Do not expect analytical models to appear in SQL/ODBC catalogs.
2. Consume the analytical model via OData by configuring an OData connection in the consuming tool.
3. If SQL/ODBC access is required, expose a view for consumption in the data builder and query that view via ODBC instead of the Analytical Model.

Consuming Data Exposed by SAP Datasphere

odbc, analytical model, missing from tables, not listed, sql catalog, sac visible, power bi, odata, consumption-exposed view, datasphere, analytic dataset, cube, data builder, expose for consumption, connection visibility , KBA , DS-MD-AM , Analytic Model , Problem