Manage Connections

    Watch this video to find out more about how to configure database connections in JChem for Excel/Office.

    JChem for Excel 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 all JChem for Office products. 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. In Import By ID and Import IJC dialog this connection information will not be remembered.