# Access Elasticsearch Data as a Remote Oracle Database **URL:** \ **Category:** Elasticsearch\ **Created:** [December 14, 2023, 10:54am UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350 "2023-12-14T10:54:26Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![onr1onr1](https://avatars.discourse-cdn.com/v4/letter/o/e68b1a/32.png) [@onr1onr1](https://discuss.elastic.co/u/onr1onr1)\ **Post date:** [December 14, 2023, 10:54am UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350/1 "2023-12-14T10:54:26Z")
We want to set up a dblink from the Oracle database to eleastic search and pull information, but we get the following error in the dblink. We could not find a source on this site, so we did it by following the steps in the link below. > **[Access Elasticsearch Data as a Remote Oracle Database](https://www.cdata.com/kb/tech/elasticsearch-odbc-oracle-hs.rst)** > > Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Elasticsearch data from your Oracle system. Our dblink is not working, what could we be missing? Is there an rpm package on this site for ODBC? ---
**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\ **Post date:** [December 14, 2023, 10:57am UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350/2 "2023-12-14T10:57:30Z")
Hi @onr1onr1, Welcome! I don't see the specified error you are receiving in your post, so can you please share the exact error message? Which version of Elasticsearch are you using? Have you also checked that the version of the driver you are using is compatible with the version of Elasticsearch that you're using? ---
**Author:** ![onr1onr1](https://avatars.discourse-cdn.com/v4/letter/o/e68b1a/32.png) [@onr1onr1](https://discuss.elastic.co/u/onr1onr1)\ **Post date:** [December 14, 2023, 12:01pm UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350/3 "2023-12-14T12:01:04Z")
Hi elasticsearch version = 7.17.6 I downloaded rpm from this link ElasticsearchODBCDriverforUnix.rpm installed the other rpm. unixODBC-2.3.1-14.el7.x86\_64.rpm I downloaded rpm from this link and installed the other rpm. In general, I followed the steps in the link I shared. If you want, I can send the settings I made as a picture ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/a/fa2057bf5edcd349ef7078bda730155af6c629fc.png) ---
**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\ **Post date:** [December 14, 2023, 12:49pm UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350/4 "2023-12-14T12:49:04Z")
Hi @onr1onr1, You haven't provided the link to the driver so it's difficult to determine compatibility. Searching for the error you have in the screenshot it looks like an issue with your authentication settings [as per this Oracle article](https://docs.oracle.com/en/error-help/db/ora-28546/). I would recommend checking your login settings are correct. ---
**Author:** ![onr1onr1](https://avatars.discourse-cdn.com/v4/letter/o/e68b1a/32.png) [@onr1onr1](https://discuss.elastic.co/u/onr1onr1)\ **Post date:** [December 14, 2023, 1:46pm UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350/5 "2023-12-14T13:46:20Z")
1. So are the steps correct on the site I referenced? 2. Which information of elasticsearch do I need to establish a dblink connection? Do I need Elasticsearch's server information? cat /etc/odbc.ini Driver = CData ODBC Driver for Elasticsearch Description = myelasticsearchdb Server = 1.2.3.4 (elasticsearch server ip-I wrote it differently here for security) Port = 9200 User = elastic Password = password123 You have new mail in /var/spool/mail/root (SID\_DESC = (ORACLE\_HOME = /ora1912\_home/orahome) (SID\_NAME = myelasticsearchdb) (PROGRAM = dg4odbc) (ENV="LD\_LIBRARY\_PATH=/usr/lib64:/opt/cdata/cdata-odbc-driver-for-elasticsearch/lib:/ora1912\_home/orahome/lib") ) ``` myelasticsearchdb = ``` (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=my oracledb server ip )(PORT=1521)) (CONNECT\_DATA=(SID=myelasticsearchdb)) (HS=OK) ) ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [December 14, 2023, 1:48pm UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350/6 "2023-12-14T13:48:31Z")
It looks like you are using some third party ODBC driver, which is not supported here. I would recommend you reach out to the vendor in question. ---
**Author:** ![onr1onr1](https://avatars.discourse-cdn.com/v4/letter/o/e68b1a/32.png) [@onr1onr1](https://discuss.elastic.co/u/onr1onr1)\ **Post date:** [December 14, 2023, 1:51pm UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350/8 "2023-12-14T13:51:08Z")
I don't have to use this drive. How can I find a driver that is not a third party? ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [December 14, 2023, 2:01pm UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350/9 "2023-12-14T14:01:27Z")
Elastic offers [an ODBC driver](https://www.elastic.co/guide/en/elasticsearch/reference/7.17/sql-odbc.html), but be aware that this requires a commercial license. ---
**Author:** ![onr1onr1](https://avatars.discourse-cdn.com/v4/letter/o/e68b1a/32.png) [@onr1onr1](https://discuss.elastic.co/u/onr1onr1)\ **Post date:** [December 14, 2023, 2:12pm UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350/10 "2023-12-14T14:12:53Z")
Is there one for linux? ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [December 14, 2023, 2:19pm UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350/11 "2023-12-14T14:19:42Z")
I have never used it, but based on the docs it does not look like there is. ---
**Author:** ![onr1onr1](https://avatars.discourse-cdn.com/v4/letter/o/e68b1a/32.png) [@onr1onr1](https://discuss.elastic.co/u/onr1onr1)\ **Post date:** [December 14, 2023, 2:27pm UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350/12 "2023-12-14T14:27:26Z")
Is it possible to get the data from the oracle database on the linux server to an elasticsearch on the linux server with db link? ---
**Author:** ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)\ **Post date:** [December 14, 2023, 2:38pm UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350/13 "2023-12-14T14:38:03Z")
The only official offering is the ODBC driver that requires a Commercial License and run on Windows Machine. Anything else is third-party and you would need to test yourself, and since it is not something that is not widely used, so I'm not sure you will be able to get much help on the forum. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 11, 2024, 2:39pm UTC](https://discuss.elastic.co/t/access-elasticsearch-data-as-a-remote-oracle-database/349350/14 "2024-01-11T14:39:04Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.