nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OrientDB connection to Oracle BI Publisher 11g

3517559

We are trying for an POC to establish a connection to OrientDB in BI Publisher to access data and create report.

But we are not seeing any orientdb drivers to create a connection, please help on this if any one come across in this situation.

Also, Let us know Is there any feasibility to generate OBIEE/BI Publisher 11g reports based on OrientDB (version community 3.0.18 edition )

Thanks,

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

OrientDB seems to have a JDBC driver, BI Publisher can use your own JDBC drivers, you just need to connect the pieces together.

Look at the BI Publisher doc on where to put the JDBC driver files and how to configure it.

To get the JDBC for OrientDB you need to get it by yourself or ask them.

3517559

Hi Gianni,

we have downloaded the orientdb JDBC drivers and unzipped and updated the environment variables in path with jar files location.

Tried to create new JDBC from BI publisher to connect with OrientDB but it is showing "datasource :null" error and not connecting.

Is it possible to have the connection to OrientDB from Oracle BI Publisher because as per oracle's support document OrientDB is not listed.

Gianni Ceresa

Publisher can't come with all the exist JDBC connections out of the box, just because there is a huge number of JDBC drivers for various random sources.

But Publisher is supposed to be able to use your JDBC as long as it is a standard JDBC once you configure it properly, that's why the doc explain where to copy files and how to setup new JDBC connections.

I don't have that DB, so can't tell you more than that.

3517559

Hi Gianni,

we have followed this doc but not working , could you please share me the doc if any other to configure

https://docs.oracle.com/cd/E17984_01/doc.898/e14692/interactive_reporting.htm

Gianni Ceresa

Assuming you are talking about BI Publisher 11.1.1.9: https://docs.oracle.com/middleware/11119/bip/BIPAD/data_sources.htm#jdbc_ds

3517559

hi Gianni Ceresa,

Sorry for the delay,

yes we are referring the same document.

My point is here, is OBIEE supports NOSQL database as OrientDB is nosql graph database.

vi*398405*78

I have been able to do it after lot of effort.

Versions used:

1. OBIEE : 12C

2. Orient : 3.0.12

3. Java : 1.8.0_162

Steps:

After shutting down the managed server bi_server1 in weblogic copy following JDBC Orient Jars to OBIEE DOMAIN HOME LIB (e.g. C:\oracle\user_projects\domains\dom5\lib where dom5 is domain name) folder:
1. concurrentlinkedhashmap-lru-1.4.2.jar
2. jna-4.5.0.jar
3. orientdb-client-3.0.12.jar
4. orientdb-core-3.0.12.jar
5. orientdb-jdbc-3.0.12.jar
Restart managed server bi_server1 in weblogic
Create the data source with Orient in BI Publisher
1. Class : com.orientechnologies.orient.jdbc.OrientJdbcDriver
2. JDBC String : jdbc:orient:remote:<IP>:<PORT>/<DB_NAME> e.g. jdbc:orient:remote:localhost:2424/betterdemo
3. Give username / password
4. Test connection

Create new Data Model and save it
Create new SQL query and chose orient data source. The data would get displayed