Connecting to a Database
Before you can connect to a database, you must create a server connection.
To create a connection:
- On the Database menu, click New Connection. The Database Connection Properties dialog box opens.
- In the Server combo box, click Browse…. The Browse for Servers window opens.
- On the Local Servers tab, select an Oracle instance (if any). Otherwise, click the Network Servers tab to select an Oracle instance in the network.
- Select the Authentication type, either Oracle authentication or Windows authentication.
- Enter the login credentials in the User and Password fields.
- In Database, type or click the name of the database which you want to connect to.
- In the Connection Name text box, the connection name should be generated automatically from the host name. You can create a distinctive name for your new connection.
- (optional) You can assign a document category to the new connection.
- (optional) You can click Advanced to configure advanced connection properties.
- (optional) Click the Test Connection button to verify the connection.
- Click OK to create the connection.