Oracle Spatial and Graph – technical tips, best practices, and news from the product team

Effective Graph Visualization with Cytoscape and Oracle's Property Graph Database (3)

Alan Wu

In this installment of the Cytoscape visualization for Oracle's Property Graph Database series, I am going to talk about key steps to make your first connection to a backend property graph (PG) database. Remember Oracle offers a PG DB on Big Data as well as a PG DB on big data platform.

First of all, I'd like to make a quick announcement. Very recently, we released a Cytoscape Plugin for Oracle Database 18c. It is designed and tested for Oracle Database 18c. And we have fine tuned and improved performance when running Cytoscape client against a remote Oracle 18c database. To get this plugin, please click here and choose the one dated May 2018.

Now, let me switch back to making connections to a backend PG database. There are two cases:

1) the backend PG database is an Oracle Database. Start Cytoscape, click File, Load, Property Graph, and Connect to Oracle Database. A screenshot is shown below.

After that, type in JDBC connection url, username, password, and click the magnifier icon which is highlighted below. This is going to start a graph DB connection. Once a connection is established, you will see a drop down list under the "Graph name" and it is then up to you to pick a graph to start your visualization.

2) the backend PG database is either an Oracle NoSQL Database or an Apache HBase. The steps are almost identical other than the database connection settings are different among Oracle NoSQL Database, Apache HBase, and Oracle Database.

Hope this helps you get started.



Join the discussion

Comments ( 1 )
  • Eugene Wednesday, December 18, 2019
    I am not able to see cytoscape File -> Load option with 3.7.2 I installed. wonder why
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.