You can connect DB Navigator to multiple databases. Here is an overview of how to connect DB Navigator to a database (follow the links for more information about the tasks). Obtain or create a user account for the database. You must provide a login to access a SQL database. When you try to connect to a database in DB Navigator, you are prompted for a user ID and password. For other details about the specific database you are working with, see the relevant database documentation.
Note: (For OpenEdge databases only) If no user accounts have been established, you can use the Windows login name of the person who created the database as the user ID.
  1. Configure a JDBC driver—DB Navigator requires a JDBC driver in order to connect to a database and supplies JDBC drivers for various database types. In most cases, the driver is installed and configured automatically during installation of DB Navigator. If, however, the JDBC driver for your database requires driver configuration, see Configure a JDBC driver for more troubleshooting information.
  2. Start the database server—You cannot connect to a standalone database. You must start a database server before connecting to the database. To start OpenEdge databases, you can use either OpenEdge Management or OpenEdge Explorer, or the OpenEdge proserve command.
    Note: Since JDBC drivers execute SQL statements, you must start databases that can service SQL clients. For OpenEdge databases, ABL access is required for trigger maintenance. Therefore, create a server with a client type of Both 4GL and SQL (which is the default).
  3. Open and close SQL connections—You can select and open an existing SQL connection, or you can Add SQL connection profiles and open it. Connection profiles contain connection information, which includes, among other details, the name of the driver, a URL expression, a user name, and a password.
  4. DB Structure view view—When you open a connection profile for a database, the schema for the database appears in the DB Structure view view.