Sharing data with other applications

Introduction

The Spotfire/JChem4XCL integration acts as an interface between IJC and any 3rd party application. It makes sharing data with applications like SharePoint or Spotfire seamless. The personal server communicates with clients by using the OData specification. This was primarily intended to be used with statistical software such as TIBCO Spotfire and MS Excel. OData it is an open communication standard and can be used with other software supporting the same.

The export to Plexus Analysis feature was introduced in IJC 16.11.7.0. Using this functionality you can easily export your result set for data visualization using ChemAxon’s Plexus Analysis. If you want to learn more about this feature you can read the documentation here.

Licensing

It's required to have an IJC enterprise license installed for enjoyment of personal server functionality in IJC 5.9 and onwards.

Since the 15.10.5.0 release the user has to have the ROLE_EXPORT_DATA assigned to be able to control all types of export actions including the use of Spotfire/JChem4XCL integration. The user roles are described here.

Spotifre/JChem for Excel integration

Previously known, as IJC personal server functionality, it is possible to share data with Tibco Spotfire, or other applications, by turning IJC into a personal server.

To share your data you need to start personal server on IJC. This is accessible via:

Right click on schema -> Start Spotfire/JChem4XLS integration item.

Clicking the dedicated Spotfire/JChem4XLS integration button in the panel

images/download/attachments/42173396/screen1.png

In both cases, the server startup is indicated at the bottom of the screen, with a progress bar.

images/download/attachments/42173396/screen4.png

To set up on which address the server starts, you can do so in the IJC Options dialog, where it can be found under Miscelaneous -> Other Settings as seen on the following screenshot, which shows two text fields where you can specify network interface by entering interface's IP address and the port number to listen on (highlighted in red). Default settings are usually convenient if you are using IJC and your 3rd application on the same local computer.

images/download/attachments/42173396/screen3.png

Interaction with the firewall

Personal server can behave as a network server and it can interfere with the firewall. If you use a Windows operating system and run IJC Personal server for the first time the Windows Firewall dialog is usually (with default settings) automatically popped up as shown below. The data can be provided to any computer on the network depending on your firewall configuration. You do not need to allow access to any network if the Personal server will be accessed only from the local computer which is the usual case. Please permit the access only when you plan to access the data using OData adapter from a different computer. However this is really rare and you should consider it well.

images/download/attachments/42173396/win_firewall_interaction.png

Usage

This section briefly describes usage of OData communication with applications from 3rd parties. You can use various features Depending on the client implementation. One of them is selection synchronisation, making selection in one application is automatically propagated the other.

Collaboration with Spotfire an analytical software tool

Data accessible in IJC are shared over personal server on-line. Change in one project affects the other. Data can be imported into s Spotfire project where can be statistically analysed. Molecules represented as SMILES, Marvin or in other format can be visualized by using Structure Viewer in Spotfire using eg. Marvin renderer.

Instant JChem Extension for TIBCO Spotfire

Install the extension to a Spotfire server according to the manual "Deploying the IJC OData extension into Spotfire" in ( admin docs ).

During logging you will be prompted for update of Spotfire client. The extension distributed from server is needed for proper interaction between IJC and Spotfire. After update enter your credentials again and sign up. If the extension was properly installed you can run import dialog from the menu, File -> Open From -> Import from IJC , or use the appropriate icon from the toolbar.

IJC OData import wizard has 2 simple steps. In the first step, enter the personal server IP address and specify the port. You can select one of the servers previously used on your computer.

images/download/attachments/42173396/Spotfire_dialogue.png

The dialog that follows asks what data trees to import. There are a few options.

  • Result Set option asking whether all data or just the query result will be imported.

  • Synchronization with Instant JChem can be enabled or disabled.

  • Structure format.

images/download/attachments/42173396/Personalserver2.png