Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connect ODI12c to Opendistro (elasticsearch)

mchorazyApr 24 2022

Hi,
Has anyone tried to connect ODI12c to opendistro (elastisearch) ?
I downloaded JDBC Driver: opendistro-sql-jdbc-1.13.0.0.jar
Add to ODI locations and ODI / ODI Agent see this jar file.
I create new data server like:
JDBC Driver: com.amazon.opendistroforelasticsearch.jdbc.Driver
JDBC URL: jdbc:elasticsearch://host:port
But I get error with this url ...can anyone tell me how I should configure this JDBC Url pof opendistro to get data from tables?

Comments
Post Details