3. Getting Started with OpenROAD Workbench : How to Start OpenROAD Workbench : Define a Database Connection Profile
 
Share this page                  
Define a Database Connection Profile
To use any of the Workbench tabs other than the Connect tab, you first must connect to a database through a database connection profile. Therefore, you must create at least one connection profile before you can connect to a database.
You can create connection profiles to connect to existing databases or you can create a new database for the connection. You create database connection profiles on the Connect tab using the OpenROAD Startup Assistant. For information about fields and parameters used in the OpenROAD Startup Assistant, see OpenROAD Startup Assistant and Connection Details Properties (see OpenROAD Startup Assistant and Connection Details Properties).
Note:  If this is the first time you have started this version of OpenROAD, the OpenROAD Startup Assistant will prompt you to create a new database connection profile. See OpenROAD Startup Assistant and Connection Details Properties.
To create a database connection profile to connect to an existing database
1. Click the Connect tab.
2. Click File, New Profile.
The Connection Profile Assistant opens.
Click Next.
3. Select Existing Database and click Next.
4. Select whether the database is a local or remote connection.
A vnode is a virtual node, which provides all connection data to connect to an Ingres installation on a remote system. For more information, see the Ingres Network Management Utility (netutil) or Network Utility (ingnet) in the Ingres Connectivity Guide.
5. Select the database.
6. Specify connection options.
For more information about connection options, see the SQL command in the Ingres Command Reference Guide.
7. Name the profile and optionally provide a description.
The profile name must be unique.
To create a database connection profile to create a new database
1. Click the Connect tab.
2. Click File, New Profile.
The Connection Profile Assistant opens.
3. Select Create Database and click Next.
4. Select whether the database will be created on a local or remote machine.
A vnode is a virtual node, which provides all connection data to connect to an Ingres installation on a remote system. For more information, see the Ingres Network Management Utility (netutil) or Network Utility (ingnet) in the Ingres Connectivity Guide. For more information about flags that can be used with the connection command, see CREATEDB in the Ingres Command Reference Guide.
5. Select the database.
6. Specify connection options.
For more information about connection options, see the SQL command in the Ingres Command Reference Guide.
7. Name the profile and optionally provide a description.
The profile name must be unique.