Table of Contents

Sharing data with other applications

Introduction

Personal server is a key new feature in IJC 5.8. It 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.

Licensing

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

Starting personal server

To share your data you need to start personal server on IJC. This is done by using the personal server manager. It is accessible via:
Right click on schema -> Personal Server Manager... item.
A Simple dialog for starting the server on a given port appears. Unrolling + Advanced Settings shows two text fields where you can specify network interface by entering interface's IP address and the port number to listen on. Default settings are usually convenient if you are using IJC and your 3rd application on the same local computer. IJC server side is ready to use after pressing the Start button.

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 or in other format can be visualisation using xyz extension.

Instant JChem Extension for TIBCO Spotfire

Install the extension to a Spotfire server according "Deploying the IJC Odata extension into Spotfire" manual.

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 used appropriate icon from the toolbar.

IJC OData import wizard has 3 simple steps. In the first step you need only to enter personal server IP address and specify the port. If you already have imported something during this session Finish button is enabled and you can import data using default settings(Current data rows with molecules in smiles) simply by one click action.

Second step ask you what to import. There are three options.

• Import currently viewed rows in IJC - eg. after query
• Import all data in selected data tree
• Use OData query as a filter

Choosing a prefered molecule format.

---