Skip to content

Connect Cytoscape and SAP HANA to enable import, export and visualization of graph data stored in SAP HANA.

License

Notifications You must be signed in to change notification settings

SAP/sap-hana-plugin-for-cytoscape

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

36 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

REUSE status

SAP HANA plug-in for Cytoscape

Description

The SAP HANA plug-in for Cytoscape is an app to connect Cytoscape to SAP HANA Graph. The current version delivers a basic integration for interacting with Graph Workspaces on SAP HANA.

Requirements

The plugin is tested to work with Cytoscape 3.10.0, SapMachine 17 and the latest NGDBC Driver.

Functionalities

The current feature scope comprises:

  • Establish connection to SAP HANA (Cloud)
  • Upload a Network to SAP HANA (Cloud)
  • Download an existing (homogeneous) graph workspace to Cytoscape
  • Refresh a downloaded workspace in the client

Download and Installation

Download

The latest (bleeding edge) package can be downloaded in the packages section. Check the Assets list for the latest jar file.

Where to download latest cyHANA jar

Setup

After getting the latest JAR package, you can install the plugin using the Cytoscape App Manager.

The plugin makes use of the SAP HANA JDBC client, which additionally needs to be included on the classpath. The latest version can be retrieved from the SAP Development Tools (look for ngdcb-latest.jar).

On a Mac, you can copy ngdbc-latest.jar to /Applications/Cytoscape_vX.X.X/framework/lib/openjfx/mac. A similar folder exists on Windows machines within the Cytoscape installation.

After installation, you should be able to find the plugin under Apps > SAP HANA.

The Apps menu with installed cyHANA plugin

Usage

Establishing a Connection to SAP HANA (Cloud)

To establish a connection to SAP HANA (Cloud), you will need to enter host, port, username and your password. The settings will be cached locally in the user folder to make future connections more convenient.

SAP HANA Connection Dialog

For even more convenience and at the cost of security, you can optionally store the password.

Please be aware, that your password will be stored as plain text!

You may optionally specify a proxy configuration as well as advanced JDBC properties (format: property1=value2;property2=value2). The advanced JDBC properties may for example be used to specify a Secure User Store (hdbuserstore).

You can check the task history of Cytoscape to verify, that the connection has been established successfully.

Task history after successful connection

Upload a Network to SAP HANA

To upload a network, you first need to connect to your instance of SAP HANA as described above. Also, you need to have at least one network existing in Cytoscape.

If you need a dataset to start testing, you can use one of Cytoscapes samples, that are available on the starter panel. Following screenshots will use the disease dataset from the sample session Styles Demo. Cytoscape Sample Sessions

To upload a network to SAP HANA, choose the respective entry in the apps menu.

Creating a new Graph Workspace

If you have more than one network loaded in the client, you will see a dropdown list at the top of the dialog. The name of the new workspace as well as the names of node and edge table will be proposed based on the network's name.

You can manually change the proposed names. Just make sure, that none of the objects (i.e. graph workspace, node table, edge table) is already existing on the sytem.

Additionally the dialog lets you specify the target database schema. Optionally the schema will be created if it is not existing yet.

Download an existing Graph Workspace

To download a graph workspace, you first need to connect to your instance of SAP HANA as described above. When choosing to load graph workspace, the list will already be pre-populated with all graph workspaces, that have been found on the respective system.

List of graph workspaces

After choosing the respective workspace and confirming with OK, the nodes and edges table will be loaded into Cytoscape. Note, that it will not yet create a visualization, but only show the network on the left panel.

Graph Workspace has been loaded

By choosing Create View, you can create an initial visualization and adapt it using Cytoscape's tools.

Graph visualization

Note, that in the Node Table and Edge Table you can also inspect the attribute data from the respective tables in SAP HANA.

Licensing

Copyright (2021-)2022 SAP SE or an SAP affiliate company and sap-hana-plugin-for-cytoscape contributors. Please see our LICENSE for copyright and license information. Detailed information including third-party components and their licensing/copyright information is available via the REUSE tool.

About

Connect Cytoscape and SAP HANA to enable import, export and visualization of graph data stored in SAP HANA.

Topics

Resources

License

Code of conduct

Security policy

Stars

Watchers

Forks

Packages

 
 
 

Languages