Connecting to an Oracle Database

Back to index page

In case of Oracle databases you can connect to tables, views and synonyms. Synonyms will be displayed in your connection list if you specify the appropriate option in Options/General/Database Connection.

 

Adding a new TNS Names based connection

  1. Click on the Import from Database ribbon button in Advanced menu set to open the Import from Database form.

       Ribbon.ImportfromDatabase

       

       

  1. Click on the Add Connection icon on the toolbar.

 

       Form.ImportfromDatabase.AddConnection

 

  1. Select the TNS connection type radio button.
  2. Fill the Connection Name with anything you prefer.
  3. You can create the connection with or without integrated authentication, by checking in the appropriate check-box. If you use integrated authentication the Username and Password fields and password related check-boxes will be disabled and cleared. Please note that Integrated Authentication option is available only for Oracle type databases (with Basic and TNS type connections).
  4. Fill User Name, Password.
  5. Fill the network alias of the Oracle database, specified in the TNSNAMES file.
  6. Click OK to save the connection info.

       Form.ManageConnections.TNSType

 

  1. The new connection is displayed as a new node in the Connections tree-view. Connecting to JChem Cartridge requires Oracle Client when you would like to use TNS type connection. See the Admin Guide for more details.

       Form.ImportfromDatabase.Connections1

 

Adding a new Basic connection

  1. Click on the Add Connection icon on the toolbar or right click the Connections.xml root node and select Add Connection from the context menu.

 

       Form.ImportfromDatabase.AddConnection

 

  1. Select the Basic connection type radio button.
  2. Fill the Connection Name with anything you prefer.
  3. You can create the connection with or without Integrated authentication, by checking in the appropriate check-box. If you use integrated authentication the Username and Password fields and password related check-boxes will be disabled and cleared. Please note that Integrated Authentication option is available only for Oracle type databases.
  4. In other cases fill in User Name, Password.
  5. Fill the host name or IP address where the Oracle database can be found.
  6. Fill the port number.
  7. Fill the SID of the Oracle database, specified in the TNSNAMES file.
  8. Click OK to save the connection.

       Form.ManageConnections.BasicType

 

  1. The new connection is displayed as a new node in the Connections tree-view.

       Form.ImportfromDatabase.Connections1

 


Back to index page