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.
The plugin is tested to work with Cytoscape 3.10.0, SapMachine 17 and the latest NGDBC Driver.
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
The latest (bleeding edge) package can be downloaded in the packages section. Check the Assets list for the latest jar file.
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.
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.
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.
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
diseasedataset from the sample sessionStyles Demo.
To upload a network to SAP HANA, choose the respective entry in the apps menu.
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.
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.
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.
By choosing Create View, you can create an initial visualization and adapt it using Cytoscape's tools.
Note, that in the Node Table and Edge Table you can also inspect the attribute data from the respective tables in SAP HANA.
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.