Database Connection Options

The figure below shows the database connection options of JChem for Excel.

images/download/attachments/1806987/Database_Connection_Options.png

Database Tables

Show Only Favorite Database Tables

This option affects the default state of the Show only favorites check-box which is used on the Import from Database dialog.

Possible values are as follows:

  • TRUE

  • FALSE

The default value of this option is FALSE.

Field Filtering

Default Database Field Filter

By using this option, you can specify the default field filter file that is used during the database import process.

For more information about using the filter file during the database import process, see Import from Database-Columns Tab.

Oracle

Oracle Provider

To connect to an Oracle database the following providers can be selected:

  • Oracle JDBC

  • Oracle ODP.NET

The default value of this option is Oracle JDBC.

Show Other Users

Use this option to specify if the tables of other users are accessible and searchable (with rights configured properly) or not.

Possible values are as follows:

  • TRUE

  • FALSE

The default value of this option is FALSE.

This option is valid only for Oracle tables.

Oracle and Microsoft SQL Server

Show Synonyms

Use this option to specify if you would like to display database synonyms in your database connection list or not.

Possible values are as follows:

  • TRUE

  • FALSE

The default value of this option is FALSE.

This option is valid only for the following connection types:

  • MySQL

  • MSSQL

  • Oracle database

  • JChem web services