# How to integrate elasticsearch with multiple MS access database **URL:** \ **Category:** Elasticsearch\ **Created:** [October 18, 2017, 1:18pm UTC](https://discuss.elastic.co/t/how-to-integrate-elasticsearch-with-multiple-ms-access-database/104393 "2017-10-18T13:18:34Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Nishan\_Singh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nishan_singh/32/23152_2.png) [@Nishan\_Singh](https://discuss.elastic.co/u/Nishan_Singh)\ **Post date:** [October 18, 2017, 1:18pm UTC](https://discuss.elastic.co/t/how-to-integrate-elasticsearch-with-multiple-ms-access-database/104393/1 "2017-10-18T13:18:34Z")
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. ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [October 18, 2017, 1:20pm UTC](https://discuss.elastic.co/t/how-to-integrate-elasticsearch-with-multiple-ms-access-database/104393/2 "2017-10-18T13:20:48Z")
Does it support JDBC? ---
**Author:** ![Nishan\_Singh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nishan_singh/32/23152_2.png) [@Nishan\_Singh](https://discuss.elastic.co/u/Nishan_Singh)\ **Post date:** [October 18, 2017, 1:22pm UTC](https://discuss.elastic.co/t/how-to-integrate-elasticsearch-with-multiple-ms-access-database/104393/3 "2017-10-18T13:22:51Z")
it's actually odbc database. can odbc database call from elasticsearch jdbc plugin ---
**Author:** ![forloop](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/forloop/32/9021_2.png) [@forloop](https://discuss.elastic.co/u/forloop)\ **Post date:** [October 18, 2017, 2:35pm UTC](https://discuss.elastic.co/t/how-to-integrate-elasticsearch-with-multiple-ms-access-database/104393/4 "2017-10-18T14:35:39Z")
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](http://www.easysoft.com/applications/microsoft-access/jdbc-odbc.html) in conjunction with [Logstash JDBC input plugin](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html) to index the data into Elasticsearch. An alternative may be to write a small .NET program that uses [`OleDbConnection`](https://msdn.microsoft.com/en-us/library/system.data.oledb.oledbconnection(v=vs.110).aspx) and the .NET client to bulk index the data from Access into Elasticsearch. ---
**Author:** ![Nishan\_Singh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nishan_singh/32/23152_2.png) [@Nishan\_Singh](https://discuss.elastic.co/u/Nishan_Singh)\ **Post date:** [October 18, 2017, 3:10pm UTC](https://discuss.elastic.co/t/how-to-integrate-elasticsearch-with-multiple-ms-access-database/104393/5 "2017-10-18T15:10:58Z")
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. ---
**Author:** ![forloop](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/forloop/32/9021_2.png) [@forloop](https://discuss.elastic.co/u/forloop)\ **Post date:** [October 18, 2017, 3:27pm UTC](https://discuss.elastic.co/t/how-to-integrate-elasticsearch-with-multiple-ms-access-database/104393/6 "2017-10-18T15:27:09Z")
That's not possible; Elasticsearch needs to index the data in order to search it. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 15, 2017, 3:27pm UTC](https://discuss.elastic.co/t/how-to-integrate-elasticsearch-with-multiple-ms-access-database/104393/7 "2017-11-15T15:27:31Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.