OLAP/SSAS connection with Sybase data base

Current App Infrastructure:

Windows Server 2016

SSAS/OLAP Server 2019 (Analysis Services only; no SQL Database Engine and used Multidimensional Model - Cubes, dimensions)

SAP Sybase ASE 16.x (16.1 SP00 PL02)

Existing cube connectivity uses Sybase OLE DB Driver 15.5 (Provider=ASEOLEDB.1)

Hygiene Initiative -

Planned migration from Windows Server 2016 to Windows Server 2019

During this upgrade, the current Sybase OLE DB 15.5 driver is not supported

Validation Performed:

Attempted OLE DB upgrade to Sybase 16 client :

Installed SAP Sybase ASE Open Client 16.0 SP04 PL06 in local Machine.

SAP KBA 2970913 confirms that the OLE DB provider is not included in SDK/Open Client for ASE 16.0 and above

Conclusion: no supported native Sybase OLE DB provider is available in ASE 16+ client stack

Reference:

https://userapps.support.sap.com/sap/support/knowledge/en/2970913

Attempted ODBC DSN connectivity:

Created ODBC DSN successfully for Sybase ASE

In Visual Studio 2015 (SSAS multidimensional data source setup), ODBC DSN cannot be selected as a supported source

Microsoft documentation confirms ODBC data sources are not supported for SSAS Multidimensional models

Reference:

https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/supported-data-sources-ssas-multidimensional?view=sql-analysis-services-2025

Attempted Linked Server workaround:

Linked Server requires SQL Server Database Engine

Current OLAP server is Analysis Services only, so Server Objects/Linked Server option is not available

Therefore this workaround is not feasible in current topology

Reference:

https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver17

Can you please suggest on this or what is workaround for this.