is there a SAP OLE DB provider?

[Former Member]

sometimes it would be useful to access a SAP DB directly from an OLE DB client (Access and the like).

performing the same with raw db data - through SQL Server OLE DB provider - is not the same for clustered tables such as BSEG.

are you aware of such component?

thank you.

[Former Member]

Dear Matro,

I strongly recommend that you do not attempt to access the SAP database directly using any utility such as an ODBC or OLE DB connector or similar. If you do so it is very likely SAP will not support you if you have any application level data integrity problems.

Please review the excellent post by Clas :

You need to remember that cluster tables in SAP are “joined” by the SAP kernel at runtime and are therefore not accessible.

Thanks

N.P.C

[Former Member]

hi N.P.C.,

ODBC and OLE DB are not utilities but interfaces to a data source.

I don't want to access SAP databases directly, that's why I'm looking for a SAP OLE DB provider.

such provider should take advantage of SAP kernel to get data from SAP environment, without accessing SQL Server tables directly.