CODEWITHSUNDEEP
business-intelligenceobieeoracle-bi
Robin Weston
Robin Weston

Reputation: 873

How do you add an HTTP API as a data source to Oracle Business Intelligence Enterprise Edition (OBIEE)?

Am I able to add an HTTP API endpoint (e.g. Elasticsearch HTTP query) directly as a data source in OBIEE? I can't find any documentation online regarding this.

If this is not a supported feature, what other solutions exist e.g. export API endpoints regularly as flat files and add them as datasources?

Upvotes: 1

Views: 1345

Answers (1)

Robin Moffatt
Robin Moffatt

Reputation: 32090

OBIEE doesn't support HTTP API endpoints as a datasource. BI Publisher supports SOAP web service calls, but not RESTful ones such as Elasticsearch.

If you want to query Elasticsearch one option to consider is somewhat convoluted but possible - use ES-Hadoop to expose your Elasticsearch to Hive, and then connect OBIEE to Hive.

Upvotes: 2

Related Questions