Managing Connections

Back to index page

JChem for Excel (Office) can be connected to the following types of databases:

 

 

You can connect to database tables and views with a web service. You can find detailed information about JChem web services here:

https://restdemo.chemaxon.com/docs/installationguide.html

and here:

https://restdemo.chemaxon.com/apidocs/

 

The same kind of database connection process is implemented in all JChem for Office products. If a connection has been added in one of JChem for Office products, it will be available in all other products after a restart. Connection information will be stored in Connections.xml, which is located under the default local user folder, the same place in all 4 products:

 

C:\Users\<User Name>\AppData\Roaming\ChemAxon\JChem for Excel\Connections.xml

 

When re-opening the Import from Database dialog, the last selected connection will be remembered and automatically selected when opening the same dialog and if the Excel instance has not been closed. In Import By ID and Import IJC dialog this connection information will not be remembered.

 


Back to index page