DataSphere Connection to MS Access

[robert_schmidt01]

Hi,

I want to create a connection in DataSphere that will allow me to connect to MS Access.

How can I do this?

Thanks.

[XaviPolo]

I haven't tested it, but in theory you should be able to do it through the JDBC connection.

Prepare Connectivity for Generic JDBC | SAP Help Portal

Apache Camel JDBC | SAP Help Portal

Probably, the connection string will be something like

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=<filepath_to_MSAccessDB>

[robert_schmidt01]

This is also what I thought, but MS Access does not have a JDBC driver. There are third party JDBC drivers, but I want to avoid using one.