Skip to content

Manage Connections in JChem for Office

Watch this video to find out more about how to configure database connections in JChem for Excel/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.