Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OrientDB connection to Oracle BI Publisher 11g

Received Response
1
Views
7
Comments
3517559
3517559 Rank 1 - Community Starter
edited Aug 13, 2024 5:26PM in Oracle Analytics Cloud and Server

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,

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    3517559 Rank 1 - Community Starter

    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
    Gianni Ceresa Mod

    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
    3517559 Rank 1 - Community Starter

    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
    Gianni Ceresa Mod

    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
    3517559 Rank 1 - Community Starter

    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
    vi*398405*78 Rank 1 - Community Starter

    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:

    Steps:

    1. 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
    2. Restart managed server bi_server1 in weblogic
    3. 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

    pastedImage_9.png

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