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.