Add an Oracle Connection in JChem for Excel

In the case of Oracle databases, it is possible to connect to tables, views, and synonyms. Synonyms are displayed in the connection list if Options > Database Import > Oracle and Microsoft SQL Server > Show Synonymsis set to TRUE.

TNS Connection

To add a TNS Oracle connection, follow the steps below.

1. Click the Import ribbon button under the Database group.

   

2. Click Add Connection or right-click the Connections root node and select Add Connection from the context menu. By default, the Save Password and the Encrypt Password checkboxes are ticked.

   

3. On the Oracle tab, select the TNS radio button.

4. Enter the Connection Name.

5. Enter the User Name and the Password (to use Automatic Authentication tick the checkbox).

6. Enter the network alias of the Oracle database, specified in the TNSNAMES file.

   

7. Click OK to save the connection.

Basic Connection

To add a Basic Oracle connection, follow the steps below.

1. Click the Import ribbon button under the Database group.

   

2. Click Add Connection or right-click the Connections root node and select Add Connection from the context menu. By default, the Save Password and the Encrypt Password checkboxes are ticked.

   

3. On the Oracle tab, select the Basic radio button.

4. Enter the Connection Name.

5. Enter the User Name and the Password (to use Automatic Authentication tick the checkbox).

6. Enter the hostname or IP address where the Oracle database can be found.

7. Enter the port number.

8. Enter the database name of the Oracle database, that is the Oracle System ID (SID).

   

9. Click OK to save the connection.