How to integrate elasticsearch with multiple MS access database

Elastic Stack Elasticsearch
1

we have multiple MS access database and i want to search in those mdb using elasticsearch.
is it possible to do that using any plugin.

2

Does it support JDBC?

3

it's actually odbc database. can odbc database call from elasticsearch jdbc plugin

4

You would need to import the data from the Access database into Elasticsearch in order to search over it.

It may be possible to use a third party JDBC driver for MS Access in conjunction with Logstash JDBC input plugin to index the data into Elasticsearch.

An alternative may be to write a small .NET program that uses OleDbConnection and the .NET client to bulk index the data from Access into Elasticsearch.

5

Thanks Russ for the reply
Right now I m doing that only but I m just search for the possibility of accessing data directly from mdb using elasticsearch.

6

That's not possible; Elasticsearch needs to index the data in order to search it.

7

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