Import from Database in JChem for Office

    It is possible to import structures and other data from the JChem Oracle Cartridge and JChem Base tables.

    The table below shows a summary of the data and structure handling.

    Data Import and Search Structure Import Structure Search
    Tables Views Tables Views Tables Views
    Any Kind of Databases images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/error.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/error.svg
    JChem DB (JChem Engine) images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/error.svg
    JChem DB (Cartridge Engine) images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg images/s/en_US/8100/6512c1e2a41cdf14570641b46bd2fe3eaeb38d03/_/images/icons/emoticons/check.svg

    Please note that currently we can import from PostgreSQL database, but not through the JChem PostgreSQL Cartridge. Also, in case of Oracle database, the JChem Oracle Cartridge is supported but JChem Choral is not.

    If a table is a JChem Base table, and it also has a Cartridge domain index, the search method can be selected in Search Options. It is also possible to select the target column with the cartridge search if more than one structure column contains an index in the table.

    {info} JChem Base tables could be created using JChem Manager, or Instant JChem.

    The Import from Database dialog consists of the following tabs: