Connection to Microsoft Access

[#1]

Hi,

I am looking forward to connect to MS Access DB in SAC. Is this feature available yet? How can we connect to it?

I was reading through the SAP Help Portal, but couldn't get it.

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/bdf055159cbb4f36b26c93ccb...

Please help with pointers.

Warm Regards,

Debashish

[VijayetaSharma]

Hello debpattnaik,

Unfortunately MS Access is not yet supported. You can find supported Non SAP DB's in below link.

Import Data Connection to an SQL Database

If you find shared info helpful, don't forget to accept (accept button at the bottom) and vote (voting arrows on the left).

Thanks,

Vijayeta

[Vitaliy-R]

From what I can see JDBC driver is required for SQL databases to be connected, but I did not see availability of JDBC driver on MS Access website. Only ODBC is described there as an option.

[Katryn_Cheng]

As Vijayeta mentioned, MS Access is not officially supported but another option might be to use an OData ODBC Driver. SAC supports:

• OData version 2.0 compatible sources
• OData version 4.0 compatible sources

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/11b4e5ff76eb4747bc255d703...