Ms Access Database Connection

CloverDX Platform
1

Hi All,
I’m trying to create a graph that extracts data from a Ms Access Database.
I created a Metadata with url = “jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Database.mdb”,
then, when I clicked next I got the following error message:
[Microsoft][Controlador ODBC ]Función opcional no implementada.
In English is someting like: [Microsoft][ODBC Microsoft Access Driver] Optional feature not implemented.
What I need to do? Someone can help me?
Thank you for your help!

2

That is probably correct. One way to go round it is to create metadata description by hand. Clover will complain about missing meta info from the driver but should be able to run the query.

Nonetheless we will check MS Access interoperability and let you know.

David.

3

I think that’s what I’ll have to do (manually create the CloverETL metadata description) from the MS Access table definitions.

I was going to search for some other JDBC drivers to try (instead of the sun ODBC-JDBC bridge) to see if some other driver could extract the table definition meta information from MS Access. Has anyone tried different drivers to do this? Would I be wasting my time pursuing other drivers?

thanks

cliff

4

I have run into the same problem.
I think it may be because MS Access cannot return the meta information required to define the table schemas -
Can someone confirm this suspicion?

thanks

5

See related topic for some more info.