Connection Dialog

The connection dialog opens each time you want to connect to the database.

Connection Alias

Alias is a name you give to this connection, used to refer it inside DbSchema. You can choose any name you like.

Rdbms

This is the database you want to connect to. You can add new databases to the list by clicking '...' button.

JDBC Driver

Choose from one of the pre-configured drivers in DbSchema. Clicking the '...' button you can manage the drivers and URL patterns. Pay attention here, in this combo you may choose a different driver if you connect local or remote, or depending on authentication ( like for SqlServer ).

Server Location

This are the settings required to locate on which machine is the database running.

Database Host

The Host where the database software is running. This can be on the same machine as DbSchema ( localhost ) or an a remote machine. This can be the machine name or IP. If the database runs on the same machine as DbSchema use 'localhost'. Find the right value :
  • Windows : press the Windows key ( with the Windows symbol on it ) at the same time with the Pause/Break key ( usually placed upper-right on the keyboard ). A dialog will show up. Look for the computername.
  • Linux : execute hostname in the terminal
From your computer test the host name by executing ping [host] in command prompt ( or terminal ). Don't try to use http://www.... names. This are used by internet browsers ! Here is required the physical machine name or IP !

Firewalls running on the server or on the current machine may block the access to the database server. Please consider disabling them. Search the internet to learn how.

Sample host names:

  • Simple names, like myserver
  • Names with domains, like myserver.mycompany. If the domain is wrong the server cannot be found.
  • IPs like 192.168.1.21

Database Port

The Port is a number ( the port where to connect ). Usually preset by DbSchema. If not, you have to check the database documentation for the correct value.

Database Authentication

The database protects your data using its own username and password.

Database User and Password

The Username and Password of the user account in the database. This are usually set during database installation. Some databases uses standard users like 'sa' or 'root'. Other databases requires Windows user and password for the database too. Click on your database to read about standard username and password.

Target Database

One server may have multiple databases. Here you can choose the database you want to use. This can be a text or a file location, depending on each Rdbms. For some databases like MySql, Postgres, etc... you can choose one database from one combo. Some databases require to enter here the path to the database file. For Oracle is required the SID ( read more on Oracle help page ).

SSH Tunnel

The SSH tunnel is explained on this page

Advanced options

Here you can specify a custom URL to be used. This shouldn't be edited unless you need to use a custom pattern or add some specific parameter. The Connection Dialog is asking the host, user, port,... values and replaces them in the configured URL pattern. Learn more about JDBC URLs here.

Database Mapping

Use this setting if you already have a schema in DbSchema and you connect to a database where the same schema has a different name. This will allow to relate two schemas with different names.