Importing from Databases in JChem for Office

It is possible to connect to different types of databases to import and analyze the data from these databases.

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

For more information about how to create a JChem connection to different types of databases, see Administration Guide - JChem Manager.

This section consists of the following subsections:

• Manage Connections in JChem for Office

  • Add an Oracle Connection in JChem for Office

  • Add a MySQL Connection in JChem for Office

  • Add an MSSQL Connection in JChem for Office

  • Add a PostgreSQL Connection in JChem for Office

  • Add a JChem Web Services Connection in JChem for Office

  • Favorite Entities in JChem for Office

  • Edit and Delete Connections in JChem for Office

• Import from Database in JChem for Office

  • Import from Database in JChem for Office-Database Tab

  • Import from Database in JChem for Office-Query Tab

  • Import from Database in JChem for Office-Columns Tab

  • Import from Database in JChem for Office-Rows Tab

  • Import from Database in JChem for Office-Progress Tab

  • Please check this video about how to import structures and data with JChem for Office from different types of databases: https://www.youtube.com/watch?v=1460XtELLIs&t=10s

• Import from IJC Database

  • Import from IJC Database in JChem for Office-Source Tab

  • Import from IJC Database in JChem for Office-Columns Tab

  • Import from IJC Datebase in JChem for Office-Rows Tab

  • Import from IJC Database in Jchem for Office-Progress Tab