Manage Connections in JChem for Office

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

  • Oracle

  • MySQL

  • MSSQL

  • PostgreSQL

  • Instant JChem (This type of database connection is available through a separate button and dialog. For more information, see Import from IJC Database.)

It is possible to connect to database tables and views with a web service. For more information regarding the JChem web services, see the links below:

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

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

The same kind of database connection process is implemented in JChem for Excel.

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

C:\Users\<current user>\AppData\Roaming\ChemAxon\JChem for Excel\Connections.xml

Both JChem for Excel and JChem for Office use this folder.

When re-opening the Import from Database dialog, the last selected connection will be remembered and automatically selected.