Connecting Logstash to Microsoft Access DB?

[chrisrumz (Christopher Rumsey)]

Is connecting Logstash to a Microsoft Access database possible? I've tried many ways, including adding the Java 7 JDBC-ODBC bridge to my Java 8 install as mentioned in this article:

Removal of JDBC ODBC bridge in java 8

or open-source solutions like "UCanAccess" found at this site:

http://ucanaccess.sourceforge.net/site.html

I have been able to use the JDBC input plugin for connecting to SQL databases with no issues. But I have had no success with these other driver libraries used to connect to a Microsoft Access database.

Thanks in advance for any reply.

[Alexis_Hodiquet]

Hi have you found the solution?
Im trying to use Ucanacess. But it doesn't find the driver éven I add it in the configuration file and infants the classpath:

CLASSPATH=(jar path) ./logstash -f file.config

[chrisrumz (Christopher Rumsey)]

@Alexis_Hodiquet: I have tried the method you've mentioned, but was not successful. We are leaning towards an alternative solution; A .NET developer at our company is making a windows service that will actively pull the live data from our Access databases and feed it into elasticsearch. Not the solution I wanted, but it will have to do.

If I find out anything, I'll be sure to post it.

Thanks.