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.