Importing from Databases in JChem for Excel

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

  • Add an Oracle Connection in JChem for Excel

  • Add a MySQL Connection in JChem for Excel

  • Add an MSSQL Connection in JChem for Excel

  • Add a PostgreSQL Connection in JChem for Excel

  • Add a JChem Web Services Connection in JChem for Excel

  • Favorite Entities in JChem for Excel

  • Edit and Delete Connections in JChem for Excel

• Import from Database in JChem for Excel

  • Import from Database-Database Tab

  • Import from Database-Query Tab

  • Import from Database-Columns Tab

  • Import from Database-Rows Tab

  • Import from Database-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 in JChem for Excel

  • Import from IJC Database-Source Tab

  • Import from IJC Database-Columns Tab

  • Import from IJC Database-Progress Tab

• Import from Database by IDs