Forum Stats

  • 3,757,473 Users
  • 2,251,230 Discussions
  • 7,869,837 Comments

Discussions

OBIEE communication with PGX server

Soheil Star
Soheil Star Member Posts: 54 Blue Ribbon
edited Sep 7, 2021 11:55AM in RDF Graph & Property Graph

Hi guys

Does any one know how OBIEE and PGX communicate together ? Actually I wanna use Oracle Graph Server and PGX graph result in OBIEE, execute dashboard with PGQL statement and fetch graph algorithm from PGX server.

Could you please help me to figure out it.

Thanks

Tagged:

Comments

  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,293 Gold Crown

    Hi,

    They don't, OBIEE and PGX do not communicate in any possible way.

    Graph Server doesn't have an ODBC or JDBC driver, and that would have been the only OBIEE could communicate with it.

    You can still develop a web app using the Rest API of Graph Server, and because it's a web app you can add it into a frame in an OBIEE dashboard, but that's about it.

    Soheil Star
  • Soheil Star
    Soheil Star Member Posts: 54 Blue Ribbon

    Thank you Gianni

    But could you please explain more about how to use PGX REST API in OBIEE dashboard. Could you give me some example of using REST in OBIEE.


    Regards

  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,293 Gold Crown

    PGX has a REST API exposing all the methods, OBIEE isn't going to use that at all.

    You will develop a web application using Javascript for example, and OBIEE being a web app as well, you can add a frame in a dashboard embedding your web app. Or if you are brave enough adding the javascript code directly in the dashboard page.

    Forget OBIEE in this: if you can develop a web app that does the job, showing it into an OBIEE dashboard will not be a problem, it will take you 5 minutes. Developing the web app interacting with PGX will take you days or weeks.

    Is it worth it? Let's be honest, the answer is probably no...

    There are other ways to interact with PGX that are a lot easier, for example a notebook using the Apache Zeppelin client or pypgx in Jupyter using python. In Jupyter you could make an interactive screen using other plugins adding buttons, drop-down lists etc. to your notebook. In this way it's interactive, users don't need to write code and you have python doing the job of interacting with PGX.

    You maybe also should consider Graph Studio (the cloud service on top of Autonomous database) coming with Apache Zeppelin notebooks and visualizations etc.

    Soheil Star