Connecting Logstash to Microsoft Access DB?


(Christopher Rumsey) #1

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:

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) #2

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


(Christopher Rumsey) #3

@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.


(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.