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.

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

• Import from IJC Database in JChem for Excel

  • Before Import

  • Import from IJC Database-Source Tab

  • Import from IJC Database-Columns Tab

  • Import from IJC Database-Progress Tab

• Import from Database by IDs